Description | Data types with National Language Support (NLS) allow storage of multiple language character sets, often by using UTF-16. For example, SQL-Server has NTEXT and Oracle has NVARCHAR2 data types. Add a new feature to support these fields for synchronization. Currently, the SYM_DATA table is using CLOB data types to capture data, which probably do not allow for NLS. One approach is to encode the NLS data in base64 or hex to capture it. Another approach is an install option to convert SYM_DATA to use NLS data types. Using multi-byte character sets when it's not needed probably adds overhead. |
---|