Both db and forms are 11g, runing in linux
I'm experiencing problems in forms 11g with odd characters. I'm quite sure it's due to a character set mismatch between forms and database.
Forms shows this character ´ (chr(180)) as ¿ (forms is unable to print it , and I get an ORA-12713 Character data loss in NCHAR/CHAR conversion)
db is in AMERICAN_AMERICA.WE8MSWIN1252 , as I see when I query
select * from NLS_DATABASE_PARAMETERS;
I'm pretty sure that the client is running NLS_LANG=spanish_spain.WE8ISO8859P15 (taken from .bash_profile)
I can even reproduce the problem in sqldeveloper, as if I issue this query
select chr(180) good, CONVERT(CHR(180),'WE8ISO8859P15') bad FROM DUAL;
I get:
Just the same that happens in forms.
I read the manual:
Configuring and Managing Forms Services - 11g Release 1 (11.1.1)
and it seems that I should match charsets in both db and weblogic, but I'm not sure where I should set NLS_LANG parameter or charset in forms and leave it set for good.
Is it the env variable of the oracle user in the .bash_profile in linux running weblogic?
... or is it better setting a defaultcharset parameter in formsweb.cfg?
... or I have to look for the script that runs the forms services?