Home » Developer & Programmer » Forms » How to incorporate Unicode Font with forms 10g (Form 10g)
How to incorporate Unicode Font with forms 10g [message #319564] Mon, 12 May 2008 04:14 Go to next message
jaymala_k
Messages: 19
Registered: May 2008
Location: India
Junior Member
Hi,

I am using 10g Database and 10g forms/reports on Windows.

NLS_LANG = AMERICAN_AMERICA.AL32UTF8 for both database and forms/reports. I set this from REGEDIT.

I want to use, Arial Unicode Ms or Mangal font to add or view the data in MARATHI (Regional).

In the database browser, I can see the ported data properly with these two fonts, but through form if I try to add then it not showing proper characters, it showing squraes instead of typed characters.

I also typed a label in the form, at design time it showing proper word, but at runtime it not showing proper letters. This I observed only for joined characters.

If I generates the report in PDF, format then it not showing data properly. but in runtime it showing properly.


Please guide me for use of Unicode font
Re: How to incorporate Unicode Font with forms 10g [message #319758 is a reply to message #319564] Tue, 13 May 2008 00:02 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Search this forum for 'nls_lang' and maybe 'unicode'. This has been asked and answered previously.

David
Re: How to incorporate Unicode Font with forms 10g [message #319868 is a reply to message #319758] Tue, 13 May 2008 05:03 Go to previous messageGo to next message
jaymala_k
Messages: 19
Registered: May 2008
Location: India
Junior Member
Hi David,


Thanks for your prompt reply. As per your Instruction, I searched for key words, but I have not got the proper solution. Please give me proper guidance.

I am uploading the file to how at design time and run time same word is displayed. It also not allowing me to type, it displays '?' instead of letter.

Please reply ASAP.

Regards,

Jaymala
Re: How to incorporate Unicode Font with forms 10g [message #320047 is a reply to message #319868] Tue, 13 May 2008 19:51 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have a look at http://www.orafaq.com/forum/m/182535/67467/?srch=nls_lang+java+david#msg_182535

Also look at http://www.orafaq.com/forum/m/311258/67467/?srch=java+thingy#msg_311258

David
Re: How to incorporate Unicode Font with forms 10g [message #327460 is a reply to message #320047] Mon, 16 June 2008 08:28 Go to previous messageGo to next message
jaymala_k
Messages: 19
Registered: May 2008
Location: India
Junior Member
Hi,

Still I am facing the same problem for Unicode.

For database paramaeters are

NLS_NCHAR_CHARACTERSET = AL16UTF16
NLS_CHARACHTERSET = WE8MSWIN1252

Can you please help me to solve the problem.

If from back-end I update the value in MARATHI (Asial Lang.) font then it stores in database properly but If I try to retrieve through the form then it showing 'żżżż żżżżż'.

If I try to type through form then it showing '????????' and storing same in database.

Regards,

Jaymala
Re: How to incorporate Unicode Font with forms 10g [message #331006 is a reply to message #327460] Wed, 02 July 2008 02:13 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Message was reported with the following text
Hi, Still I am facing the same problem, for Arial Unicode MS . Operating System : Windows 2000 advanced server. . Both database and Oracle Forms and Reports are installed on the same server. . Databse : Oracle 10g Release 1 . Oracle Forms and Reports : Oracle 9i Developer Suite Release 2(9.0.2) Also installed Patch 3 . Database setting : NLS_LANG = AL32UTF8 NLS_NCHAR_LANG = AL16UTF16. . Langauge : Marathi Langauge . Font : Arial Unicode MS . Windows Setting : From regional setting, Indic is selected for Marathi font. . If Sql propmt I update the table values, it accept properly and also updating and quering from database properly without any issue. Not a problem for Combination letters. . For Forms : 1. I updated Registry.dat file, with font name 'Arial Unicode MS'. 2. In regedit, for Forms home, updated NLS_LANG=AMERICAN_AMERIC.UTF8 . Now if in forms-canvas I want to type the Marathi lebel (with Arial Unicode MS) then showing '??????', but if i tried to copy the word from Character map, then it showing it properly.But on running the form it showing combine letter separated. . On text box, it not allowing to type anything. for any key pressed it shows '????'. but if I copy from character map to text box, then it shows the marathi letters, but combined words are displaying separated. . For reports : If from report builder, if I run the report then it showing data properly. but if i generate the PDF, it showing Junk characters. Please Guide me, I am not able solve this problem.

Reporting a message just to draw attention, is one of the most certain ways NOT to get a decent answer.
Re: How to incorporate Unicode Font with forms 10g [message #332270 is a reply to message #320047] Tue, 08 July 2008 01:23 Go to previous messageGo to next message
jaymala_k
Messages: 19
Registered: May 2008
Location: India
Junior Member
Hi,

Still I am facing the same problem, for Arial Unicode MS .

Operating System : Windows 2000 advanced server.
Both database and Oracle Forms and Reports are installed on the same server.

Databse : Oracle 10g Release 1 .
Oracle Forms and Reports : Oracle 9i Developer Suite Release 2(9.0.2) Also installed Patch 3 .
Database setting :
NLS_LANG = AL32UTF8 NLS_NCHAR_LANG = AL16UTF16.
Langauge : Marathi Langauge
Font : Arial Unicode MS .
Windows Setting : From regional setting, Indic is selected for Marathi font.

If from Sql propmt I update the table values, it accept properly and also updating and quering from database properly without any issue. Not a problem for Combined letters.

For Forms :
1. I updated Registry.dat file, with font name 'Arial Unicode MS'.
2. In regedit, for Forms home, updated NLS_LANG=AMERICAN_AMERIC.UTF8 .

Now if in forms-canvas I want to type the Marathi lebel (with Arial Unicode MS) then showing '??????', but if i tried to copy the word from Character map, then it showing it properly.But on running the form it showing combine letter separated.

. On text box, it not allowing to type anything. for any key pressed it shows '????'. but if I copy from character map to text box, then it shows the marathi letters, but combined words are displaying separated.

. For reports : If from report builder, if I run the report then it showing data properly. but if i generate the PDF, it showing Junk characters. Please Guide me, I am not able solve this problem.

Any other settings are there, which I have missed. Please guide me

Jaymala
Re: How to incorporate Unicode Font with forms 10g [message #337853 is a reply to message #319564] Fri, 01 August 2008 06:23 Go to previous messageGo to next message
jaymala_k
Messages: 19
Registered: May 2008
Location: India
Junior Member
Hi,

Still I am facing the same problem. Please, it is urgent.

Regards,

Re: How to incorporate Unicode Font with forms 10g [message #339586 is a reply to message #337853] Thu, 07 August 2008 21:18 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you looked at the 'nls' settings in 'formsweb.cfg'?

David
Re: How to incorporate Unicode Font with forms 10g [message #339622 is a reply to message #339586] Fri, 08 August 2008 00:10 Go to previous messageGo to next message
jaymala_k
Messages: 19
Registered: May 2008
Location: India
Junior Member
Hi,

What changes I have to do in Formsweb.cfg? I have added 'nls_lang=UTF8' in default.env

I also attaching the formsweb.cfg file.

Regards,

Jaymala
  • Attachment: formsweb.pdf
    (Size: 52.90KB, Downloaded 3181 times)
Re: How to incorporate Unicode Font with forms 10g [message #339706 is a reply to message #339622] Fri, 08 August 2008 02:57 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Okay, there isn't an 'nls' setting in 'formsweb.cfg'. Maybe there isn't one in the Develoepr Server but I do know that there is one in the Application Server because it has given me problems before. Are you using a DS or an AS?

David
Re: How to incorporate Unicode Font with forms 10g [message #339719 is a reply to message #319564] Fri, 08 August 2008 03:55 Go to previous messageGo to next message
jaymala_k
Messages: 19
Registered: May 2008
Location: India
Junior Member
Hi,

Yes I am using DS.

Regards,

Jaymala
Re: How to incorporate Unicode Font with forms 10g [message #341204 is a reply to message #339719] Sun, 17 August 2008 20:52 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have a look at http://www.orafaq.com/forum/m/309700/67467/?srch=nls+code+page#msg_309700

I think you need to do more research concerning your PCs environment. The code page of the PC affects the DS.

David
Re: How to incorporate Unicode Font with forms 10g [message #414298 is a reply to message #319564] Tue, 21 July 2009 07:50 Go to previous messageGo to next message
gobirahul
Messages: 1
Registered: July 2009
Location: Germany
Junior Member

Hi Am also occuring the same error message as above.

i have VM with oracle AS/DB 10g installed. and tried to run a report with russian and german charecter. it shwoing to me as junk characters.
any ideas pls?
Re: How to incorporate Unicode Font with forms 10g [message #414659 is a reply to message #414298] Thu, 23 July 2009 02:09 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Does the report work in development on the DS?

David
Re: How to incorporate Unicode Font with forms 10g [message #507362 is a reply to message #319564] Sat, 14 May 2011 08:23 Go to previous messageGo to next message
jiju_alex_mathew
Messages: 2
Registered: May 2011
Junior Member
Hi Jayamala,

I also need to add malayalam font like this. Please help me for this.

Regards
Jiju Mathew
kerala
Re: How to incorporate Unicode Font with forms 10g [message #639891 is a reply to message #339719] Mon, 20 July 2015 04:13 Go to previous messageGo to next message
np2000
Messages: 3
Registered: July 2015
Junior Member
Hi Jaimala
did u solved you font problem,
pls share how u managed it , we are facing same issue with Thai fonts,
Rgds
Re: How to incorporate Unicode Font with forms 10g [message #639936 is a reply to message #639891] Mon, 20 July 2015 08:47 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
np2000 wrote on Mon, 20 July 2015 02:13
Hi Jaimala
did u solved you font problem,
pls share how u managed it , we are facing same issue with Thai fonts,
Rgds


This thread is ancient & DJMARTIN has since retired.

Is the problem a data storage problem or a data retrieval/presentation problem?
Re: How to incorporate Unicode Font with forms 10g [message #639966 is a reply to message #639936] Mon, 20 July 2015 23:23 Go to previous messageGo to next message
np2000
Messages: 3
Registered: July 2015
Junior Member
hi
it is data retrieval on reports 11g
Rgds
Re: How to incorporate Unicode Font with forms 10g [message #639967 is a reply to message #639966] Mon, 20 July 2015 23:32 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
np2000 wrote on Mon, 20 July 2015 21:23
hi
it is data retrieval on reports 11g
Rgds


I suspect NLS problem on the client side.
Re: How to incorporate Unicode Font with forms 10g [message #640016 is a reply to message #639967] Tue, 21 July 2015 06:46 Go to previous messageGo to next message
yogeeshbr@gmail.com
Messages: 1
Registered: June 2014
Location: India
Junior Member
Hi Pls any one could help me how to get the kannada/Regional language font in Oracle forms 10g still we are facing Problems...
Pls look at the attached file..
  • Attachment: FILE-.JPG
    (Size: 89.34KB, Downloaded 1389 times)
Re: How to incorporate Unicode Font with forms 10g [message #640235 is a reply to message #639967] Fri, 24 July 2015 06:10 Go to previous message
np2000
Messages: 3
Registered: July 2015
Junior Member
we have tried all the diff. nls_lang
NLS_LANG= AMERICAN_AMERICA.TH8TISASCII
#NLS_LANG=AMERICAN_AMERICA.TH8TISASCII
NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252
#NLS_LANG=AMERICAN_AMERICA.AL32UTF8
#NLS_LANG=AMERICAN_AMERICA.UTF8
#WE8MSWIN1252
#NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
# THAI_THAILAND.TH8TISASCII
#NLS_LANG=AMERICAN_AMERICA.TH8TISASCII
#NLS_LANG=AMERICAN_AMERICA.AL32UTF8
NLS_LENGTH_SEMANTICS=CHAR
#NLS_CALENDAR=THAI BUDDHA
#NLS_DATE_FORMAT=DD/MM/YYYY

but no success.
Rgds
Previous Topic: check box
Next Topic: developer 66 slow to response in window 7
Goto Forum:
  


Current Time: Thu Mar 28 11:02:20 CDT 2024