Tabel Data Tab Input In Utf-8, Is Possible?

[magnastik]

Hi!

I'm using sqlyog and i'm working in php with ajax.

My files are set with utf-8 charset.

In sqlyog i created my db, tables and fields with settings to UTF-8.

So.. the problem is… if i imsert data from php form the characters will be fine in DB, but if insert them through the TABLE DATA tab in sqlyog the chars will be wrong coded..

How can i solve this? Because i've a very large amount of data to insert, and i need to insert some data for testing proposes.

Ahhh.. just one more thing….

The data i insert in SQLyog Tabel Data tab i can see it fine in SQLyog but wrong in browser.

IF i insert data from php form in browser, i can see it fine in browser but wrong in TABLE DATA tab… like this… “descrição” when the right word should be “descrição”

Thanks,

Magnastik

[peterlaursen]

Basically I think that SQLyog inserts correctly and PHP does not!

SQLyog shows data as they are stored in the database!

refer to those two discussions:

http://www.webyog.com/forums//index.php?showtopic=3284

http://www.webyog.com/forums//index.php?showtopic=3204

1)

Please dump a small table with SQLyog 'export', zip and attach here!

Once opened in NOTEPAD it will be easy to see if data are really stored in the database as utf8!

2)

Please also answer:

MySQL version?

SQLyog version?

[magnastik]

peterlaursen wrote on Jun 13 2007, 04:03 PM:

Basically I think that SQLyog inserts correctly and PHP does not!

SQLyog shows data as they are stored in the database!

refer to those two discussions:

http://www.webyog.com/forums//index.php?showtopic=3284

http://www.webyog.com/forums//index.php?showtopic=3204

1)

Please dump a small table with SQLyog 'export', zip and attach here!

Once opened in NOTEPAD it will be easy to see if data are really stored in the database as utf8!

2)

Please also answer:

MySQL version? 5.0.33

SQLyog version? 5.19

Ok.. just attached the sql file.

Thanks,

[peterlaursen]

your dump is not so easy to use as there are no 'create table' statement.

But basically please try 6.02/6.03 beta .. we do not support 5.19 any more and never claimed it was fully unicode compliat!  6.x is!

[Author]

Posts