Charset/SQL

Charset/SQL

am 29.05.2006 17:00:36 von Oliver Block

Hi list,

I get data from an HTML page that has charset UTF-8 (meta-element) and the
table has $encoding=mysql_client_encoding(...). Now I do a

$result = mysql_query(iconv("UTF-8", $encoding, $sql), $db_handle);

to change encoding of user data. $sql is the complete SQL query.
Might there be any problem that this code is not aware of? (I know that I
implicitly assume that the code can be converted from utf8 to $encoding which
is ISO-8859-1 for the database used. MySQL has Version 4.0.24)

tia,

Oliver

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php