Skip to Content.
Sympa Menu

freetds - RE: [freetds] Problems executing a query

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Problems executing a query
  • Date: Fri, 17 Jun 2005 13:57:43 +0200

>
> 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




Archive powered by MHonArc 2.6.24.

Top of Page