Oracle NLS change
Posted: Mon Jul 03, 2006 8:52 am
Hi there,
A very strange thing happend
I have a simple job
I pass the value of the field OBJTP as-is with no modifications. The field is defined as varchar2(2 BYTE) in both tables.
When I do :
I get a single value 'A' ( hex value 41)
When I do the same:
I get unprintable char with hex value = C1 ,which is the EBCDIC equivalent to 'A'
Any idea what caused the character mapping change ?
very strange .....
Thanks,
Amos
A very strange thing happend
I have a simple job
both tables are on the same DB. Both use the same NLS map (project default)oracle table1 --> transformer --> oracle table2
I pass the value of the field OBJTP as-is with no modifications. The field is defined as varchar2(2 BYTE) in both tables.
When I do :
Code: Select all
select OBJTP from table1
When I do the same:
Code: Select all
select OBJTP from table2
Any idea what caused the character mapping change ?
very strange .....
![Twisted Evil :twisted:](./images/smilies/icon_twisted.gif)
Thanks,
Amos