List:General Discussion« Previous MessageNext Message »
From:Chris Blackwell Date:September 6 2004 5:38pm
Subject:RE: Storing foreign characters in DB
View as plain text  
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:mysql@stripped] 
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/mysql?unsub=1




Thread
Storing foreign characters in DBMySQL5 Sep
  • Re: Storing foreign characters in DBRhino5 Sep
    • Re: Storing foreign characters in DBvalentin_nils6 Sep
      • Re: Storing foreign characters in DBMonty6 Sep
  • RE: Storing foreign characters in DBChris Blackwell6 Sep