SQLinForm SQL Formatter
Hello,
I am using SQLinForm version 6.22.10.15
and DBeaver 22.2.0
This is what I am doing:
- Copy and paste a sql statement from Pentaho DI into DBeaver, should now be in CP1252.
- Format the SQL using SQLinForm
Result is, all german Umlaute like 'ä', 'ü', 'ö' are replaced by a special character.
The Codepage of the file seems to be changed, because I cannot save it anymore in DBeaver.
See the pictures I have attached.
What can I do?
Best regards
Dieter
Hi Dieter,
thanks for your feedback. The external formatter is not converting any codepages. It assumes the SQL statement in UTF-8
Would it be possible to change the encoding of the workspace into UTF-8 as shown in this thread https://stackoverflow.com/questions/44796919/dbeaver-file-encoding-cp1250-windows-1250-change-default-encoding
Regards
Guido
Hello Guido,
I changed the setting to UTF8 again, which i have had already.
But the behavior is unchanged. I am copying a CP1252 file, see the Umlaute 'ä'.... format it again and they are changed.
There is no way to avoid that.
regards
Dieter
Add on: The only change, when I am using UTF8 setting is, that I can save the files, but with the wrong character.
Hi Dieter, I could not find any hint in the DBeaver documentation how to handle different code pages with the External Formatter.
Will do some more investigations
Regards
Guido
The issue with the German Umlaute has been solved with the new Release
