[opencms-dev] Oracle8i Character Encoding

[Mark J. Weidner]

Based on the OpenCMS documentation I've read, the follow is how the language specific data storage is handled in OpenCMS:

1) Content can be in edited / stored in any encoding (e.g. "Big5", "ISO8859_5" etc.)
2) Resource is saved in native encoding in the OpenCms VFS repository
3) While processing dynamic pages, content is converted to UTF-8 (Unicode)
4) Response encoding is set depending on business logic of the application

This still leaves me with the question of what encoding needs to be used on the DB to store both Western and Asian languages.  Since the data appears to be stored in it's native encoding, then converted to UTF-8, I'll assume I need a specific characterset to accommodate all the languages being used (since it's ultimately converted to UTF-8, I would assume just create the Oracle DB under the UTF-8 encoding).  Then again, IF it's all stored simply as unicode in the DB as text, I'm not sure I need to create another instance running under UTF-8.

Thoughts?

-Mark
  ----- Original Message ----- 
  From: Mark J. Weidner 
  To: opencms-dev at opencms.org 
  Sent: Thursday, July 01, 2004 10:25 AM
  Subject: [opencms-dev] Oracle8i Character Encoding


  Hello everyone,

  I've been using OpenCMS 5.0.1 storing english content using Oracle8i, and will now be incorporating additional European and Asian languages.  As such, I'm curious as to whether I need to setup a separate Oracle instance using a specific character encoding (I'll assume as UTF-8, or perhaps UTF-16), or does the default Oracle encoding handle this properly with OpenCMS?  If anyone has any experience in this area, please let me know.

  Thanks!

  -Mark
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20040710/b2c42be6/attachment.htm>