Re: Changing Character Set

    I don't have complete answers, but hopefully someone else here will, cause I'd like to read them. When we did this we had to work with our Solaris sysadmin and we did need to set an environmental parameter on Solaris as well as the database character set. Also we found we had to add an explicit line to our export scripts (run through OEM) to avoid exporting in ASCII7. We will probably use UTF-8 as our new standard since so many more of the apps are being used in Europe and Asia as well as here.

    Let us know what else you find out.

Van

"LF" <frolio_at_videoshare.com> wrote in message news:96k7nr$fui$1_at_bob.news.rcn.net...
> Greetings All, I need to enable my database to accommodate five European
> Languages as
> well as three Asian Languages. I determined that the Character Set UTF-8
> will allow me
> to do this. However, I am a bit confused with the difference between the
> database
> character set and the national character set(I am running 8i II on Solaris
> 2.7). Do I need
> to set both or do I just need to set the database character set? Ideally
 I
> would like it if I
> did not have to change my table column types(e.g. varchar -> nvarchar). I
> realize that I
> will probably have to change the size of the varchar and char fields to
> allow for the size
> difference in characters(e.g varchar(10) -> varchar(30)). I would
> appreciate it if someone
> can give me the quick and the dirty of what I should do, or, what the best
> thing is to do.
>
> Regards, LF
>
>
Received on Sat Feb 17 2001 - 16:06:21 CST