Oracle text Import data specific steps and the occurrence of some garbled processing method

The first step is to prepare the data that will be imported first

The second step is to save the xlsx data as a TXT document

The data is ready and can now be imported into the database.

The fourth step, open the text importer, the prepared data to import into the text, the specific effects such as

Fifth step, select the table to import and the corresponding fields

The sixth step is to click Import. You can also click View Import Script

OK, the import section is over. If the import script and the Import data section appear garbled specifically as:

Mine is the first 100 data is no problem, but all the back is garbled.

The solution is to save xlsx as the time to select the text file, the encoding format without modification, do not change to UTF-8 or other.

Oracle text Import data specific steps and the occurrence of some garbled processing method