 |
 |
Archives of the TeradataForum
Message Posted: Tue, 21 Nov 2006 @ 18:35:20 GMT
| Subj: | | Re: UTF-8, Fastload and linux |
| |
| From: | | Victor Sokovin |
| | As they started this discussion many years ago they are way ahead in providing solutions for this philosophical problem of loading fixed-
position variable-byte data. Oracle make clear distinction in their data type definitions regarding the fixed number of bytes or characters, and
they support a wide range of char sets, including UTF-8. If I have time, I'll try to load fixed-position UTF-8 data into an Oracle table to see
what happens. | |
I did a quick test and I seem to be able to load UTF-8 data in fixed-position format using SQL*Loader. I did have to pad the fields with blanks
to the maximum value in bytes for each field because the SQL*Loader POSITION parameter still seems to be using the BYTE semantics even if the rest
of the control file uses the CHAR semantics. This is a bit disappointing as it implies an extra effort on the extracting side and increases the
size of the data file but if it helps improve performance ... Anyway, this is how it seems to be in 9.2 (after a quick test). Perhaps things are
easier in 10g?
Regards,
Victor
| |
