[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 (à,
> 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:
> 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??
More information about the FreeTDS