Re: nvarchar conversion issue
"Vann, David" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
I'm running on Aix 5.3 Sent from my iPhone On Jul 1, 2013, at 4:53 PM, "Frediano Ziglio" <[email protected]> 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 <[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 > _______________________________________________ > FreeTDS mailing list > [email protected] > http://lists.ibiblio.org/mailman/listinfo/freetds