[freetds] nvarchar conversion issue

[Vann, David]

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>

[Frediano Ziglio]

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
>

[Vann, David]

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