17,086
社区成员
发帖
与我相关
我的任务
分享
SQL> SELECT STR
2 FROM (SELECT '中国' STR FROM DUAL UNION ALL
3 SELECT '英国1' STR FROM DUAL UNION ALL
4 SELECT '美国2' STR FROM DUAL UNION ALL
5 SELECT '日本123' STR FROM DUAL UNION ALL
6 SELECT '韩国。,,.' STR FROM DUAL UNION ALL
7 SELECT '123' STR FROM DUAL UNION ALL
8 SELECT 'abcde' STR FROM DUAL)
9 WHERE TO_SINGLE_BYTE(STR) = TO_MULTI_BYTE(STR) ;
STR
----------
中国
英国1
美国2
日本123
韩国。,,.
123
abcde
7 rows selected.
SQL> SELECT * FROM nls_database_parameters WHERE parameter LIKE 'NLS_%';
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE AMERICAN
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET US7ASCII
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_RDBMS_VERSION 11.1.0.7.0
20 rows selected.
SQL>
SQL> SELECT STR
2 FROM (SELECT '中国' STR FROM DUAL UNION ALL
3 SELECT '英国1' STR FROM DUAL UNION ALL
4 SELECT '美国2' STR FROM DUAL UNION ALL
5 SELECT '日本123' STR FROM DUAL UNION ALL
6 SELECT '韩国。,,.' STR FROM DUAL UNION ALL
7 SELECT '123' STR FROM DUAL UNION ALL
8 SELECT 'abcde' STR FROM DUAL)
9 WHERE TO_SINGLE_BYTE(STR) = TO_MULTI_BYTE(STR)
10 /
STR
------------------------
中国
SELECT first_name, length(first_name), lengthb(first_name) FROM cnods.MEMBER WHERE rownum<10;
1 许燕 4 4
2 谢明明 6 6
3 秦岚 4 4
4 卢赞超 6 6
5 徐东 4 4
6 西村真友美 10 10
7 邹林江 6 6
8 chenxia 7 7
9 杨洪林 6 6
select name from tb where length(name)*3=lengthb(name);
SQL> select * from v$nls_parameters where PARAMETER='NLS_CHARACTERSET';
PARAMETER VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
NLS_CHARACTERSET US7ASCII