[@more@]
/* Formatted on 2006/09/07 13:58 (Formatter Plus v4.8.7) */
CREATE TABLE test_char_han(
c_han VARCHAR2(100)
);
/* Formatted on 2006/09/07 13:58 (Formatter Plus v4.8.7) */
INSERT INTO test_char_han
(c_han
)
VALUES ('鸟'
);
/* Formatted on 2006/09/07 13:58 (Formatter Plus v4.8.7) */
SELECT *
FROM test_char_han COMMIT;
/* Formatted on 2006/09/07 13:57 (Formatter Plus v4.8.7) */
SELECT c_han
FROM test_char_han
WHERE ASCIISTR (c_han) like '%%';