[freetds] nvarchar conversion issue

Vann, David dvann2 at valleyhealthlink.com
Mon Jul 1 17:21:00 EDT 2013


I'm running on Aix 5.3

Sent from my iPhone

On Jul 1, 2013, at 4:53 PM, "Frediano Ziglio" <freddy77 at gmail.com> wrote:

> It would help if you could enable DM tracing
> and see which calls are made.
> 
> Another option would be to enable wide characters in FreeTDS.
> 
> Which operating system are you using?
> 
> Regards,
>  Frediano
> 
> 
> 
> 2013/7/1 Vann, David <dvann2 at valleyhealthlink.com>
> 
>> I'm running a query against a SQL Server 2008 table that has nvarchar
>> columns.  It's returning the data from within an oracle sqlplus query with
>> extra spaces.  "Bill Smith" is queried as "B i l l  S m i t h".
>> 
>> I've tried several "client charset" settings in the freetds.conf file but
>> nothing seems to work.  I've also tried various HS_NLS_NCHAR settings in
>> the initCardHolders.ora.  Just not having much luck.  Has anyone been able
>> to address this issue and if so how?
>> 
>> Here is the current setting:
>> [CardHolders]
>>        host = xxxxxx.com
>>        port = 1433
>>        tds version = 8.0
>>        client charset = UTF-8
>> 
>> 
>> 
>> 
>> Information Services
>> 220 Campus Blvd, Suite 320
>> Winchester, VA   22601
>> W:540 536-3213
>> C:540 532-8309
>> F:540 536-8989
>> dvann2 at valleyhealthlink.com<mailto:dvann2 at valleyhealthlink.com>
>> 
>> _______________________________________________
>> 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