-
Multi-Character Set Support
I need to set up a instance which support English and Chinese data BOTH.
How I implement it, what I need?
1. create a new instance
2. convert a existing instance with NLS_CHARACTERSET = WE8ISO8859P1
I know I need to setup up NLS_lang, NLS_character set...
I understand I have 2 options, UTF8 and simple/traditional chinese. which one I should use?
thanks in advance
-
It is up to you which Charset would you use. I don't know much about chinese charset, but I use UTF8, as I know it support a lot of languages. If you sure that you need only chinese and english in future you may use chinese charset, but if you expect european language, you should use UTF8.
You have to create new Instance for that.
Best wishes.
-
THANKS KGB.
in init.ora I use:
character set "UTB8"
national character set "UTB8"
NLS_LANGUAGE=??
NLS_TERRITORY=??
how about NLS_LANGUAGE and NLS_TERRITORY
do I have to set up any value or use default (american)
or use CHINA and SIMPLE CHINESE
thanks again
-
I use database parameters:
CHARACTER SET UTF8
NATIONAL CHARACTER SET UTF8
NLS_LANG=AMERICAN_AMERICA.UTF8
NLS_DATE_FORMAT='Mon DD YYYY HH24:MI:SS'
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT Mon DD YYYY HH24:MI:SS
NLS_DATE_LANGUAGE AMERICAN
NLS_CHARACTERSET UTF8
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-YY HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZH:TZM
NLS_TIMESTAMP_TZ_FORMAT DD-MON-YY HH.MI.SSXFF AM TZH:TZM
NLS_DUAL_CURRENCY $
NLS_NCHAR_CHARACTERSET UTF8
NLS_COMP
NLS_TERRITORY doesn't effect on data saving.
Originally posted by jm
THANKS KGB.
in init.ora I use:
character set "UTB8"
national character set "UTB8"
NLS_LANGUAGE=??
NLS_TERRITORY=??
how about NLS_LANGUAGE and NLS_TERRITORY
do I have to set up any value or use default (american)
or use CHINA and SIMPLE CHINESE
thanks again
[Edited by kgb on 06-26-2001 at 01:51 PM]
-
It makes sense, all I need is use UTF8 to store the data.
thanks kgb,
-
Hello,
I will be setting up a UTF8 database, and I need to migrate a WE8ISO8859P1 database onto this one. I'm trying with export/import, but I'm not sure how the client settings are supposed to be (NLS_LANG...). I have CLOBs in a table, and it seems that the data gets garbled in the import... can anyone help me with this?
Thanks in advance!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|