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.

What encoding should the content store use?

April 26, 2017content encoding store

0

Posted

What encoding should the content store use?

1 Answer

0

Posted

The content store database should support Unicode. MS SQL Server uses Unicode by default. On Oracle ensure that the database is either UTF-8 or UTF-16. To determine if your Oracle database is Unicode. execute the following query:select * from NLS_DATABASE_PARAMETERSThe result set returns NLS_CHARACTERSET as UTF-8 or UTF-16, or AL32UTF8 or AL16UTF16, or not Unicode.If the result set returns an NLS_CHARACTERSET that is not Unicode, create a new database and specify AL32UTF8 or UTF-8 for the database character set parameters.