[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