What do I do if garbled characters cannot be written into OceanBase Database V3.1.2?

2023-06-29 11:11:39  Updated

Symptom

During data migration, garbled characters cannot be written into OceanBase Database V3.1.2.

Solution

  1. Log on to the sys tenant from OceanBase Client (OBClient).

    obclient -h host IP address -P port number -u username -p 'password' -D default database -Ac --prompt "OceanBase(\u@\d)> "
    
  2. Execute the following statement to set the value of _enable_static_typing_engine to false:

    ALTER SYSTEM SET _enable_static_typing_engine = false;
    

Contact Us