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.
loading unicode data to SQL 2k
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.