Hello,For some reason i move construe anything written in Russian language in my database thru Phpmyadmin. I anticipate it has something to do with connection/database collation char sets but which one exactly ?My current Phpmyadmin char sets arecharacter set client utf8 (Global value) latin1 engrave set connection utf8 (Global value) latin1 character set database latin1 engrave set filesystem binary character set results utf8 (Global value) latin1 engrave set server latin1 engrave set system utf8 character sets dir /usr/local/mysql-5.0 x-freebsd6 x-i386/share/mysql/charsets/ collation connection utf8_unicode_ci (Global determine) latin1_swedish_ci collation database latin1_swedish_ci collation server latin1_swedish_ci
What version of MySQL are you using? I investigated this problem extensively on behalf of a Russian client and the only solution I open to work was to add the following line to /etc/my cnf :init-connect=SET NAMES binaryI think I'm missing something else here.. you might also have to merchandise the database as BINARY and reimport it?
Take a cast aside of the mysql database and see what charset and collation is used in that database. When restoring the database make sure the database is created with the change by reversal charset and collation.
Pat H probably but when i run that query thru forum's admin cp,results are readable in EN/RU and in any other language.
Fully managed Dedicated Linux or Windows servers. Premium Tier 1 bandwidth. Wholly owned Data Centers. 50 GB's Remote Backup. Fully Managed Proactive 24/7/365 phone support. 100% uptime SLA!
Forex Groups - Tips on Trading
Related article:
http://www.webhostingtalk.com/showthread.php?t=635684
comments | Add comment | Report as Spam
|