ERR-01002

Invalid character in use

Version

All versions.

Explanation

This error is occurs when searching Korean with the LIKE clause.

Cause

A character beyond the range of the character set is also stored.

Action

The user is advised to take the following steps:

1. Download the table data using iLoader.

2. Shut down the Altibase server.

3. Change NLS_USE to MS940 from $ALTIBASE_HOME/conf/altibase.properties

4. Start the Altibase server.

5. Truncate the table that has a problem (not DELETE)

6. Upload the data downloaded from (1) using iLoader.

The user is advised to use the same character set that matches the server. For example, use MS949/UTF8 for Korean, rather than KSC5601.

Reference

N/A

Copyright ⓒ 2000~2016 Altibase Corporation. All Rights Reserved.

These documents are for informational purposes only. These information contained herein is not warranted to be error-free and is subject to change without notice. Decisions pertaining to Altibase’s product characteristics, features and development roadmap are at the sole discretion of Altibase. Altibase may own related patents, trademarks, copyright or other intellectual property rights of products and/or features discussed in this document.