|
|
Posted by Jerry Stuckle on 07/30/06 15:28
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.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|