Connection charset for MySQL/MariaDB

Max_Cohen's profile image Max_Cohen posted 2 years ago in General Permalink

Hello, Ansgar Becker and big thank you for your app Heidi SQL. It is a greate app for MS Windows. Do you have a plan to do for Linux systems without Wine?

Sorry for my english.

My suggest to this app - to add a connection charset to DB systems MySQL and MariaDB. In PHP language we can set charset by this command

mysqli_set_charset($connection, 'utf8');

Can you please add this option to connection panel, when setting up this moment?

1 attachment(s):
  • HeidiSQL
ansgar's profile image ansgar posted 2 years ago Permalink

I would be happy if I could compile HeidiSQL for Linux, believe me. But unfortunately this would require an entire rewrite of the application.

Regarding your charset question - this is already done in HeidiSQL. When you connect to MySQL or MariaDB, one of the first things Heidi does is to call mysql_set_character_set(handle, 'utf8').

This is just hardcoded, and there is no option for this in the session settings. If you need a different charset, you can put a SET NAMES xyz; in an .sql file and set it as startup script.

Please login to leave a reply, or register at first.