TablePlus-Windows icon indicating copy to clipboard operation
TablePlus-Windows copied to clipboard

Published 20 hours ago • verified publisher icon TablePlus

We need utf8

Open oskariiii opened this issue 4 years ago • 3 comments

  1. Which driver are you using and version of it (Ex: PostgreSQL 10.0): 10.2.10-MariaDB-log
  2. Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81): version 4.0.0(168)
  3. The steps to reproduce this issue: cant export data include Chinese words. Can we try to use utf8mb4 OR utf8 to export csv file? That's better if we can export more file types of excel

oskariiii avatar May 28 '21 03:05 oskariiii

Hi @oskariiii are you sure that the CSV is not utf8? If you could not read the CSV after exporting, please check the reader encoding first because the CSV file is utf8 encoding.

huyphams avatar May 28 '21 03:05 huyphams

@huyphams I have the same isse. When I export query results that contain greek characters to csv they come out as gibberish when I open the file in MS Excel. I don't recall this ever working correctly.

mtaki14 avatar Nov 18 '21 08:11 mtaki14

I should add that this works correctly in HeidiSql with encoding set to UTF8

mtaki14 avatar Nov 18 '21 08:11 mtaki14