[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