-2- |
---|
У тебя основная кодировка какая? |
SQL> select *
2 from nls_database_parameters
3 where parameter like '%CHARACTERSET';
PARAMETER VALUE
------------------------------ --------------------------------------------------------------------------------
NLS_CHARACTERSET AL32UTF8
NLS_NCHAR_CHARACTERSET AL16UTF16
orawish |
---|
dump() используйте - он всё покажет |
SQL> select t.s s,
2 lengthb(t.s) b,
3 lengthc(t.s) c,
4 length(t.s) l,
5 lpad(t.s, 10, x) s1,
6 dump(lpad(t.s, 10, x)) d,
7 lengthb(lpad(t.s, 10, x)) b,
8 lengthc(lpad(t.s, 10, x)) c,
9 length(lpad(t.s, 10, x)) l
10 from
11 (select cast('Я' as varchar2(3 char)) s from dual
12 union all select 'МЫ' from dual
13 union all select convert('Я','CL8MSWIN1251','AL32UTF8') from dual
14 union all select convert('МЫ','CL8MSWIN1251','AL32UTF8') from dual
15 union all select convert('Z','CL8MSWIN1251','AL32UTF8') from dual
16 ) t,
17 (
18 select '*' x from dual union all select 'ё' x from dual union all select 'ы' x from dual
19 ) p;
S B C L S1 D B C L
--- --- --- --- -------------------- ---------------------------------------------------------------------------------------------------- --- --- ---
Я 2 1 1 ********Я Typ=1 Len=10: 42,42,42,42,42,42,42,42,208,175 10 9 9
МЫ 4 2 2 ******МЫ Typ=1 Len=10: 42,42,42,42,42,42,208,156,208,171 10 8 8
Я 1 0 0 ********** Typ=1 Len=10: 42,42,42,42,42,42,42,42,42,42 10 10 10
МЫ 2 1 1 *********МЫ Typ=1 Len=11: 42,42,42,42,42,42,42,42,42,204,219 11 10 10
Z 1 1 1 *********Z Typ=1 Len=10: 42,42,42,42,42,42,42,42,42,90 10 10 10
Я 2 1 1 ёёёёёёёёЯ Typ=1 Len=18: 209,145,209,145,209,145,209,145,209,145,209,145,209,145,209,145,208,175 18 9 9
МЫ 4 2 2 ёёёёёёМЫ Typ=1 Len=16: 209,145,209,145,209,145,209,145,209,145,209,145,208,156,208,171 16 8 8
Я 1 0 0 ёёёёёёёёёё Typ=1 Len=20: 209,145,209,145,209,145,209,145,209,145,209,145,209,145,209,145,209,145,209,145 20 10 10
МЫ 2 1 1 ёёёёёёёёёМЫ Typ=1 Len=20: 209,145,209,145,209,145,209,145,209,145,209,145,209,145,209,145,209,145,204,219 20 10 10
Z 1 1 1 ёёёёёёёёёZ Typ=1 Len=19: 209,145,209,145,209,145,209,145,209,145,209,145,209,145,209,145,209,145,90 19 10 10
Я 2 1 1 ыыыыЯ Typ=1 Len=10: 209,139,209,139,209,139,209,139,208,175 10 5 5
МЫ 4 2 2 ыыыМЫ Typ=1 Len=10: 209,139,209,139,209,139,208,156,208,171 10 5 5
Я 1 0 0 ыыыыы Typ=1 Len=10: 209,139,209,139,209,139,209,139,209,139 10 5 5
МЫ 2 1 1 ыыыыМЫ Typ=1 Len=11: 32,209,139,209,139,209,139,209,139,204,219 11 6 6
Z 1 1 1 ыыыыZ Typ=1 Len=10: 32,209,139,209,139,209,139,209,139,90 10 6 6
15 rows selected