The following table shows examples for KanjiShift-JIS client character set, where ctable1 is the table defined in Example: Effect of the Order of SELECT Statements on Data Type.
If c1 contains "mnABC X":
- SELECT SUBSTR(c1, 6, 1) FROM ctable1;
returns X
- SELECT SUBSTR(c1,4) FROM ctable1;
returns BC X