Oracle: How to get Oracle 11g database to support your language

To change Oracle database to support character in other language, you need to change it's Character Set. In the older version of Oracle such as version 7, you can update value of Character Set in PROPS$. But in newer version such as Oracle 11g, it need you to update straight to the property of the database.

Environment:
      Server side: Oracle 11g
      Client side: Microsoft Windows 7, Oracle Client 11g

At server side:
- Log in to SQL*Plus as SYSDBA.

            CONNECT /@ AS SYSDBA

   Example: SQL> CONNECT /@BLUEBALL AS SYSDBA

- Update database property.

            ALTER DATABASE CHARACTER SET ;

   Example: SQL> ALTER DATABASE BLUEBALL CHARACTER SET TH8TISASCII;
   Note: "TH8TISASCII" is for Thai language.

- Shutdown database.

            SHUTDOWN IMMEDIATE;


- Startup database.

            STARTUP;

At client side:

Expect that you already install Oracle Client into your computer.

- Click "Start" button of Microsoft Windows, type "regedit" in the search box and then press ENTER or click at the search result.





















- There will be "User Account Control" pop-up window to ask "Do you wan to allow the following program to make change to this computer?". Click "Yes" button to allow.

- "Registry Editor" program will be opened. Drill down and click at the label from the left pane "Computer" -> "HKEY_LOCAL_MACHINE" -> "SOFTWARE" -> "ORACLE" -> "KEY_OraClient11g_home1".

























- From the right pane, double click at "NLS_LANG" parameter. There will be "Edit String" pop-up window as shown below.





















- Change the value after "." in "Value data:" text box to be the same as you have changed in the database from the server side. Then, click "OK" button to save the value.








- The value of "NLS_LANG" parameter will be changed as shown. Close "Registry Editor" program.





















Now you can read, input or import data in Thai or in other language you have set.

Credit to: Mr. Sarawut Suangtho, Database Administrator, IBM Thailand

Comments

Post a Comment

Popular posts from this blog

Microsoft Visio: How to set default font

Image
Microsoft Visio doesn't have the easy way to set its default font and size. Please follow these steps to make change of your drawing. Environment : Microsoft Visio 2007 Solution No. 1 : Set default font and size from Style Note that this solution will not apply to the drawing that you change to specific font. - From menu bar, select 'Tools' and then 'Options...'. - In 'Options' pop-up window, select 'Advanced' tab. At 'Advanced options', check 'Run in developer mode' and press 'OK' button. This option will allow you to select 'Define Styles...' sub-menu. - Draw some drawing and select it. At the menu bar, select 'Format' and then select 'Define Styles...' sub-menu. - In 'Define Styles' pop-up window, at 'Style' section, the default style name will be selected automatically follow by the style of the drawing that we selected befo...
Read more

LINE: Change the contact name

Image
People use some other name to represent themselves in LINE. To search them, you might not be able to remember what name they are using. You can just change the displayed name to what you call them. Follow these steps to change it. Environment : Application: LINE version 3.1.7 O/S: Android Ice Cream Sandwich 4.0.4 Device: Samsung Galaxy S III Press at the friend that you wan to change the name. Press at the pencil sign in the pop-up screen. It will show you the textbox to override the name. Type in the name that you want to call your friend and press "Save". Scroll down or search the new name you just defined.
Read more

Google Sheet: How to perform spelling check in other language

Image
Google defaults spelling check in English for you. What if you are writing in other language and want Google to perform spelling check for you. Here are the steps: In your Google Sheet, click at main menu "File" and then select "Spreadsheet settings...". Click at the drop-down list under "Locale". Select the language you want Google to check spelling and click "Save settings" button. In this case, I want to select check with Mexican Spanish dictionary. Now, click at main menu "Tools" and then, "Spelling...". Google will check the entire sheet and suggest you to change the word. Click "Change" button if you want to change. It seems like Google will recognize English anyway. Unless, you type in any other language, it will suggest you to change to Spanish word.
Read more