Oracle Database Discussions

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!

French character

647600Feb 17 2009 — edited Feb 20 2009

Dear DBAs

I have a database with a characterset "AR8ISO8859P6" and all the users are using the NLS_LANG=AR8MSWIN1256. everything was fine even when inserting arabic character.

but when inserting french/latin characterset (é à ç... etc) using the same nls_lang the query will be Incomprehensive, so i tried to insert these characters using the nls_lang as the characterset it works fine, but in this case i need to change all nls_lang on all user's pcs which might wont work for the data already inserted.

so do you have a solution ?

Regards

This post has been answered by JustinCave on Feb 20 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 20 2009

Added on Feb 17 2009

#general-database-discussions

9 comments

1,417 views