> I have inserted some spanish data into one table. The database
> charset is utf8 and collation is utf8_general_ci. Now when I see the
> rows of the table in MySQL console, the rows are fetched properly. But
> whenever I try to see the rows from this table from any application
> like Java or PHP, I always get garbage data for the Spanish
> characters. Same is the case with tools like SQLYog and MySQL Query
> Browser.
In the (internet) browser, check view->encoding. If it is not utf-8,
then the characters are probaly misinterpreted. In PHP.INI, you can set
the character set to utf-8.
I was not able to get SQLYog or even phpMyAdmin to show the right
characters, but I did get my database and webpages to write and
understand utf-8.
> Am I missing something from the database side that can fix this
> problem?
SHOW VARIABLES LIKE '%char%'
There are lot of encoding settings, alas.
Best regards,
--
Willem Bogaerts
Application smith
Kratz B.V.
http://www.kratz.nl/
|
