Hi,
I have an old database that is in windows-1255.
And i cannot view the data of the tables, all i can see is a lot of symbols...
How can i change the view encoding of the program?
encoding view problem - hebrew
HeidiSQL uses utf8 for the communication to the server. That does not affect how your data is displayed. If it's shown with broken characters, I guess the data itself is corrupt. You could create a dump using mysqldump or some other client and compare with what HeidiSQL shows you.
Need help with mysqldump? Feel free to ask here.
Need help with mysqldump? Feel free to ask here.
Hi, the data is not corrupt.
I can see the data in the website.
The problem is that the data is not in UTF8.
So you cannot use UTF-8 to display a data that is not in UTF-8.
I just re-instal the program, and this problem is just in the new instalation. Before that was ok....
I can see the data in the website.
The problem is that the data is not in UTF8.
So you cannot use UTF-8 to display a data that is not in UTF-8.
I just re-instal the program, and this problem is just in the new instalation. Before that was ok....
So you cannot use UTF-8 to display a data that is not in UTF-8.
That's not true. If MySQL is told to use utf8 in the client-server communication, the data can be in any encoding. MySQL converts the characters from the table charset to the character_set_client in real-time when the client retrieves a query result.
If your data is displayed ok on your website and not so in HeidiSQL, there must be something broken, somewhere, but not necessarily in HeidiSQL.
* How does your website retrieve data? Do you fire some "SET NAMES xyzcharset" in a header file?
* Which MySQL server version are we talking about?
* How does a different client show your characters - for example MySQL workbench or something?
Maybe that is right for the newer Mysql versions.
My database is MYSQL 4.1, something really old, and for now i cannot update the mysql version.
But until 3 days ago, everything was ok, than i formatted my computer and re-install HeidiSQL, just after that the problem started.
I really think that is some configuration of the software...
I really sure that is not broken data, the some data was ok 3 days ago, and the website still is working fine.
Maybe u can send me a old version of HeidiSQL?
TKS for the help!
My database is MYSQL 4.1, something really old, and for now i cannot update the mysql version.
But until 3 days ago, everything was ok, than i formatted my computer and re-install HeidiSQL, just after that the problem started.
I really think that is some configuration of the software...
I really sure that is not broken data, the some data was ok 3 days ago, and the website still is working fine.
Maybe u can send me a old version of HeidiSQL?
TKS for the help!
Please login to leave a reply, or register at first.