select userenv('language') from dual;
SELECT * FROM V$NLS_PARAMETERS
ORACLE有三方面的字符集,一是oracel server端的字符集,二是oracle client端的字符集;三是dmp文件的字符集。
--查看oracel server端的字符集
select userenv('language') from dual;
--查看oracel client端的字符集
设置环境变量 : NLS_LANG = SIMPLIFIED CHINESE_CHINA.WE8MSWIN1252
when insert data to table , please take note that format of SQL value .
it should be DOS utf-8 in windows .
in java code :
byte bytesInvoice[] = invDetails.getBytes("CP1252"); //编码
System.out.println(new String(tempInvoice,"GBK")); // 转码