Problems with unicode utf8

[Joshua Morgan]

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.

[Jerry Stuckle]

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.
js*******@attglobal.net
==================

[Joshua Morgan]

I actually managed to get help via IRC.

I posted it here because I thought it may have been a PHP issue (i.e.
not being able to change connection's character set and collation via
PHP).

Thanks,

Josh

Jerry Stuckle wrote:

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.
js*******@attglobal.net
==================

[Jerry Stuckle]

Joshua Morgan wrote:

Jerry Stuckle wrote:

>>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.

I actually managed to get help via IRC.

I posted it here because I thought it may have been a PHP issue (i.e.
not being able to change connection's character set and collation via
PHP).

Thanks,

Josh

(Top posting fixed)

Joshua,

Not a problem posting here - I was just trying to direct you to the
group which should provide better help. All of your comments had to do
with MySQL and nothing was PHP specific, which might give you a clue
that a mysql newsgroup would be a better place to start.

If, OTOH, you were having trouble with the PHP end such as getting
mysql_fetch_array() to work properly, this would be a good place to start.

I'm glad you were able to get help via IRC.

P.S. Please don't top post. This newsgroup uses bottom posting as a
standard. Thanks.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================