Re: Output from SQL Server database

Hi, I've enabled the wide support and it didn't solve the issue.  Is there a setting to change or add to the odbc.ini or the freetds.conf files?

Thanks for your help!

SCOTT TURK
DATABASE ANALYST, DBA
COMPUTER SERVICES - MIS
MISSOURI STATE UNIVERSITY
[email protected]
(417) 836-6195


-----Original Message-----
From: FreeTDS [mailto:[email protected]] On Behalf Of Frediano Ziglio
Sent: Tuesday, October 28, 2014 3:04 PM
To: FreeTDS Development Group
Subject: Re: [freetds] Output from SQL Server database

One possible solution if database is using nvarchar would be to enable odbc wide support. This way ODBC  should present nvarchar as wide encoding ( either 2 bytes or 4 bytes characters depending on system settings).

Frediano

Frediano

2014-10-27 18:44 GMT+00:00 Turk, Scott A <[email protected]>:

> FreeTDS version is 7.2.  The data type of the column in question is 
> nvarchar on the SQL server side - would the rest of the table 
> description help?  We are accessing the data via an Oracle link in SQL 
> Developer.  The data is produced by user input.
>
> How can I produce a dump file?
>
> Thanks!
>
> SCOTT TURK
> DATABASE ANALYST, DBA
> COMPUTER SERVICES - MIS
> MISSOURI STATE UNIVERSITY
> [email protected]
> (417) 836-6195
>
>
> -----Original Message-----
> From: FreeTDS [mailto:[email protected]] On Behalf Of 
> Frediano Ziglio
> Sent: Monday, October 27, 2014 12:13 PM
> To: FreeTDS Development Group
> Subject: Re: [freetds] Output from SQL Server database
>
> 2014-10-27 16:48 GMT+00:00 Turk, Scott A <[email protected]>:
>
> > Hi, we're having a problem with the output we're getting across an 
> > Oracle link to a SQL Server database.  The column output appears to 
> > have inserted nulls in between each character.  The data type of the
> column is nvarchar.
> > Our application is SQL Developer.
> >
> > Any ideas on what may be going wrong?  We also use FreeTDS to link 
> > to other SQL Server databases and have not seen this happen previously.
> >
> > Thanks!
> >
> > Scott Turk
> > Database Analyst, DBA
> > Computer Services - MIS
> > Missouri State University
> > [email protected]<mailto:[email protected]>
> > (417) 836-6195
> >
> >
> Hi,
>   any more details like FreeTDS version, possible dump, how did you 
> upload data, tables definition.
>
> Frediano
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds