[freetds] Problems executing a query
James K. Lowden
jklowden at freetds.org
Fri Jun 17 07:51:42 EDT 2005
Riccardo Penco wrote:
> 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)
Does the query work in tsql? It should.
SQL Server 2000 encodes database object names in UCS-2, which obviously
can represent 'Città'. The error message may be telling you that the à is
arriving not as UTF-8 (2 bytes) but as ISO 8859-1 (1 byte, high bit on).
Attempting to interpret ISO 8859-1 as UTF-8 will elicit that message.
A TDSDUMP log will provide more detailed information about the failed
conversion.
HTH.
--jkl
More information about the FreeTDS
mailing list