hibernate - Oracle 11g What is recommended charset for international appliaction -
what nls_nchar_characterset , nls_characterset should use? use varchar2 store text. want support chinese , other characters. application writen in java , hibernate. should use al32utf8 both? there issues using utf16 instead of utf8?
utf-16: each character either 2 or 4 bytes long. utf-8: each character takes 1 4 bytes store.
usually use foreign languages (russian , turkish, arabic..) utf8 , , have never had problem in documentation.
the benefits of utf-16 on utf-8 follows:
more compact storage asian scripts because of commonly used asian characters represented in 2 bytes.
better compatibility java , microsoft clients
utf-16 encoding 16-bit encoding of unicode. extension of ucs-2
utf-8 8-bit encoding of unicode. variable-width encoding , strict superset of ascii.
read more in oracle supporting multilingual databases unicode , choosing character set maybe contains information might
Comments
Post a Comment