[freetds] Freetds and Unicode

Hugo Freire hfreire at abajar.com
Thu Oct 8 10:11:24 EDT 2015


I'm testing it with last stable version freetds-0.95.20.

Thanks,
Hugo

El 10/8/2015 a las 2:29 PM, Igor Korot escribió:
> Hi,
>
> On Thu, Oct 8, 2015 at 6:36 AM, Hugo Freire <hfreire at abajar.com> wrote:
>> Hi,
>>
>> I'm using Freetds from 4 years ago and works perfectly. Now we are trying to
>> allow to store Unicode characters in sql server.
> Can you try the latest release? At least for testing purposes.
> 4 years ago binary is outdated.
>
> Thank you.
>
>> We have detected that we can store without problems any character from first
>> plane of Basic Multilingual Plane
>> https://en.wikipedia.org/wiki/Plane_(Unicode)#Basic_Multilingual_Plane, but
>> not able to store any character from other planes.
>> In the Freetds documentation I can read "At some future time, FreeTDS aims
>> to support Unicode and other multi-byte character sets."
>> After making some tests, we was able to store all Unicode characters using
>> "client charset ISO-8859-1".
>> Unfortunately we have an heterogeneous platform with windows and linux
>> systems connecting to the same data, so the data stored by Freetds using
>> ISO-8859-1 can't be read by .net application for example.
>>
>> Our conclusion was that FreeTDS is unable to store all Unicode characters in
>> SQL Server in UCS-2.
>>
>> Is it correct?
>> Are there any patch that allow to store all UCS-2 characters?
>> Is posible create a patch to allow this?
>> Can someone guide me to start to create this patch?
>>
>> Best regards,
>> Hugo
>> _______________________________________________
>> FreeTDS mailing list
>> FreeTDS at lists.ibiblio.org
>> http://lists.ibiblio.org/mailman/listinfo/freetds
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds



More information about the FreeTDS mailing list