search

dbeaver / dbeaver

Free universal database tool and SQL client
https://dbeaver.io
Apache License 2.0
40.36k stars 3.48k forks source link

CSV export converts characters like apostrophe and hyphan #8391

Closed DDEversana closed 4 years ago

DDEversana commented 4 years ago

System information:

Connection specification:

Describe your question:

When I export data from MariaDB table to csv using DBeaver csv export feature some characters are getting messed up. Please find example below:

E.g. See how apostrophe is converted Database value: "Alzheimer’s Disease" CSV export: "Alzheimer’s Disease" Encoding settings: image

I tried using ISO-8859-1 encoding but then it replaces apostrophe by question mark. This issue is with some other characters also but I hope the root cause could be same. Could you please let me know what is the workaround to avoid this character conversion?

kseniiaguzeeva commented 4 years ago

I cannot reproduce. Please tell which locale do you use? You can see it here: Properties>Editors>Data Editor>Data Formats rW4btkDA3F

DDEversana commented 4 years ago

Here you go: [cid:image001.png@01D60E97.C70F0830] image

From: Kseniia notifications@github.com Sent: 09 April 2020 17:44 To: dbeaver/dbeaver dbeaver@noreply.github.com Cc: Dnyaneshwar Daspute Dnyaneshwar.Daspute@Eversana.com; Author author@noreply.github.com Subject: Re: [dbeaver/dbeaver] CSV export converts characters like apostrophe and hyphan (#8391)

I cannot reproduce. Please tell which locale do you use? You can see it here: Properties>Editors>Data Editor>Data Formats [rW4btkDA3F]https://user-images.githubusercontent.com/51405061/78893800-9c949680-7a74-11ea-9ce5-1a0466446818.png

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/dbeaver/dbeaver/issues/8391#issuecomment-611494985, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ANOBQB62FAP5I46GO56SQ5TRLW3X5ANCNFSM4MEQ3KJQ. IMPORTANT NOTICE: The information contained in this communication is for the sole use of the intended recipient(s) and may contain confidential information. If you are not an intended recipient , you are hereby notified that any use, disclosure, copying or distribution of this communication or its contents is strictly prohibited. If you have received this communication in error, please contact the sender immediately and delete the original message and any copies from your computer system.

kseniiaguzeeva commented 4 years ago

Could you please attach the picture to the ticket?

DDEversana commented 4 years ago

image

kseniiaguzeeva commented 4 years ago

Is it possible to try our 7.0.2 version https://dbeaver.io/download/? "Alzheimer’s Disease" is exported correctly to CSV,

DDEversana commented 4 years ago

I did that. Now I am on Version 7.0.2.202004051509 But issue persist.

uslss commented 4 years ago

@DDEversana what encoding is used in application where expoted csv i opened? issue is reproducible for me in case I use UTF-8 in export settings and ANSI in Notepad++ image in case of using UTF-8 it looks ok image