Can not display correctly utf8 data with
Posted by: nt21k
Date: September 12, 2005 05:59AM


I got a problem with mysql database using to retrieve data. I stores datas under format text utf8 via phpMyadmin into Mysql server. Then I make a connection to this database using to retrieve the data. The result is that the data is displayed correctly with phpMyadmin but is not displayed correctly in the web page.

Of course, I have added charset=utf8 at the end of the connection string as suggested in some posts. I also tried to modifiy the column or table with utf8 as following :

ALTER TABLE test CHARACTER SET utf8 COLLATE utf8_general_ci;

It shows me an error of syntax.

SHOW VARIABLES give me that the character set is latin1, but I can not set it again to utf8 with SET CHARACTER SET utf8;

The data stored in Mysql database is in vietnamese and the driver used to connect is MyODBC 3.51.

Thank you for your helps.


Options: ReplyQuote

Written By
Can not display correctly utf8 data with
September 12, 2005 05:59AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.