SQLinForm SQL FormatterCommunity Discussion Forum
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
@admin Thanks, let me know if I could test more. No more idea's from side.
The issue with the German Umlaute has been solved with the new Release
