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

Popular posts from this blog

sql - invalid in the select list because it is not contained in either an aggregate function -

Angularjs unit testing - ng-disabled not working when adding text to textarea -

How to start daemon on android by adb -