Not sure whether this is applicable to your version of mysql, or to PHP. I had the same problem using Macromedia's Coldfusion, and adding this:
useUnicode=true&characterEncoding=UTF-8 to the db connection string solved the problem chris -----Original Message----- From: MySQL [mailto:[EMAIL PROTECTED] Sent: 05 September 2004 07:06 To: MySQL Subject: Storing foreign characters in DB I'm having a problem figuring out how to deal with foreign characters in text that was copied from an MS Word document and pasted into a form field, then stored in a MySQL DB. (I have MySQL 3.23.58 running). I'm not how sure how these characters are being stored in the MySQL database, but, when I retrieve the text and run it through PHP's htmlentities() function, each foreign character is converted into 2 other foreign characters that don't at all represent the original. For example, a lowercase u with an umlat over it (ü) is somehow displayed as an uppercase A with an umlat over it followed by the 1/4 symbol after parsed by htmlentities(). A lowercase o with an ulmat displays as an uppercase A with an umlat over it followed by the paragraph symbol. It seems that the uppercase A w/umlat is a constant, and the next character changes. How are these foreign characters being stored in the DB? Do I need to do something in order to store these characters properly, or is this something I need to somehow do on the PHP side of things?? Thanks! Monty. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
