DBeaver file encoding (cp1250 - Windows-1250) - change default encoding?

encoding utf-8 dbeaver cp1250
Tom picture Tom · Jun 28, 2017 · Viewed 20.8k times · Source

I have a problem setting encoding in DBeaver, specifically SQL file encoding (not db encoding!) to cp1250 (Windows-1250)

No problem to set such encoding for new files/scripts - right click on Scripts folder (or the whole project folder, from which scripts are inheriting): Properties / Resources / Text file encoding.

The problem is opening existing scripts from text files (SQL Editor / Load script). These are loaded in UTF-8, which is shown as deafult encoding. No easy way to change the encoding after opening...

Does anyone know how to change default encoding for DBeaver (or for opened files)? I cannot find the answer anywhere...

Answer

Koby picture Koby · Mar 11, 2018

see capture file below for a detailed explanation. Hope this helps (if still relevant)...

Visual Explanation

Related questions

Working with UTF-8 encoding in Python source

Consider: $ cat bla.py u = unicode('d…') s = u.encode('utf-8') print s $ python bla.py File "bla.py", line 1 SyntaxError: Non-ASCII character '\xe2' in file bla.py on line 1, but no encoding declared; see http://…

Read More
Excel to CSV with UTF8 encoding

I have an Excel file that has some Spanish characters (tildes, etc.) that I need to convert to a CSV file to use as an import file. However, when I do Save As CSV it mangles the "special" Spanish characters …

Read More
HTML encoding issues - "Â" character showing up instead of " "

I've got a legacy app just starting to misbehave, for whatever reason I'm not sure. It generates a bunch of HTML that gets turned into PDF reports by ActivePDF. The process works like this: Pull an HTML template from a …

Read More