using on japanese system

[cougar]

Hello.

I've used SQLyog 4.0 on Japanese WinXP pro and home.

It's works very fine.

I can see Japanese characters correctly in everywhere.

But only on 'Alter Table' window, japanese characters will be collapse.

In an active cell, I mean edit mode cell, I can see them correctly and I can edit them.

If you have time, could you check the problem?

thanks.

[Ritesh]

Quote:

But only on 'Alter Table' window, japanese characters will be collapse.

In an active cell, I mean edit mode cell, I can see them correctly and I can edit them.

I am not sure if I understood your problem.

Can you cut-n-paste the result of the following query?

Code:

show variables like '%char%'

[cougar]

Oh, I think I was not clearly, sorry….

the collapse meaning is only for the appearence, the data in DB isn't colleapsed.

And I can edit the data which looks like broken correctly with SQLyog.

because if I move in the cell which has JP characters, the characters will be shown correctly.

The probrem is only on a screen.

anyway here is the result of your code.

Quote:

Can you cut-n-paste the result of the following query?

CODE

show variables like '%char%'

Code:

Variable_name          Value                                                                                                                                                                                                            
———————  —————————————————————————————————————————————————————————————————————–
character_set          sjis                                                                                                                                                                                                            
character_sets         latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5
convert_character_set

[Ritesh]

Which version of MySQL are you using?

Can you send me your table structure and sample data? We will be releasing v4.0.3 soon and we would like to fix this issue in v4.0.3.

[cougar]

Hello, Ritesh.

I'm using SQLyog 4.02.

and here is table structure and sample data.

[Ritesh]

Which version of MySQL?

[Ritesh]

Thanks for your help.

Is it possible to change the table type to MyISAM and attach me the corresponding .frm, .myi and .myd file for the table? You can get them in the {mysql data directory/database/} folder.

[Ritesh]

The while you sent was in ANSI and not in utf8 mode. I am unable to import the data correctly.

[Author]

Posts