How to support Multi language in Oracle.

We may all come across the issue of how to support Multi language in Oracle. For that UTF-8 is the best way to do that. Here is the steps need to follow to achive UTF-8 support.

  1. Connect to the oracle database using SYS user.
  2. Set the Character set to ALFUTF-8 using following command update sys.props$ set VALUE$='AL32UTF8' where NAME='NLS_CHARACTERSET';
  3. Restart the database using following command.
    • shu immediate;
    • startup;

  4. In Case if you are working with web application to enable UTF-8, configure the force encoding of all incomming request in web.xml.
    img

  5. To Support Multilanguage search in data table, do the below configuration in tomcat server of server.xml file
    img