[freetds] Problems executing a query
Riccardo Penco
r.penco at scasinet.com
Fri Jun 17 04:07:18 EDT 2005
Hi all,
I have a problem executing a query which has an accented character (à,
chr(224)).
I run php web pages in Linux (Fedora Core 3) with FreeTDS-0.62.4-1 and
php-mssql-4.3.10-3.2.2 connecting to a server running Windows 2000
server / MSSQL Server 2000.
In freetds.conf I have:
[SERVER_NAME]
host = SERVER_IP_ADDRESS
port = 1433
tds version = 8.0
client charset = UTF-8
If in a php script I write:
$sql = "SELECT Città from PDV";
$res = mssql_query($sql, $conn);
I obtain the following error message:
Warning: mssql_query(): Error converting client characters into server's
character set. Some character(s) could not be converted. (severity 16)
and i cannot obtain any result.
Unfortunately I cannot change the column name in the database.
Does anybody have any idea on how to solve this problem ?
Thank You very much
Riki
More information about the FreeTDS
mailing list