Re: character set issue between sql server and oracle

Hi,

Can't really help you with this gateway problem (need more info on how you 
set this up, but most likely due to characterset conversion problem).
Personally I always use this for running sql server queries from oracle: 
https://github.com/easydatawarehousing/easy2oracle

Ivo


-----Oorspronkelijk bericht----- 
From: Turk, Scott A
Sent: Monday, April 13, 2015 6:39 PM
To: [email protected]
Subject: [freetds] character set issue between sql server and oracle


We've set up freetds as a gateway between Sql server and Oracle.  When 
running a query on Oracle across a link to a Sql Server database, we get 
extra null characters between each real character in the output.  This 
occurs on columns set up as nchar on the Sql Server side.  Can anyone please 
provide assistance?

Here is the output from the dump command on the query (executed on Oracle 
across the link), the real output should be "administrator".

Typ=1 Len=52: 
0,97,0,0,0,100,0,0,0,109,0,0,0,105,0,0,0,110,0,0,0,105,0,0,0,115,0,0,0,116,0,0,0,114,0,0,0,97,0,0,0,116,0,0,0,111,0,0,0,114,0,0

Thanks!

Scott Turk
Missouri State University
[email protected]<mailto:[email protected]>
(417) 836-6195

_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds