character error in oracle forms / error nls lang [message #658635] |
Thu, 22 December 2016 04:31 |
suh_sh
Messages: 22 Registered: January 2006 Location: Jordan
|
Junior Member |
|
|
[MERGED by MC, and then by LF]
Dir sir ,
please , help me to solve this problem .
I installed Kurdi keyboard to write kurdish language . its look like arabic language .
when writing title in forms developer at design mode or when inserting data at run time mode
some characters (5 characters) appear error as ? or ... .
I used nls_lang=AMERICAN_AMERICA.AR8MSWIN1256
when I insert data into Notepad or MS Word all of it is fine without any problem .
thanks
[Updated on: Thu, 12 January 2017 13:57] by Moderator Report message to a moderator
|
|
|
|
|
|
Re: character error in oracle forms [message #658663 is a reply to message #658644] |
Thu, 22 December 2016 14:01 |
suh_sh
Messages: 22 Registered: January 2006 Location: Jordan
|
Junior Member |
|
|
NAME SUBSTR(VALUE$,1,30)
------------------------------ ----------------------------
DICT.BASE 2
DEFAULT_TEMP_TABLESPACE TEMP
DBTIMEZONE -08:00
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET AR8MSWIN1256
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MM-YYYY
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET AL16UTF16
*BlackSwan added {code} tags Please do so yourself in the future
How to use {code} tags and make your code easier to read
[Updated on: Thu, 22 December 2016 14:06] by Moderator Report message to a moderator
|
|
|
|
|
|
error nls lang [message #658760 is a reply to message #658635] |
Mon, 26 December 2016 06:28 |
suh_sh
Messages: 22 Registered: January 2006 Location: Jordan
|
Junior Member |
|
|
Dir sir,
Please , help me , what nls_lang should I have to use in Arabic & Kurdish languages
when I writing it appear as ??? for some characters as : ط ذّ ظ ێ ؤ ث لآ
this error occurred in writing title of fields (prompt) and in writing into field into Database .
the Kurdish language same as Arabic language with some difference in 11 characters .
when I write using ms word or Notepad its ok without error .
I used AMERICAN_AMERICA.AR8MSWIN1256
AMERICAN_AMERICA.AL32UTF8
AMERICAN_AMERICA.AR8ASMO8X
AMERICAN_AMERICA.UTF8
AMERICAN_AMERICA.UTF16
And others , but still same error .
thanks
|
|
|
|
|
Re: error nls lang [message #658770 is a reply to message #658768] |
Mon, 26 December 2016 15:00 |
suh_sh
Messages: 22 Registered: January 2006 Location: Jordan
|
Junior Member |
|
|
Dir sir ,
please, help me to find the solution of using suitable nls_lang .
the problem is not in the database or in query script .
the error occurred before connecting to database . as explained in attach document .
thanks
[Updated on: Tue, 27 December 2016 00:23] by Moderator Report message to a moderator
|
|
|
|
|
Re: error nls lang [message #658786 is a reply to message #658782] |
Tue, 27 December 2016 03:15 |
suh_sh
Messages: 22 Registered: January 2006 Location: Jordan
|
Junior Member |
|
|
it is in both . in oracle forms 10g , 6i before and after connecting to DB .
and in DB . , I'm trying to insert into DB by using forms and SQL , but failed .
|
|
|
|
Re: error nls lang [message #658868 is a reply to message #658824] |
Thu, 29 December 2016 01:03 |
suh_sh
Messages: 22 Registered: January 2006 Location: Jordan
|
Junior Member |
|
|
Thanks , I find the solution , now its ok . as here :
1 - set database character set to utf8
connect "AS SYSDBA" in sqlplus.
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
ALTER DATABASE OPEN;
ALTER DATABASE CHARACTER SET INTERNAL_USE UTF8;
SHUTDOWN;
STARTUP RESTRICT;
SHUTDOWN;
STARTUP;
2 - set registry to both database and forms
nls_lang= AMERICAN_AMERICA.UTF8
regards
|
|
|
|
Re: error nls lang [message #658912 is a reply to message #658869] |
Fri, 30 December 2016 12:55 |
suh_sh
Messages: 22 Registered: January 2006 Location: Jordan
|
Junior Member |
|
|
thank you sir ,
the problem still in forms 6i at design mode with nls_lang = AMERICAN_AMERICA.UTF8 , when I write title in
Kurdish character , the forms hang and closed . but at run time mode its OK . so in design mode I change nls_lang to AMERICAN_AMERICA.AR8MSWIN1256 .
so , please tell me if there is any error in DB setting .
thanks
|
|
|
Re: error nls lang [message #658959 is a reply to message #658912] |
Mon, 02 January 2017 05:51 |
suh_sh
Messages: 22 Registered: January 2006 Location: Jordan
|
Junior Member |
|
|
Dir sir,
the problem still in the form .
the title and field prompt appear as rubbish character when use nls_lang = AMERICAN_AMERICA.UTF8
but db is write and retrieve is OK .
please if you have solution ?
|
|
|
Re: error nls lang [message #659051 is a reply to message #658959] |
Thu, 05 January 2017 03:06 |
suh_sh
Messages: 22 Registered: January 2006 Location: Jordan
|
Junior Member |
|
|
Dir sir,
I still have error when connecting oracle forms 6i using nls_lang=utf8 with DB 11 character set = utf8
the canvas title and prompt and frame title are rubbish and it hang .
when useing forms 10g using nls_lang = utf8, al32utf8, al16utf16 , ar8mswin1256 , ... . whith db 11 utf8 : some characters still appear as ??? .
please help me .
is the oracle forms 6i patch 19 solve these problem ? from where can I download it ?
thanks
|
|
|
Re: error nls lang [message #659079 is a reply to message #659051] |
Thu, 05 January 2017 13:02 |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
This is not a complete answer to your question as I do not have any experience with character sets, but I will tell you that I doubt patch 19 would solve the problem and that there is nowhere to download it as it has been desupported for over 15 year I think.
Now mind you, 6i will indeed connect to 11g and even 12c, and most functionality works, but something like character set conversion might be one of those things that it just cannot do.
|
|
|
oracle developer 10g hang using nls_lang=UTF8 [message #659317 is a reply to message #658635] |
Thu, 12 January 2017 10:52 |
suh_sh
Messages: 22 Registered: January 2006 Location: Jordan
|
Junior Member |
|
|
Dir sir ,
Please, I use DB 11 , character set UTF8,
Oracle developer 10g , nls_lang = American_america.utf8
oracle developer hang and closed .
but its ok when using nls_lang=american_america.ar8mswin1256 , or other nls lang .
please if you can help me . itis necessary to me to use DB Character set = UTF8 to write kurdish characters.
thanks
|
|
|
Re: oracle developer 10g hang using nls_lang=UTF8 [message #659324 is a reply to message #659317] |
Thu, 12 January 2017 14:05 |
|
Littlefoot
Messages: 21813 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
There's no use in opening a new topic for the same problem; please, do not do that any more. It's now 3 topics we merged; that would be enough, I presume.
It's a pity you can not find the solution for that problem. Regarding Michel's message #658869, which is based on what you've done (and described) in a message #658868, your database is now in a useless state. Although I'm not a DBA and I do not have experience with different character sets nor NLS settings, I believe (simply by following discussions on the Internet) that you can't fix such things - if you can afford it, drop the database and create a brand new one, but this time using correct settings. Everything else seems to be waste of your (and our) time. Hopefully, someone else will be able to assist better than I can.
|
|
|
|
Re: oracle developer 10g hang using nls_lang=UTF8 [message #659457 is a reply to message #659381] |
Wed, 18 January 2017 05:42 |
suh_sh
Messages: 22 Registered: January 2006 Location: Jordan
|
Junior Member |
|
|
Hi ,
Oracle forms 6i error when nls_lang = american_america.utf8 : title and prompt appear as rubbish character ,
oracle forms 10g : hang and closed when nls_lang = american_america.utf8 .
DB 11 , CHARACTER SET INTERNAL_USE UTF8
is there any one can help me to solve this problem ?
|
|
|
|
|