|
You can bind or define a Java string against anNCHARcolumn without explicitly specifying the form of use argument. This implies the following:
-
If you do not specify the argument in thesetString()method,then JDBC assumes that the bind or define variable is for the SQLCHARcolumn. As a result,it tries to convert them to the database character set. When the data gets to the database,the database implicitly converts the data in the database character set to the national character set. During this conversion,data can be lost when the database character set is a subset of the national character set. Because the national character set is either UTF8 or AL16UTF16,data loss would happen if the database character set is not UTF8 or AL32UTF8.
-
Because implicit conversion from SQLCHARto SQLNCHARdata types happens in the database,database performance is degraded.
（编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
