[freetds] Problems executing a query

ZIGLIO, Frediano, VF-IT Frediano.Ziglio at vodafone.com
Fri Jun 17 07:57:43 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
> 

Are you sure that you are using utf8 under php or perhaps page is encoded in another iso format??

freddy77



More information about the FreeTDS mailing list