JIS_COLL collation provides a character set independent ordering based on the Japanese Industrial Standards.
JIS_COLL Collation Sequence
JIS_COLL collation orders data as follows:
- Characters and symbols from the JIS X 0201 standard (in JIS X 0201 order).
- Ideographs, characters, and symbols from the JIS X 0208 standard (in JIS X 0208 order).
- Ideographs, characters, and symbols from the JIS X 0212 standard (in JIS X 0212 order).
- IBM Kanji ideographs not present in JIS X 0201, JIS X 0208, and JIS X 0212 (in KanjiEBCDIC order).
- Site-defined ideographs (in Unicode order).
- The remaining characters in Unicode (in Unicode order).
Collation of the KANJISJIS, GRAPHIC, and LATIN character sets is as if the data were first converted to Unicode and then the appropriate JIS_COLL ordering were applied.
Making JIS_COLL the Default Collation Sequence
You can specify JIS_COLL as the default user collation with the CREATE or MODIFY USER statement, or use SET SESSION COLLATION JIS_COLL to override any user defaults.
JIS_COLL Collation Related Information
For details on collating conventions, see: