Hi,
From your windows client machine, set your NLS_LANG env variable to american_america.utf8. Do not let it gb231280 or gbk.
Good luck
Regards
zhu chao
msn:[Email Address Removed]
www.cnoug.org(China Oracle User Group)
----- Original Message -----
From: "murali b" <[Email Address Removed]
To: "LazyDBA.com Discussion" <[Email Address Removed]
Sent: Wednesday, April 30, 2003 6:56 PM
Subject: chinese characters in database


> Hi all,
>
> I would like to store and retreive chinese characters
> in the database. I have set my database character set
> to utf8. But when I try to insert the characters from
> sqlplus, it is inserting junk. I have also tried
> setting up the chinese support at the os level(windows
> 2000) for sqlclient.
>
> Could anyone point me the correct method of doing it?
>
> I am using 8.1.7.2.
>
> regards
>
> murali
>
> __________________________________
> Do you Yahoo!?
> The New Yahoo! Search - Faster. Easier. Bingo.
> http://search.yahoo.com
>
> --------
> Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed]
> To subscribe: send a blank email to oracledba-[Email Address Removed]
> Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
>
>

Oracle LazyDBA home page