Character set, collation problem.
Posted by: amit sankhala
Date: November 14, 2007 11:05PM

I have some diacriticals (special characters such as é or á or ü).
it is already stored in the database as it is shown in ISO-8859-1 charset of browser.

Are we able to convert such character to utf8, in order to make it readable.

For example :
It is stored in the database like "Villarrosà s" but when you fetch this character into the browser it appears like "Villarrosàs".

Is there any method in mysql to convert it in the utf8 or some other solutions to deal with at mysql database level.

Please let me know if you have any queries.

Amit Sankhala

Edited 1 time(s). Last edit at 11/15/2007 12:48AM by amit sankhala.

Options: ReplyQuote

Written By
Character set, collation problem.
November 14, 2007 11:05PM

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.