freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: Riccardo Penco <r.penco AT scasinet.com>
- To: freetds AT lists.ibiblio.org
- Subject: [freetds] Problems executing a query
- Date: Fri, 17 Jun 2005 10:07:18 +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
Riki
-
[freetds] Problems executing a query,
Riccardo Penco, 06/17/2005
-
Re: [freetds] Problems executing a query,
James K. Lowden, 06/17/2005
- Re: [freetds] Problems executing a query, Riccardo Penco, 06/17/2005
- <Possible follow-up(s)>
- RE: [freetds] Problems executing a query, ZIGLIO, Frediano, VF-IT, 06/17/2005
-
RE: [freetds] Problems executing a query,
ZIGLIO, Frediano, VF-IT, 06/17/2005
- Re: [freetds] Problems executing a query, Riccardo Penco, 06/17/2005
-
RE: [freetds] Problems executing a query,
ZIGLIO, Frediano, VF-IT, 06/17/2005
-
Re: [freetds] Problems executing a query,
Riccardo Penco, 06/17/2005
- Re: [freetds] Problems executing a query, Frediano Ziglio, 06/17/2005
-
Re: [freetds] Problems executing a query,
James K. Lowden, 06/17/2005
- Re: [freetds] Problems executing a query, Riccardo Penco, 06/20/2005
-
Re: [freetds] Problems executing a query,
Riccardo Penco, 06/17/2005
-
Re: [freetds] Problems executing a query,
James K. Lowden, 06/17/2005
Archive powered by MHonArc 2.6.24.