Skip to Content.
Sympa Menu

freetds - [freetds] Problems executing a query

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • 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




Archive powered by MHonArc 2.6.24.

Top of Page