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

Published 20 hours ago • verified publisher icon TablePlus

UTF-8 support when exporting csv

Open djmcelle opened this issue 4 years ago • 2 comments

  1. Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81): 160

  2. The steps to reproduce this issue: Whilst the query result seems to use UTF-8, the csv export seems not to support UTF-8 charset. I couldn't find a way to set the desired charset. Query result: image Export result: image

djmcelle avatar Apr 17 '21 14:04 djmcelle

Hi @djmcelle I think the CSV is UTF-8 but the viewer is using different encoding, could you double check it?

huyphams avatar Apr 17 '21 15:04 huyphams

Hi @huyphams Yes, you are right. It is the inability of MS Excel to automatically interpret the coding of the file right. Nevertheless, as a "simple" conversion to UTF-8-BOM with Notepadd++ will let Excel open it by using UTF-8 correctly I am wondering if this could be implemented as another export option like "Delimiter", "Quote" etc. I know, it should be Microsoft's task to enable Excel of handling the charset correctly, not yours. But maybe it is easy for your to implement. If not, just leave it as it is.

djmcelle avatar Apr 17 '21 19:04 djmcelle