Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
CODE PROJECT For Those Who Code
  • Home
  • Articles
  • FAQ
Community
  1. Home
  2. Database & SysAdmin
  3. Database
  4. How to store multiple languages in oracle 10g?

How to store multiple languages in oracle 10g?

Scheduled Pinned Locked Moved Database
questiondatabaseoraclehelptutorial
3 Posts 3 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • N Offline
    N Offline
    n3ophyt3
    wrote on last edited by
    #1

    I have to store hindi,chinese ... etc language words in my db using oracle 10g ... how can i do that.. can any one help me please..?? or atleast .. how can i do the language conversion from HINDI to english ... any sourcecode? so that i can store english strings directly.... plzz help regards, Vineeth Koganti

    L N 2 Replies Last reply
    0
    • N n3ophyt3

      I have to store hindi,chinese ... etc language words in my db using oracle 10g ... how can i do that.. can any one help me please..?? or atleast .. how can i do the language conversion from HINDI to english ... any sourcecode? so that i can store english strings directly.... plzz help regards, Vineeth Koganti

      L Offline
      L Offline
      Lost User
      wrote on last edited by
      #2

      n3ophyt3 wrote:

      I have to store hindi,chinese ... etc language words in my db

      What is the problem? A string of characters has no meaning to the database, it is just characters, so you can store any language you like. It is only when you extract those characters from the database and display them that they have any meaning, e.g. a message read by a human operator.

      1 Reply Last reply
      0
      • N n3ophyt3

        I have to store hindi,chinese ... etc language words in my db using oracle 10g ... how can i do that.. can any one help me please..?? or atleast .. how can i do the language conversion from HINDI to english ... any sourcecode? so that i can store english strings directly.... plzz help regards, Vineeth Koganti

        N Offline
        N Offline
        Niladri_Biswas
        wrote on last edited by
        #3

        Hi,

        You can create a Unicode database that enables you to store UTF-8 encoded characters as SQL CHAR datatypes (CHAR, VARCHAR2, CLOB, and LONG).

        For more info. please look into http://download.oracle.com/docs/cd/B19306_01/server.102/b14225/ch6unicode.htm[^]

        n3ophyt3 wrote:

        how can i do the language conversion from HINDI to english ... any sourcecode?

        Some pseudo code

        function OtherLanguage2English(value,offset)
        {
        var ctrlValue=value; //Variable ctrlValue stores the value of the respective languages depinding on the offset value
        var english="";

        	for (var idx=0; idx<ctrlValue.length; idx++)//Loop Until The End Of Text Is Reached
        	{
        			individualChar = ctrlValue.substring(idx,idx+1); //Extracting Charecter 1 By 1 From The String Value
        
        			var code =individualChar.charCodeAt(0);//Gets the Unicode Value	
        			
        			english=english+ String.fromCharCode(code-offset);//Converts From Other Language Values To English
        			
        			switch(offset)
        			{
        				
        				case 2358:document.getElementById('txtEnglish').value=english;break;//For Hindi Value To English
        			}
        
        	}
        

        }

        Though it is in javascript but this function also converts Hindi to English.. So I thought that you may get some idea. Sorry for not getting an appropriate code for your help. I will update as and when I will get the code for oracle for serving the same purpose. :)

        Niladri Biswas

        1 Reply Last reply
        0
        Reply
        • Reply as topic
        Log in to reply
        • Oldest to Newest
        • Newest to Oldest
        • Most Votes


        • Login

        • Don't have an account? Register

        • Login or register to search.
        • First post
          Last post
        0
        • Categories
        • Recent
        • Tags
        • Popular
        • World
        • Users
        • Groups