having to debug encoding problems
best regards
ziv gabel
מאת: Bastien Koert [mailto:[EMAIL PROTECTED]
נשלח: ו 09/09/2005 20:05
אל: [EMAIL PROTECTED]; php-db@lists.php.net
נושא: RE: [PHP-DB] Possible MySQLi extension BUG!
Questions:
1. what is the current databas
Actually,
If you add the following line to my.cnf you'll get the same results,
permanently
[mysql]
default-character-set=utf8
[mysqld]
default-character-set=utf8
The last statement should be added AFTER all other configs... if not,
it will not work. In other works, add the line at the end o
Renich Bon Ciric wrote:
Firs of all, I wanna say I have spent a whole week looking for answers
elsewhere. The reason of this message is to look for a practical solution.
I just spent the last 2-3 days converting my entire database (and
website) from charset latin1 (ISO-8859-1) to utf8. Al
en Koert <[EMAIL PROTECTED]>
CC: php-db@lists.php.net
Subject: Re: [PHP-DB] Possible MySQLi extension BUG!
Date: Fri, 09 Sep 2005 13:11:32 -0500
1.- Yes, Everything is UTF-8 with utf8-general-ci as collation
2.- Yes, as I said before
3.- I need to ashure that the query gets there as it is...
can you cut'n'paste the query into the GUI tool for the db and test the
query there?
Bastien
From: Renich Bon Ciric <[EMAIL PROTECTED]>
To: php-db@lists.php.net,Bastien Koert <[EMAIL PROTECTED]>
CC: php-db@lists.php.net
Subject: Re: [PHP-DB] Possible MySQLi extension
1.- Yes, Everything is UTF-8 with utf8-general-ci as collation
2.- Yes, as I said before
3.- I need to ashure that the query gets there as it is...
Bastien Koert wrote:
Questions:
1. what is the current database collation and character set? check with
whatever GUI tool you use to admin the db
Questions:
1. what is the current database collation and character set? check with
whatever GUI tool you use to admin the db
2. Are they the same? ie UTF-8
3. the query of course would be correct since it hasn't touched mysql yet.
Its a straight representation from PHP.
Notes:
1. Spaces in