We want to implement Multi-Language support in our application.These applications will save different language scripts in our database.
The required languages are Indonesian,Malay,Hindi,Burmese,Chinese,Tamil,Thai,Vietnamese,Cambodian and Filipino.
The database will be different for each language application.I want information and technical resources regarding this.
Please let me know :
1. How can I implement Multi language database ?
2. Any Known issues and solutions in such implementation?
3. What necessary steps should I follow for such type of Database Implementations ?
As I said, I want to implement in Indonesian,Malay,Hindi,Laotian,Burmese,Chinese,Tamil,Thai,Vietnamese,Cambodian and Filipino languages.
Among these for Burmese,Tamil,Cambodian ,Laotian languages I unable to store the language scripts.It appears as 'ျကမာနေ်န'.
Is there any solution for it. Will it be support for these languages?
Thanks in advance,
I checked table data in Toad for Oracle where the scripts are appearing properly(able to see the fonts) but select statement with the script as a condition does not work .
And the same thing appearing Oracle SQL developer as 'ျကမာနေ်န'.
Please give your suggestion.
I am using SQL Developer Version 126.96.36.199.(SQL Developer 4.0 Early Adopter 2) .When I paste Tamil,Laos,Cambodian,Burmese script In SQL worksheet it appears as 'boxes' (as mentioned above).
If I paste those scripts in Word etc it shows exact scripts(Except Burmese).So the the worksheet in the SQL developer does not accept those script.
Also Select statement on the script criteria is not working. eg. select * from multilanguage where Script='ภาษาไทย'.
## When I paste Tamil,Laos,Cambodian,Burmese script In SQL worksheet it appears as 'boxes' (as mentioned above).
This is a font issue. The JDK that you use for SQL Developer must be configured to recognize proper fonts for the scripts. You should be able to use the same fonts that you use in Word. Look in the Internet to see if somebody has already configured Java for those scripts. If not, post your JDK version here (you can find it in Help->About), and the fonts that you use in Word for each of the scripts.
Regarding the SELECT issue, please use some other column to identify the row that you do not see and post here the result of:
SELECT DUMP(Script, 1016) FROM multilanguage WHERE <condition>