MYSQL Query Help

[BlackRaven]

Hi,
My Mysql4 DB is UTF-8 Unicode format however i need to run the following query

UPDATE user SET password = MD5(CONCAT(MD5('userpassword'), salt)) WHERE userid = 1

in latin1_swedish_ci. How do i modify the query? Thanks

[mcibor]

Typically CONVERT is used to do that:

UPDATE `table` SET `value` = '10' WHERE CONVERT( `setting` USING utf8 ) = 'amount' AND CONVERT( `value` USING utf8 ) = '1' LIMIT 1 ;

I just don't know where and what for you want to put it into your code,
but maybe it will give you an idea.

Regards
Michal