Gibberish On Sqlyog

[efrat]

Hi,

I maintain a website which is written on PHP. I update the DB using sqlyog and I have a weird problem –

When I insert Hebrew values on sqlyog – it looks ok but then on website it looks like gibberish. and vice versa – the hebrew pages on web site are being saved as gibberish on DB.

Can anyone please tell me how do I use sqlyog for inserting the real values which will be displayed on my site?

Thanks!

[peterlaursen]

Please read:

http://www.webyog.com/faq/content/34/152/e…-in-sqlyog.html

[peterlaursen]

also this link is relevant:

http://www.webyog.com/faq/content/34/148/e…y-language.html

[peterlaursen]

and finally: If you dump a small table (with SQLyog or mysqldump .. not phpMyAdmin and other PHP-based tools) and open in an editor what does it display like?

[peterlaursen]

You can try this;

Code:

SELECT HEX(somecolumn) FROM sometable WHERE somecondition

The statement should return data from a single column/row combination containing a non-latin string. Next try to enter the expected non-latin string in a HEX-editor or just a 'hexdump' program of some kind (Linux 'hexdump' command for instance).

If the SQL-statement and the HEX-editor does not return the same hexadecimal string then the data are not stored in the database as what you think.

It may (depending on what exactly the issue is) be a workaround to use SQLyog 5.32 as before 6.0 we had an option to define client character set (after full unicode support in 6.0 that is not required – client character set is now simply always utf8).

[Author]

Posts