nvarchar conversion issue
"Vann, David" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <9F5004AC76612B4AB26CA57F4A4C48083B570BC1@ExchMail4.ds.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
[email protected]<mailto:[email protected]>