Examples of output from OCTET_LENGTH appear in the following table.
| Client Character Set | Server Character Set | string_expression | Result |
|---|---|---|---|
| EBCDIC | LATIN | abcdefgh | 8 |
| ASCII | KANJI1 | abcdefgh | 8 |
| KanjiEBCDIC | KANJI1 | AB<CDE >P | 11 |
| KanjiEBCDIC | GRAPHIC | MNOP | 8 (record mode) |
| 10 (field mode) | |||
| KanjiEUC | KANJISJIS | dA ss2 B ss3 E | 8 |
| KanjiShift-JIS | KANJISJIS | D eF | 5 |
| KanjiShift-JIS | UNICODE | ABC | 6 |