Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Loading UTF8 fixed length file using SQL Loader 8i

Re: Loading UTF8 fixed length file using SQL Loader 8i

From: HansF <News.Hans_at_telus.net>
Date: Tue, 04 Jan 2005 19:09:15 GMT
Message-Id: <pan.2005.01.04.19.08.28.685210@telus.net>


On Tue, 04 Jan 2005 05:18:23 -0800, Nicolas Mayoraz wrote:

> Hi all,
>
> I'm trying to load an UTF8 file with fixed length record using SQL
> Loader for Oracle 8i.
>
> Unfortunately, SQL Loader does not make the difference between bytes
> and characters. i.e. that if two bytes are used to code an accentuated
> character (like ) SQL loader will consider that two caracters has
> been read meaning that beginning of next field will be shifted.
>

(Just pointers, as I haven't tried this yet ...)

You might find Case Study 11 "Loading Data in the Unicode Character Set" and Chapter 5 "Handling Different Character Encoding Schemes" of interest. For Oracle9i R2 Look up Chapter 10 of the Utilities manual at http://www.tahiti.com

HTH
/Hans Received on Tue Jan 04 2005 - 13:09:15 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US