oracle学习23-区分大小写和字符集不同

7. 11g默认开始密码区分大小写 可以通过把参数设置为 SEC_CASE_SENSITIVE_LOGON =FALSE 屏蔽

 

 

alter system set  SEC_CASE_SENSITIVE_LOGON =FALSE scope=both;

8. 字符集不同

Database character set (AL32UTF8) and Client character set (ZHS16GBK) are different. 
Character set conversion may cause unexpected results. Note: you can set the
 client character set through the NLS_LANG environment variable or the NLS_LANG
 registry key in HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/KEY_ OraDb11g_home