Multibyte Character problem post migration [message #457299] |
Sun, 23 May 2010 05:24 |
chiragm
Messages: 4 Registered: May 2010
|
Junior Member |
|
|
Hi,
We just migrated our technology platform on one of the six servers yesterday on production d/b as follows :
OAS Server - Linux Patch Applied (2.6.18-53.el5 #1 SMP Wed Oct 10 16:34:19 EDT 2007 x86_64 x86_64 x86_64 GNU/Linux)
D/B Server - From Oracle 10.2.0.2.0 to Oracle 10.2.0.4.0
Batch Server - From OpenVMS to Red Hat Linux
Post Migration, we are facing some issues with Oracle Forms 10g, Text Items which contains one or more than one multibyte characters, is displaying only # character in the entire text box instead of what is stored in the database. In other words, information in the database is stored correctly. Before Migration everything was working perfectly fine.
One other thing which I would like to tell here is that we compile forms using the following environment settings:
NLS_LANG_SEMANTICS=CHAR
NLS_LANG=AMERICAN_AMERICA.UTF8
Please provide urgent remedy for this issue as business users are raising hue and cry.
[Updated on: Sun, 23 May 2010 05:43] Report message to a moderator
|
|
|
|
|
|
|
|
Re: Multibyte Character problem post migration [message #457441 is a reply to message #457347] |
Mon, 24 May 2010 08:13 |
chiragm
Messages: 4 Registered: May 2010
|
Junior Member |
|
|
Hi Martin,
Yes, your understanding is correct.
Problem is with the text items which contains only multibyte character.
Rest of the text items are perfect.
Suggestion provided by you is correct but the limitation is that this requires changes both at database level and form level which will require extensive testing and good amount of time also.
My doubt is that why this problem occured post migration as it was working fine earlier.
|
|
|
|
|
|