Thanks for the question, Radhakrishna.
Asked: August 18, 2017 - 5:39 am UTC
Last updated: August 18, 2017 - 2:09 pm UTC
Version: 11g
Viewed 1000+ times
You Asked
How to know whether utf16 to utf8 character conversion allowed using convert function,
similarly F7DEC to US7ASCII etc. ?
and we said...
The CONVERT function generally supports conversion between any two known Oracle character sets. Check Appendix A of the Database Globalization Support Guide for the list of these character sets. However, the CONVERT function takes a VARCHAR2 input and produces a VARCHAR2 result. Both cannot be valid values in the database character set at the same time. Therefore, the CONVERT function should be used only for special repair tasks. If you need to temporarily store or process a value in a character set different from the database character set, you should use the RAW data type and the functions from the package UTL_RAW.
Is this answer out of date? If it is, please let us know via a Comment