Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

What is the best CHARACTERSET(UNICODE) I should choose for Asian/Arabic Languages?

edited Aug 22, 2022 8:20PM in Database Install/Upgrade/Opatch (MOSC) 6 commentsAnswered

Currently in our database, NLS_CHAR_CHARACTERSET is WE8MSWIN1252, we don’t have column type “nvarchar2”/”nchar” (Currently we only have CHAR/VARCHAR2/CLOB).

 So, we only support “Western European data” so far.

 Now we are moving our database from Oracle 11g to Oracle 19C. We need to change our system to support most of the languages in the world (Mainly Arabic/Asian Languages)

  1.  What is the best CHARACTERSET(UNICODE) we should choose? We need to save all Languages into database with Unicode but the database size should be the smallest.
  2. Do we need to change the column type to “nvarchar2”/”nchar” (from VARCHAR/CHAR) for these columns that need to keep Unicode

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center