Skip to Content.
Sympa Menu

freetds - Re: [freetds] character set issue between sql server and oracle

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Easy Datawarehouse Solutions" <info AT edwhs.nl>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] character set issue between sql server and oracle
  • Date: Tue, 14 Apr 2015 07:57:22 +0200

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: freetds AT lists.ibiblio.org
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
SATurk AT missouristate.edu<mailto:SATurk AT missouristate.edu>
(417) 836-6195

_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds




Archive powered by MHonArc 2.6.24.

Top of Page