Hi,
I have one source file having both Thai and Germany characters. Even they are in one column called description.
How should I map these file/column since NLS map is different for Thai and Germany.
Thanks,
NLS Error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Is it Thai in some rows and German in other rows, or a mixture in any given single row?
If the former, you could read using the Thai map (TIS602?), which would reject rows with Thai-unmappable characters. In another job or another stream you could read using the ISO8859 map for German, which would reject rows containing Thai characters.
If you have a mixture of Thai and German characters in the same column in the same row, this is a trickier problem to solve. You could attempt to use some generic Unicode or UTF-8 mapping, but I would have to think this through a little more carefully. What do you want to do with the data in this column?
If the former, you could read using the Thai map (TIS602?), which would reject rows with Thai-unmappable characters. In another job or another stream you could read using the ISO8859 map for German, which would reject rows containing Thai characters.
If you have a mixture of Thai and German characters in the same column in the same row, this is a trickier problem to solve. You could attempt to use some generic Unicode or UTF-8 mapping, but I would have to think this through a little more carefully. What do you want to do with the data in this column?
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.