[osflash] mySQL database problem with greek.
darren at dcook.org
Sun Jan 6 15:32:18 PST 2008
> When I insert and show english text from the database it all works fine.
> When I insert greek text in the database, it is shown in the flash with
> "?????" and if I look in the phpAdmin, the data isnt inserted corrrectly.
> Moreover, when I insert greek text throught the phpAdmin, it also doesnt
> show correctly in the flash.
> The encoding in the database is set to utf_unicode_ci.
Assuming your data is in UTF-8 and isn't genuinely being corrupted
somewhere along the way, the usual cause of this is that you need to pass:
SET NAMES UTF8;
to mysql at the beginning of your database session. E.g. send it just
http://dcook.org/mlsn/ (English-Japanese-German-Chinese free dictionary)
http://dcook.org/work/ (About me and my work)
http://dcook.org/work/charts/ (My flash charting demos)
More information about the osflash