DSXchange

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.

No idea at all.

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?

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

Please search for eCase 82152 in IBM's KnowledgeBase.