load sql file not handling UT8 characters correctly but works in the query tab

[expired user #6977]'s profile image [expired user #6977] posted 7 years ago in General Permalink

With HeidiSQL 9.5.0.5125 running on windows 10, maria db 10.1.16

When loading the database from a UT8 file using file -> load sql file and the file contains Thai characters they become corrupted. Otherwise there is no problem with the load.

The same load sql pasted into the query tab works no problems.

Choosing UT8 from the load options makes no difference.

Previous versions of HeidiSQL didn't have this problem.

Anyone else having ut8 problems with the load sql file function?

ansgar's profile image ansgar posted 7 years ago Permalink

Did you select "UTF-8" from the encoding options in the open file dialog? The auto-detection is error prone, as stated with "may fail".

[expired user #6977]'s profile image [expired user #6977] posted 7 years ago Permalink

yes, didn't make any difference

It looks this when loaded through the query tab ถนนรามคำแหง แขวงหัวหมาก เขตบางกะปิ and like this ??????????????????????? when loaded from file->load sql file with ut8 selected or not selected

[expired user #6977]'s profile image [expired user #6977] posted 7 years ago Permalink

Problem solved, I installed HeidiSQL version 9.1.0.4867 and the load SQL worked perfectly. The Thai characters are correct. I guess I will stick with this version.

Please login to leave a reply, or register at first.