Using a "|" in a text field
Noticed with the flat file that if someone uses the pipe (|) character in a text field, that field is truncated at the pipe - presumably since this is your field delimeter. Haven't checked it in the mySql database.
Since we can't control the data entry of all users, I would suggest that you add an error checking routine that either warns the user to replace the character, provide for an admin selected replacement character, or do an automatic replacement using another character (like * or ~ perhaps).
Found this while trying to parse the database text file.