When loading text file into db via sqlloader, there might be the case that varchar2 column with Thai character data turn out weird (i.e. instead of showing "รถยนต์นั่งไม่เกิน 7 คน" it turn out to be "เธเธฃเธ เธฃเธ–เธขเธเธ•เนเธเธฑเนเธเนเธกเนเน€เธเธดเธ 7 เธเธ").
The cause of this problem, from what I experienced, is that the format/encoding of text file is invalid.
To solve this you need to open the file with your fave text editor, then use "save as" menu and choose file format/encoding as ANSI/ASCII (default one is the current format/encoding of the file).
Counting my Zero Days
-
I have decided to start keeping track of how many Zeroes I am able to
accumulate in a day.
My "Zero Day" is not the same as the hacker zero day concept.
I...
7 years ago
0 comments:
Post a Comment