Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

WIN1250 Code Page not supported in Data View and CSV Export #1864

Open
aluszczewski opened this issue Oct 22, 2023 · 2 comments
Open

WIN1250 Code Page not supported in Data View and CSV Export #1864

aluszczewski opened this issue Oct 22, 2023 · 2 comments

Comments

@aluszczewski
Copy link

Preconditions
PostgreSQL database with code page WIN1250.

  • HeidiSQL version: 12.5.0.6677 32 bit
  • Database type and version: PostgreSQL 13.1
  • OS: Windows 10

Describe the bug
Tables with national characters encoded in WIN1250 are displayed incorrectly. When exporting to a CSV file, they are also saved incorrectly.

HeidiSQL

@ansgarbecker
Copy link
Collaborator

Related: #22
Do you have a suggestion how to fix this? I'm not that deep into PostgreSQL.

@aluszczewski
Copy link
Author

aluszczewski commented Nov 20, 2023

I think you should convert the strings received form PostgreSQL in code page 1250 to UTF-8 before displaying them in the grid.
If you are using Delphi look at: https://riptutorial.com/delphi/example/19512/encodings.

Just remember to convert the strings from the UPDATE and INSERT statements to the correct code page.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants