Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Oracle recommends using AL32UTF8 as the character set compared to UTF8.Why?

April 26, 2017character Oracle recommends

0

Posted

Oracle recommends using AL32UTF8 as the character set compared to UTF8.Why?

1 Answer

0

Posted

UTF8 was the UTF-8 encoded character set in Oracle 8 and 8i. To maintain compatibility with existing installations this character set will remain at unicode version 3.0 in future oracle releases. Specific supplementary characters were not assigned to unicode until Unicode version 3.1. Hence the supplementary characters(chinese,japanese,korean,gothic,old italic,mathematical,musical) could come with a inverted question mark(?). Hence oracle recommends using the AL32UTF8 for full supplementary character support. AL32UTF8 supports the latest version of the Unicode standard.