Skip to Content.
Sympa Menu

freetds - Re: [freetds] Wide varchar() columns / freetds / ctlib

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT schemamania.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Wide varchar() columns / freetds / ctlib
  • Date: Thu, 4 Nov 2004 07:44:23 -0500

Michael Peppler <mpeppler AT peppler.org> wrote:
> What is the state of support for wide (nvarchar(3500)) support in
> FreeTDS, and in CT-lib?

Hi Michael,

As soon as the data are picked up from the wire, UCS-2 data are converted
to the client's encoding, determined by the freetds.conf entry. For
something like ISO 8859-1, nvarchar(3500) is reported as varchar(3500);
for UTF-8, you will see varchar(14000), providing 4 bytes for every UCS-2
character.

There is no way to defeat this, and no (working) support for UCS-2
clients.

Regards,

--jkl




Archive powered by MHonArc 2.6.24.

Top of Page