Re: Problem of Connection Character Sets and Collations

Boyd, Todd M. wrote: >>-----Original Message----- >>From: edwardspl@ita.org.mo [mailto:edwardspl@ita.org.mo] >>Sent: Saturday, September 06, 2008 9:41 AM >>To: mysql@lists.mysql.com >>Cc: php >>Subject: [PHP] Problem of Connection Character Sets and Collations >> >>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 >> >> > >MySQL question. There's got to be a mailing list on >http://www.mysql.com >. > > > >>phpmyadmin : >>The Connection Character Sets and Collations setting : >>Which command line is right ? >>1, utf8_bin >>2, utf8_general_ci >>3, utf8_unicode_ci >> >> > >PHPMyAdmin question. PHPMyAdmin, while written in PHP, is not PHP. This >would be like asking Internet Explorer questions in a Visual C/C++ >mailing list/forum. > > > >>php : >>Which command line is right ? >>1, mysql_query("SET NAMES 'utf8'"); >>2, mysql_query("SET NAMES utf-8"); >> >> > >Again, a MySQL question. I have to admit, though--you were tricky with >this one. Wrapping your SQL code in a PHP function and posing it as a >PHP question was awful slick. This question by itself is, I suppose, >fairly relevant to PHP (in spite of its underlying MySQL subject >matter)... but the other two are just bizarre and wholly unrelated, to >be honest. > >Just to show I'm not an entirely negative person, I did some searching. >After a Google session that lasted all of about a minute and a half, I >found this page: >http://dev.mysql.com/doc/refman/5.0/en/charset-syntax.html which >shows >"utf8" being used in a MySQL command. My guess is that answer #1 and >answer #3 are "utf8" instead of "utf-8". > > >Todd Boyd >Web Programmer > > Hello Todd, So, do you means as the following (If we need define the unicode character sets )? For php connection with MySQL : mysql_query("SET NAMES 'utf8'"); For running MySQL command line ( such as mysqldump and mysql ) : --default-character-set=utf8 For using phpmyadmin ( Choose Connection Character Sets and Collations setting ) : use utf8_general_ci ( NOT use utf8_unicode_ci ) What different between them ? Are these setting right ? Thanks for your help ! Edward.