Re: unicode

I built another database with UTF8 charset and was able load my table my thai characters....even though not clean. I found that I need to use the DIRECT Path method...the only problem is that it complained about the first record.

Now I am having problem looking at the thai messages in sqlplus. I know I need to set some environment variables and stuff like that but not sure which and how. Any advice?

Daud

Peter Sylvester <peters_at_mitre.org> wrote in message news:<3C891EF7.5C916BE6_at_mitre.org>...
> Was the database built using the unicode (UTF8) character set? I think
> you need to start with this, or us UTF8 for the NLS character set and
> use NLS types.
>
> Even with the above, I'm not sure what level of unicode support exists
> in sqlldr - you might need to use Java.
>
> -Peter
>
>
> Daud wrote:
> >
> > Hi
> >
> > I need to be able to create a table with the following fields:
> >
> > MsgNbr integer - Primary Key
> > EngMsg varchar2(255)- Message in english
> > ThaiMsg varchar2(255)- Message in Thai
> >
> > I have already created the table. I then created a control file with
> > the data to be loaded embedded in it and try to load it using
> > sqlloader. Everytime I try I get an error message. I suspect it is
> > because the control file is saved in unicode.
> >
> > Can anyone suggest a way to solve this problem, please.
> > Is there anything else in need to do?
> >
> > rgds
> > daud11_at_hotmail@com
Received on Mon Mar 11 2002 - 09:34:50 CST