Consider the following table:
CREATE TABLE cstr (c1 CHAR(3) CHARACTER SET LATIN ,c2 CHAR(10) CHARACTER SET KANJI1);
INSERT cstr ('abc', '92
abc
| INSERT cstr ('abc', '92abcFunction | Result |
|---|---|
| SELECT SUBSTR(c2, 2, 3) FROM cstr; | '2 a' |
| SELECT SUBSTR(c1, 2, 2) FROM cstr; | 'bc' |