Character set-based routing

OceanBase Database Proxy (ODP) ensures routing accuracy for different types of partitioning keys during partition calculation based on the partitioning keys of a partitioned table. ODP performs conversion between character sets supported by OceanBase Database and then performs partition calculation so as to route requests to corresponding partitions. The character set conversion process is comprised of two steps:

1. Convert the byte string of the original character set into a Unicode string.

2. Convert the Unicode string into the target character set.

ODP supports partition calculation for the following character sets:

• binary

• gbk

• gb18030_2022

• gb18030

• utf16

• utf8mb4

• latin1

• ascii

• tis620