Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PlsqlNLSLanguage WE8ISO8859P1 vs AL32UTF8

FMignaultJul 2 2007 — edited Jul 9 2007
Hi,

I upgraded to 3.0.1 and I am having some issues with apostrophe when I switch the PlsqlNLSLanguage from WE8ISO8859P1 to AL32UTF8.

I did run the OWAINST script to upgrade Web Toolkit.
So my pages displays correctly except for those apostrophe that shows as little squares.

If I use WE8ISO8859P1 , everything displays and inserts correctly. Why can't I keep this setting for PlsqlNLSLanguage ?

If I use AL32UTF8 , when I insert, the apostrophe shows as reversed questionmarks ( de l¿AQIII ). When I select apostrophe inserted in WE8ISO8859P1 , it shows as little boxes. (de l�AQIII )


I am kind of stuck with this.

Anybody experiencing this behaviour ?

Normal apostrophe works, it's when I cut and paste from Word that it does not inserts correctly.

I am using APEX 3.0.1
OWA 10.1.2.0.6
DB : 10.1.0.5.0
DB Characterset : WE8ISO8859P1

Thanks

Francis.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 6 2007
Added on Jul 2 2007
#apex-discussions
8 comments
2,839 views