FreeTDS Development Group

[Mike Grau <m.grau AT kcc.state.ks.us>]

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
> SATURK AT MISSOURISTATE.EDU
> (417) 836-6195
> 
> 
> -----Original Message-----
> From: FreeTDS [mailto:freetds-bounces AT lists.ibiblio.org] 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 <SATurk AT missouristate.edu>:
> 
>> 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
>> SATurk AT missouristate.edu<mailto:SATurk AT missouristate.edu>
>> (417) 836-6195
>>
>>
> Hi,
>   any more details like FreeTDS version, possible dump, how did you upload 
> data, tables definition.
> 
> Frediano
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>