PHP code: SQL> drop table test purge; Table dropped. SQL> create table test(col1 number(1),col2 varchar2(10)); Table created.
SQL> drop table test purge; Table dropped. SQL> create table test(col1 number(1),col2 varchar2(10)); Table created.
PHP code: SQL> insert into test values(1,'中国'); --1为session 1的标记 1 row created. SQL> commit; Commit complete.
SQL> insert into test values(1,'中国'); --1为session 1的标记 1 row created. SQL> commit; Commit complete.
PHP code: SQL> insert into test values(2,'中国'); --2为session 2的标记 1 row created. SQL> commit; Commit complete. --session 1 SQL> select * from test; COL1 COL2 ---------- -------------------- 2 ??? 1 中国 --session 2 SQL> select * from test; COL1 COL2 ---------- ---------- 2 中国 &nb
SQL> insert into test values(2,'中国'); --2为session 2的标记 1 row created. SQL> commit; Commit complete. --session 1 SQL> select * from test; COL1 COL2 ---------- -------------------- 2 ??? 1 中国 --session 2 SQL> select * from test; COL1 COL2 ---------- ---------- 2 中国 &nb
PHP code: --session 1 (或者session 2,在这里无所谓) SQL> select col1,dump(col2,1016) from test; COL1 ---------- DUMP(COL2,1016) -------------------------------------------------------------------------------- 2 Typ=1 Len=4 CharacterSet=AL32UTF8: d6,d0,b9,fa 1 Typ=1 Len=6 CharacterSet=AL32UTF8: e4,b8,ad,e5,9b, --session 1 SQL> select dump('中',1016) from dual; DUMP('中',16) -------------------------------------------- Typ=96 Len=3 CharacterSet=AL32UTF8: e4,b8,ad --字符“中” ,和上面直接从数据库中读取存储的字符编码一致。 SQL> select dump('国',1016) from dual; DUMP('国',16) -------------------------------------------- Typ=96 Len=3CharacterSet=AL32UTF8: e5,9b,bd --字符“国” ,和上面直接从数据库中读取存储
--session 1 (或者session 2,在这里无所谓) SQL> select col1,dump(col2,1016) from test; COL1 ---------- DUMP(COL2,1016) -------------------------------------------------------------------------------- 2 Typ=1 Len=4 CharacterSet=AL32UTF8: d6,d0,b9,fa 1 Typ=1 Len=6 CharacterSet=AL32UTF8: e4,b8,ad,e5,9b, --session 1 SQL> select dump('中',1016) from dual; DUMP('中',16) -------------------------------------------- Typ=96 Len=3 CharacterSet=AL32UTF8: e4,b8,ad --字符“中” ,和上面直接从数据库中读取存储的字符编码一致。 SQL> select dump('国',1016) from dual; DUMP('国',16) -------------------------------------------- Typ=96 Len=3CharacterSet=AL32UTF8: e5,9b,bd --字符“国” ,和上面直接从数据库中读取存储
PHP code: c:chcp 活动的代码页: SQL> select col1,dump(col2,1016) from t1; COL1 ---------- DUMP(COL2,1016) -------------------------------------------------------------------------------- 2 Typ=1 Len=4 CharacterSet=AL32UTF8: d6,d0,b9,fa 1 Typ=1 Len=6 CharacterSet=AL32UTF8: e4,b8,ad,e5,9b, SQL> select col1,dump(col2,1016) from test; COL1 ---------- DUMP(COL2,1016) -------------------------------------------------------------------------------- 2 Typ=1 Len=4 CharacterSet=AL32UTF8: d6,d0,b9,fa 1 Typ=1 Len=6 CharacterSet=AL32UTF8: e4,b8,ad,e5,9b, --session 1 SQL> SQL> insert into t1 values('中国',1); 1 row created. SQL> commit; Commit complete. SQL> select * from t1; COL COL2 ------------ ---------- 中国 1 ??? 2 --session 2 SQL> insert into t1 values('中国',2); 1 row created. SQL> commit; Commit complete. SQL> select * from t1; COL COL2 ------ ---------- 涓浗 1 中国 &nb
c:chcp 活动的代码页: SQL> select col1,dump(col2,1016) from t1; COL1 ---------- DUMP(COL2,1016) -------------------------------------------------------------------------------- 2 Typ=1 Len=4 CharacterSet=AL32UTF8: d6,d0,b9,fa 1 Typ=1 Len=6 CharacterSet=AL32UTF8: e4,b8,ad,e5,9b, SQL> select col1,dump(col2,1016) from test; COL1 ---------- DUMP(COL2,1016) -------------------------------------------------------------------------------- 2 Typ=1 Len=4 CharacterSet=AL32UTF8: d6,d0,b9,fa 1 Typ=1 Len=6 CharacterSet=AL32UTF8: e4,b8,ad,e5,9b, --session 1 SQL> SQL> insert into t1 values('中国',1); 1 row created. SQL> commit; Commit complete. SQL> select * from t1; COL COL2 ------------ ---------- 中国 1 ??? 2 --session 2 SQL> insert into t1 values('中国',2); 1 row created. SQL> commit; Commit complete. SQL> select * from t1; COL COL2 ------ ---------- 涓浗 1 中国 &nb