Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Error when using latin1_general_ci collation in HeidiSQL 12.1

Rulo's profile image Rulo posted 1 month ago in General Permalink

Hi!! I've been using HeidiSQL for a couple of months now and recently had to reinstall, updating blindly to the last version uploaded not even a month ago. With this new version I've noticed I can't see my accent marks (I use it in Spanish so accents are very common) and what is even more disturbing, I can't write any new accents. Pasting a text with some of them will turn them into question marks '?' and typing them by hand will lock me up in the cell, sending an error like '0 rows updated, expected 1' or something like that. I've come back to 12.0 and everything works right again.

ansgar's profile image ansgar posted 1 month ago Permalink

In the log panel you can verify the connection's character set:

Description

HeidiSQL is not really designed for running in non-Unicode mode.

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




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.