Code:
1) For mysql_connect(), you need to publish “SET NAMES (Your Character Code)” everytime after reconnecting to MYSQL.
We do .. but not if charset is (default)
this function is called every time:
Code:
[code]function SetName ( $mysql )
{
global $charset;
WriteLog ( “Enter SetName” );
if ( $charset === NULL )
return;
$query = 'SET NAMES ' . $charset;
if ($charset!=”[default]”) {
yog_mysql_query ( $query, $mysql );
}
WriteLog ( “Exit SetName” );
return;
}
[/code]
note:
Quote:
if ($charset!=”[default]”)
We have reproduced the issue with 'copy ..' using HTTP-tunnel, but this is too simple!
And still NEVER use the 'default' setting in the connections manager when connecting to a server haveing Utf8/ucs2 as default – except for migration of Unicode data.