Oracle Forms

The fact that you are seeing ???? for the characters expected suggests an NLS_LANG issue.  That said, I don't recall that the DB (and therefore Forms) supports Tamil.

https://docs.oracle.com/cd/B28359_01/server.111/b28298/ch2charset.htm

You should probably review the DB docs for details.  Also, try the same in SQL+.  Does it properly display the characters.  If it does, then you likely have not properly set NLS_LANG in the Forms default.env.

I believe these are the supported runtime languages for the Middle Tier components:

Thanks for your reply Michael,

    Are you telling tamil is not supported by forms???

Hi

Tamil is Oracle Supported Languages. http://docs.oracle.com/cd/B19306_01/server.102/b14225/applocaledata.htm#i634428

By using Unicode databases and datatypes, you can store, update and retrieve data for almost all contemporary languages.

http://infitt.org/ti2004/papers/11oracle.pdf

I think this blog may help u more in defining the correct nls_lang for Tamil.

If i were u i would think of the same concept i resolve my Arabic issue:

• First of all think of Installing Tamil Language (Asian or Eastern Languages) for windows client & server side.
• Decide the correct nls_lang then process the rest of logical steps u followed before.
  

Amatu Allah.

Thanks for your reply.

I am Using NLS_LANG as AMERICAN_AMERICA.UTF8.

For tamil what NLS_LANG I need to set????  It should not affect English and Arabic fonts.

Hi,

   How to solve my issue?

Thanks,

Su.gi

Hi,

  I tried setting NLS_LANG=TAMIL_INDIA.UTF8

Its working for Hindi, for Tamil anyone help me

Thanks,

Su.gi

What version of windows are you using? Did you install the Supplemental Tamil Fonts ?

Thanks for your reply

   I am using server as Windows server 2008 and developer system has windows 7.

In OS itself has Tamil font like Latha, Arial Unicode MS.

Thanks,

Su.gi

No one has solutions???

Hi

- Did u try to input new record of Tamil Fonts save it into the database and retrieve this record specifically back to see the changes u had made to ur  nls_lang ?

-Have u made the changes from registry or oracle forms default.env file?

- what is ur current settings now ?

Amatu Allah.

Thanks for your reply.

1. Yes i tried Tamil Fonts save it into the database and retrieve this record in my form.. Its retrieve like boxes.

I used NLS_LANG as NLS_LANG=AMERICAN_AMERICA.UTF8

2. Yes, I have changed in registry and default.env as NLS_LANG=AMERICAN_AMERICA.UTF8

I have tried NLS_LANG=AMERICAN_AMERICA.UTF8,

NLS_LANG=TAMIL_INDIA.UTF8

NLS_LANG=AMERICAN_AMERICA.AL32UTF8

Actually my database NLS_LANG is NLS_LANG=AMERICAN_AMERICA.UTF8. It stores all languages like english, arabic, tamil, hindi

But in Forms it retrieves english, arabic and hindi as correct format. But tamil is displays like boxes.

Please help me to resole this

Thanks,

Su.gi

Hi

1-Do u have more than developer's Home copy on ur pc?

i suspect  the changes u made to Tamil font is not on the right file.

2-Can u write Tamil on u pc.?

3-Did u try creating a new user environment with

'NLS_LANG' as indicated  خطـــوات سهلـة لإنشــاء مشـــروع جديـــد Oracle Developer Training Tasks: May 2015

This helps many colleagues fixing the Arabic problem because it over rides all variables.

Try to create it giving the value NLS_LANG=AMERICAN_AMERICA.UTF8 to influence overalls.

Amatu Allah.

Thanks for your reply.

   In my PC i can write tamil.

As per your above link i solved my arabic font issue. You only solved my issue in my previous post.

I am using NLS_LANG=AMERICAN_AMERICA.UTF8 for arabic fonts. But it not working for tamil font. It shows as junks.

The above NLS_LANG solves arabic, hindi. But it not working for tamil or malayalam.

Please find the image

Hi

This is strange as this document http://infitt.org/ti2004/papers/11oracle.pdf

under paragraph

LANGUAGE SUPPORT

Oracle allows users to store, process, and retrieve data in Hindi, Tamil, Kannada, Malayalam, Gujarati, Oriya, Punjabi, Telugu, Assamese and Marathi. Through the Unicode (UTF8) character set.

This makes me suspect in some conflict occurred. Did u restart the server ?

Amatu Allah

Thanks for your reply.

yes i restarted my server.

This is my database NLS_LANG

select * from v$nls_parameters

    where parameter in ('NLS_CHARACTERSET','NLS_LANGUAGE');

Is there any other configuration i have missed??

Hi

Let's try the following:

