Hi All
Kindly, is there is any SQL function can help in the following:
converting UNICODE hexvalues for Arabic text to to decimal values with format string "&#<decimal value>;"
For example:
1-Retrieve the UNICODE hexvalues for "٠١٢٣٤٥٦٧٨٩" by using the Unicode Org code page
0660 ٠ ARABIC-INDIC ZERO
0661 ١ ARABIC-INDIC ONE
0662 ٢ ARABIC-INDIC TWO
0663 ٣ ARABIC-INDIC THREE
0664 ٤ ARABIC-INDIC FOUR
0665 ٥ ARABIC-INDIC FIVE
0666 ٦ ARABIC-INDIC SIX
0667 ٧ ARABIC-INDIC SEVEN
0668 ٨ ARABIC-INDIC EIGHT
0669 ٩ ARABIC-INDIC NINE
which gives for "٠١٢٣٤٥٦٧٨٩" following Unicode hexvalue train:
0660 0661 0662 0663 0664 0665 0666 0667 0668 0669
2-Convert the hex values from Step 1. to decimal values to be as following:
1632 1633 1634 1635 1636 1637 1638 1639 1640 1641
3-Use HTML to encode the Unicode characters decimal values from Step 3. by using format string "&#<decimal value>;"
٠١٢٣٤٥٦٧٨٩
Note:
My Database: 11.2.0.4.0
NLS_CHARACTERSET: AL32UTF8
Thanks ...