Re: Output from SQL Server database
Mike Grau <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
Someone told me this about this same setup: "They don't know what they have on their hands. Nvarchar & Oracle & "Sql server. Not a good combo. Pity them because it's the character "conversion. It'll be Thanksgiving before they solve this one." More than that I do not know. On 10/27/2014 01:44 PM, Turk, Scott A wrote: > 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 >