Unicode UTF-8

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

Hello,

Does anyone know how to handle UTF-8 well in HeidiSQL? I've got 271 interlanguage files from Wikipedia, possibly with every script there is in the world. I've used the GUI to import the files, but I receive error messages for some of the files. I tried to use the command prompt, but that's even worse. It doesn't import accurately many of the letters. Any help is MUCH appreciated.

Tom

archfrog's profile image archfrog posted 6 years ago Permalink

Did you try to specify the encoding in the File/Run SQL File dialogue? There's an Encoding field at the bottom.

I had some issues with Unicode a while back and solved it with this trick: Use File/Load SQL File and then manually run the loaded SQL afterwards. I could not get it to work with File/Run SQL File, but the trick did work for me.

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