Intermediate With the rapid development and broad deployment of internet technologies, multilingual support in software products is bringing increasingly high attention to companies who intend to expand and grow their global businesses. Oracle is also seeing an increase in the amount of requests for multilingual supports in the recent years.
Multilingual collation is a crucial part of multilingual support.
It allows customers and employees to more rapidly and accurately search for information and products in any language. This paper covers multilingual collation features and new Asian sort support in Oracle 9i. SQL string normalization APIs is also covered to show how these functionalites can be used at the SQL level. Finally, the paper discusses the flexibility and extensibility of this multilingual collation support model which can be easily adopted to support future CJK Extension B plan with surrogate pairs. Performance and memory consumption are taken into considerations in this model with its ability to support up to more than one million characters in a single sort.