Skip to Main Content

SQL & PL/SQL

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!

converting UNICODE hexvalues for Arabic text to to decimal values with format string "&#<decimal val

Mohammad ShaddadSep 10 2019 — edited Sep 11 2019

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>;"

&#1632;&#1633;&#1634;&#1635;&#1636;&#1637;&#1638;&#1639;&#1640;&#1641;

Note:

My Database: 11.2.0.4.0

NLS_CHARACTERSET: AL32UTF8

Thanks ...

This post has been answered by Paulzip on Sep 10 2019
Jump to Answer
Comments
Post Details
Added on Sep 10 2019
2 comments
2,372 views