Re: Issues while storing a long dash in oracle

From: Thomas Kellerer <YQDHXVLMUBXG_at_spammotel.com>
Date: Tue, 11 Mar 2008 08:31:47 +0100
Message-ID: <63mqr5F284qqiU1@mid.individual.net>


Sandy80, 11.03.2008 07:53:
> Hi,
>
> I work on an Oracle9 database which is loaded through sqlldr. The
> issue that I am facing is because of a special character known as long
> dash "-" (the normal one is "-") which appears in the flat file used
> to load the database. Whenver such character appears in the file the
> database processes it and it appears as "" in the database. So the
> data coming as "Finance - Fulfillment Factory" in the flat file is
> stored as "Finance Fulfillment Factory" in the database.
> The main reason for me posting this issue is because when I format
> this data according to the needs of my application it gives me the
> wrong result. I use a command like below:
>
> I have also checked and the database uses the UTF8 character set.

Is your input file UTF8? If yes, did you tell sqlldr that your input file is UTF8?

Thomas Received on Tue Mar 11 2008 - 02:31:47 CDT

Original text of this message