|
|
Posted by Jerry Stuckle on 07/29/06 13:53
Joshua Morgan wrote:
> 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.
>
Since all of your info is about MySQL, maybe you should ask in a MySQL
newsgroup - such as comp.databases.mysql.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|