Hi all,
Has anyone encountered setting UTF-8 as the project default settings and whenever we use VARCHAR(UNICODE) or CHAR(UNICODE) datatype, the length of the columns created in Oracle is always multiply by 4. Btw, we are using Write Mode=Replace (creating tables thru DataStage).
Example,
DataStage: VARCHAR UNICODE (2)
Oracle: VARCHAR(8 BYTES)
I'm still finding out whether this is caused by Oracle or DataStage, anyone knows anything about this?
NLS affecting column length to multiple?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 50
- Joined: Wed Jul 14, 2004 7:56 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
This very question was asked and answered TODAY. Doesn't your Search work?
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.
-
- Participant
- Posts: 50
- Joined: Wed Jul 14, 2004 7:56 am
oh, you're saying this one? sorry about that. i will close this thread and refer to this thread instead.
viewtopic.php?t=106504
thanks, ray!
viewtopic.php?t=106504
thanks, ray!