Re: Output from SQL Server database
Frediano Ziglio <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <CAHt6W4eiRGjAL9hThp+48E2g7hqBQ2JUv4aET9t2fnEg3kF05g@mail.gmail.com> |
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 >