Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a flat file containing datas from China, Korea, Taiwan, Hong Kong and Singapore. Name of poeple should be in his own language. For Chinese Korean and Taiwanese, i can not get a good result (for others countries, values are in latin).
When i load the file the codepage is set for all value but it's not the same for thoses languages. I tried to use applycodepage, but without succes.
Does anybody got an idea?
Thks
Vincent
Vincent,
Can you "cut" the file or do several loads (with a WHERE statement) so that you can apply several code pages.
Fabrice
Fabrice,
First of all, thks for replying.
Several files or load is going to work for sure. I was trying to load file at once...
Vincent
Hi,
Force the unicode format in the load statement wiht the 'utf8' keyword.
Example:
(txt, utf8, embedded labels, delimiter is '\t', msq);
I have already tried utf8/7 or unicode and values are not properly reconized after load statement
Vincent