Windows and Unix platforms use different Latin-1 character set
encodings that are not entirely compatible. Windows uses
"windows-1252" (also referred to as "cp1252" by some platforms) and
Unix systems typically use the "iso-8859-1" character set. The first
thing I would try is changing your PHP code to this:
<?php
mssql_connect('server','user','pass');
mssql_select_db('db');
$r = mssql_query(“set names cp1252”);
$r = mssql_query(“select some_column from some_table”);
$d = mssql_fetch_assoc($r);
echo $d['some_column'];
?>
The "set names <charset>" query tells the MySQL server that you want
to send and receive data to/from the server in the cp1252
(windows-1252) encoding instead of its default encoding (which again
is probably iso-8859-1). Hopefully this will solve your problem.
Regards,
Cary Clark
--
PHP Unicode & I18N Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