NLS_LANG =  ta_IN.UTF-8

https://docs.oracle.com/cd/E26502_01/html/E29214/glmlc.html

pls. make sure u r using the proper fon:  Lohit Tamil

i think it will work properly.

Amatu Allah.

Thanks for your reply.

If i used this NLS_LANG =  ta_IN.UTF-8, then database is not connecting with forms services.

Did u restart the server...?

Did u changed the Font of the form as indicated..?

what error pls...?

In registry and default.env  i have changed NLS_LANG=ta_IN.UTF8

and now i am opening form builder and connecting database.

It shows ORA-12705: Cannot access NLS data files or invalid environment specified.

Sorry for that...

For testing purposes

Alter session set NLS_LANG =  ta_IN.UTF-8;

Then try to run again, it should works for multi-languages.

I have tried in sqlplus it shows error

SQL> Alter session set NLS_LANGUAGE='ta_IN.UTF-8';

ERROR:

ORA-12705: Cannot access NLS data files or invalid environment specified

Then, i conclude most probably u run into a bug. Pls check the following list for indian fonts  https://bugzilla.redhat.com/show_bug.cgi?id=134036

could u connect to any Oracle Support...?

i am sorry, if any further solutions i found i'll contact u.

Please refer back to my first reply to this thread for the position relative to Forms.  From java's point of view, see this

http://www.oracle.com/technetwork/java/javase/java8locales-2095355.html

in short, even if you manage to get it working I don't think it will be wth a supportable configuration. 

Thanks for your reply.

In database it stores tamil language. But in forms its not retrieving properly. You are telling this problem of Java 8.

Oracle can support Tamil Language in forms in future???

Thanks,

Su.gi

Thanks for your reply.

U most welcome.

Hope ur problem will be considered creating  patches for this bug.

Amatu Allah.

Hi All,

     In Oracle Database 12c storing datas in tamil language.. In Oracle reports it is working..

But in Oracle Forms 11g It is not retrieving properly those datas...

Then how to view my data...

In Client system, how they store data(tamil) in database through forms.

Thanks,

Su.gi

Hi All,

    Is this false document???

http://infitt.org/ti2004/papers/11oracle.pdf

Thanks,

Su.gi

It's probably just out of date. If it woks for Oracle reports but not Oracle forms, then it probably is a bug. It may be time to raise an SR.

What part of the document do you believe to be false?  Did you read it?  I assume you are referring to the fact that Tamil is shown in a running form.  Several things to consider;

1. This document was written in 2004 when Oracle Jinitiator was used to run the Forms applications.
2. If you read the text in the doc carefully, you will find this statement,
   
   

"... The Java Input Method Engine is developed for Indian language. The figure below  contains  a sample screen developed using Pluggable Java Components and Java Input Method Engine ..."

So, if I had to guess, PJCs were used to make this work.  It may be possible to make this work without a PJC (or similar), but likely server and client configuration changes may be needed.  The lack of direct Tamil support is not a product defect.

I am really happy   for u, and this thread will be really helpful for others who may face this problem.

hard effort & Good Job.

Amatu Allah.

Thanks for your appreciation Amatu Allah Neveen Ebrahim.

Su.gi wrote:

Thanks for all your replies,

I got the solution. There is a fallback option in Java for fonts.

I just placed my font in java fallback folder.

Now Oracle Forms can support any Indian languages especially Tamil, Malayalam, etc..

Hello

Appreciate your hard work.

Your next goal will be , Display this at PDF out put, i mean run PDF report with this font.

Hamid

Thanks for your reply HamidHelal.

   I already completed PDF report with Tamil Fonts. Now reports are successfully running.

Thanks,

Su.gi

Dear All,

I need English and Malayalam font in Oracle 11g Forms applications. Pls forwarded me the solution steps.

Regards

Jiju

hi thanks you did this your task. but I also want this same .

you told when you put entry in default.env file so after that you cannot access this hindi and arbic fronts also.

I have also same install oracle 11g forma and report on windows server 2008.

can you please share some your steps you did at this your application site.

means where you defind all this nls_lang .

thanks in advance su.gi. you share me your knowledge.

Hello,

We are facing the same issue for Khmer text in Oracle form application. the Khmer(Cambodia) text are stored properly in DB , but when you try to enter Khmer text in Form , all the text appears as Square box.

Please provide the step by step how the Tamil language  fixes were done so that we may follow the same approch but Exact Khmer Font  name will be a challenge.

Thanks in advance ,

MJ

Its really urgent if you could help.

If you have any "urgent" issues you should contact Oracle Support or Oracle Consulting.  Contributors of this forum are volunteers and not necessarily Oracle employees. 

Thanks,