Hi All,
Using 12.1 SE
Im trying to load data from a sql*server unicode csv export. When its loaded into Oracle, it has a bunch of extra characters, and I cant convert the data. For example. I have loaded a date as text into a varchar2 column.. I try and do a to_date on it, and it gives me an invalid year error.
for example, the loaded data into a varchar2 column is
2011/07/21
when I do a dump on it I get the following: Typ=1 Len=21: 0,50,0,48,0,49,0,49,0,47,0,48,0,55,0,47,0,50,0,49,0
I've tried using the ASCIISTR function, but it doesn't change it (a dump shows the same as the dump above).. I've also tried various character sets in my sqlldr control file (US7ASCII, , UTF8, WE8ISO8859P1), but it doesn't make any difference. I've also tried loading into databases with different character sets, and it also doesn't make a difference. (my database is AL32UTF8)
if I directly insert the value 2011/07/21 manually into the column (using SQL Insert, not loader), I just get a dump of the correct characters.. i.e. Typ=1 Len=10: 50,48,49,49,47,48,55,47,50,49
If someone can advise on how I can get loader to load correctly, Id be grateful..
Regards
Richard