[freetds] nvarchar conversion issue

Frediano Ziglio freddy77 at gmail.com
Mon Jul 1 16:47:04 EDT 2013


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
>


More information about the FreeTDS mailing list