Help Center/ GaussDB(DWS)/ Troubleshooting/ Data Import and Export/ Data to Be Imported Contains Chinese When the DataArts Studio Service Is Used to Create a GaussDB(DWS) Foreign Table
Updated on 2024-03-08 GMT+08:00
View PDF

Data to Be Imported Contains Chinese When the DataArts Studio Service Is Used to Create a GaussDB(DWS) Foreign Table

Symptom

When a user uses the DataArts Studio service to create a GaussDB(DWS) foreign table and specify UTF-8 as the OBS file encoding format in the statement for creating the foreign table. However, an error occurs when the user imports data.

Possible Causes

The source file stored on OBS contains non-UTF-8 data.

Handling Procedure

Check whether the source file contains non-UTF-8 data, for example, Chinese characters. If the source file contains non-UTF-8 data, convert the source file into the UTF-8 format, upload the converted file to OBS again, and import the data.

Parent topic: Data Import and Export