CODEWITHSUNDEEP
mysqlcharacter-encodingworkbench
user3362705
user3362705

Reputation: 23

MySQL Workbench. data shows in gibberish instead of hebrew

When connecting to my server from my laptop and looking at a certain table in the DB. All the data is in gibberish instead of Hebrew.

But when I go to the website that is connected to the DB, everything is fine and I can see the data in Hebrew.

So the only problem I have is with MySQL Workbench.

I need help fast!

Thanks!

Upvotes: 1

Views: 1236

Answers (1)

Volkan Ulukut
Volkan Ulukut

Reputation: 4218

In mysql every client has connection-related character set and collation system variables. Since MySQL workbench is essentially a client that connects to the database, it also has a connection related character set and collation which happens to fail to display hebrew characters. You can change the connection-related character set anytime by running this query:

SET NAMES 'charset_name' COLLATE 'collation_name'

which your website is probably doing to connect with correct encoding. you can find additional information here

Upvotes: 1

Related Questions