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,
Your "it appears as" citation in this thread shows Myanmar (Burmese) characters. If you do not see them correctly on your screen, then your application client is not configured correctly for Burmese. This is a client font issue, not a database issue.
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.
As Sergiusz stated, this looks to be a client issue. Are you using the latest version of SQL Developer ? What happens when you insert some rows containing these characters (using SQL Developer) into a test table ?
I am using SQL Developer Version 22.214.171.124.(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='ภาษาไทย'.
1 person found this helpful
## 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>