Re: nvarchar conversion issue
Frediano Ziglio <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <CAHt6W4c23N8=d7nCoOP_VLcXW8wGsqkcY5Yex3C05CPgus8vHw@mail.gmail.com> |
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 <[email protected]> > 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 > [email protected]<mailto:[email protected]> > > _______________________________________________ > FreeTDS mailing list > [email protected] > http://lists.ibiblio.org/mailman/listinfo/freetds >