Home » Developer & Programmer » Application Express & MOD_PLSQL » Special Character issue for inserting into Db table from Apex form (Apex 3.01. and Oracle 10g.)
Special Character issue for inserting into Db table from Apex form [message #566816] Wed, 19 September 2012 16:00 Go to next message
arunkumar_p
Messages: 2
Registered: September 2012
Location: USA
Junior Member
hello,

i am using apex 3.01. and Oracle 10g. I created one new apex frond page and in the page we have description column . while inserting or copying content from any word document or manually typing some content in the text area and again i submitted the data from apex page to DB tables.

Entered content in the Apex Text Area:

i cannot be discussed a as it is a part of our customers' competitive advantage

After insertion into table i can see data in the table like :


i cannot be discussed a as it is a part of our customers┬┐ competitive advantage

for example:

customers' --> customers┬┐

Please suggest me how to avoid special character issue.

Thanks,
Arun

[Updated on: Wed, 19 September 2012 16:10]

Report message to a moderator

Re: Special Character issue for inserting into Db table from Apex form [message #566818 is a reply to message #566816] Wed, 19 September 2012 16:10 Go to previous messageGo to next message
arunkumar_p
Messages: 2
Registered: September 2012
Location: USA
Junior Member
My oracle DB

NLS_CHARACTERSET is : WE8ISO8859P1
Re: Special Character issue for inserting into Db table from Apex form [message #567633 is a reply to message #566818] Wed, 03 October 2012 15:03 Go to previous message
andrew again
Messages: 2574
Registered: March 2000
Senior Member
You've almost certainly hit Microsoft's amazing nasty smart quotes. Your single quote is probably being changed to Left Single Quote. Similarly when you close a quote, MS Word changes it to Right Single Quote.

Your database characterset WE8ISO8859P1 stands for 'Western European ISO 8859.1', also known as Latin 1, whereas Microsoft is probably using their extended version called cp1252, which is the same as ISO 8859.1, except that their smart quotes etc, are encoded in the range x80-x9F, that is unused in ISO 8859.1.

So the bottom line is that your database codepage doesn't support the special characters (smart quotes etc) that Microsoft added to their extended version of Latin1. cp1252 is a superset of ISO 8859.1, and smart quotes etc cant be arent defined in ISO 8859.1

Left ==> http://www.fileformat.info/info/unicode/char/2018/index.htm
Right ==> http://www.fileformat.info/info/unicode/char/2019/index.htm

[Updated on: Wed, 03 October 2012 15:08]

Report message to a moderator

Previous Topic: Apex page performance
Next Topic: Apex not displaying success message
Goto Forum:
  


Current Time: Sat Sep 20 21:41:49 CDT 2014

Total time taken to generate the page: 0.15896 seconds