Problem of Connection Character Sets and Collations
| From: | edwardspl at ita dot org dot mo | Date: | Sat, 06 Sep 2008 14:41:26 +0000 |
| Subject: | Problem of Connection Character Sets and Collations | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-279592@lists.php.net to get a copy of this message | ||
Dear All,
For displaying with unicode Character Sets problem :
MySQL :
Command line of mysqldump and mysql :
Which command line is right ?
1, --default-character-set=utf8
2, --default-character-set=utf-8
phpmyadmin :
The Connection Character Sets and Collations setting :
Which command line is right ?
1, utf8_bin
2, utf8_general_ci
3, utf8_unicode_ci
php :
Which command line is right ?
1, mysql_query("SET NAMES utf8");
2, mysql_query("SET NAMES utf-8");
Many thank for your help !
Edward.