Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Turk, Scott A" <SATurk AT MissouriState.edu>
  • To: "freetds AT lists.ibiblio.org" <freetds AT lists.ibiblio.org>
  • Subject: [freetds] character set issue between sql server and oracle
  • Date: Mon, 13 Apr 2015 11:39:54 -0500


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





Archive powered by MHonArc 2.6.24.

Top of Page