|
|
Posted by Joshua Morgan on 07/29/06 08:39
Hey,
Currently me and a friend are coding up a new BitTorrent tracker. We
have a torrents table that has a column called 'info_hash' which
contains the info_hash as received by the announce.php script (this is
used to identify the torrent).
If we have the collation as latin1_general_ci, and I don't send any SET
NAMES OR SET CHARACTER SET queries after connecting, my announce script
can successfully retrieve the row from the torrents table. We however
want to use unicode throughout the project.
When I changed the charset of the table/db to utf8, the select
statement stopped working. It should be noted however that phpmyadmin
can successfully execute the same query when the table/db is set to
utf8.
After calling mysql_connect I send SET NAMES 'utf8' and SET CHARACTER
SET 'utf8', but when I called mysql_client_encoding is returns latin1
however, which is what I think is the problem.
I am using PHP 5 and Mysql 5. Can anybody help me out?
Thanks.
Navigation:
[Reply to this message]
|