loading unicode data to SQL 2k

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
roblew
Charter Member
Charter Member
Posts: 123
Joined: Mon Mar 27, 2006 7:32 pm
Location: San Ramon

loading unicode data to SQL 2k

Post by roblew »

Hello,

I'm having issues loading spanish unicode data from Oracle (UTF8) into a SQL Server 2000 database.

I've tried using NCHAR datatypes, which didn't resolve the problem. But, after setting the ODBC Enterprise stage datatype on the column to LongVarBinary for the target SQL Server db, it seemed to work properly.

I don't know why this works. Does that make sense to anyone? Any comments?

we're running DS EE 7.5.1A on RHEL with NLS installed.
Top
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

No idea at all. :roll:
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

When you import a table definition from this table, what is the data type of the column in question? Did you try this data type in your job design? Does it work with VarBinary, or do you explicitly need LongVarBinary?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
roblew
Charter Member
Charter Member
Posts: 123
Joined: Mon Mar 27, 2006 7:32 pm
Location: San Ramon

Post by roblew »

FYI, this problem has been resolved by applying a patch provided by IBM.

Please search for eCase 82152 in IBM's KnowledgeBase.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”