hi all,
Database 11gR2, Forms 10g
Test App Server: OS = Windows 2003
Development:
OS = WinXP
created an entry in default.env file as NLS_LANG=AMERICAN_AMERICA.AL32UTF8 which cause problem so remark it.
AMC.@.testdb > SELECT *
2 from NLS_DATABASE_PARAMETERS
3 WHERE parameter IN ( 'NLS_LANGUAGE', 'NLS_TERRITORY', 'NLS_CHARACTERSET');
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CHARACTERSET WE8MSWIN1252
We temporary changed above character set to AMERICAN.AMERICA.AL32UTF8 but we have to use WE8MSWIN1252 because here are some application modules running on Very Old version of Forms and Reports which is 6i.
created a Function to get values in xmltype ( thanks to Billy Verreynne ) through an another Function which convert these values in normal format ( thanks to odie_63 ) but due to some data in Urdu Language it not showing those column data as it should be. the first function getting data through a Web Service and data is in utf-8 character set.
link for above mentioned topic: How to access API through Web Service in Oracle 11gR2
@"odie_63" advised me in his Reply # 13 of topic Oracle 11g: Character Set / Language Problem :
As for your issue in Forms, I suggest you ask over in space.
please help how to display Urdu Language in Forms 10g? it is very similar to Arabic Language and Right to Left.
regards