Urgently Need Version 5.20

[acpan]

Hi,

I have upgraded to 6.04 and it turned out that my utf8 characters (chinese) can no longer be recognisable.

I tried various settings, Windows locale, change utf8 unicode on table but still can't resolve. I read all the forums

on utf8 table settings and tried but does not help.

On the other machine, server 2, with the same Windows setings, it does not have this problem, i.e. chinese characters

are ok with 5.20. When i use the server 2 SQlyog to access the server 1, the characters are ok. It could be

a combination of the environment and software that caused the problem.

I read the forum, there is no older version available for download, but I need to downgrade to version 5.20 to

ascertain urgently. Appreciate if i can get a copy from anyone.

Thanks

acpan.

[acpan]

Just to add, it's community version 5.20.

Thanks

acpan

[peterlaursen]

SQLyog community 5.32 can be downloaded from

http://www.webyog.com/downloads/SQLyog532.exe

.. also Windows 98 users will need to use this one!

Regarding the characer set issue please read the FAQ:

http://www.webyog.com/faq/34_148_en.html

and my BLOG:

http://www.webyog.com/blogs/peterlaursen/i…hp?showentry=83

I would say that I am almost sure that the problem is that your data are stored incorrectly.  Probably you are using a non-chinese on non-unicode character set where 'encoded strings' but NOT REAL CHINESE characters are stored!

Pleas create a very small table, export, xip and attatch it here.  

We would like to know the exact reasong for this.

(and I think we can provide a solution too – but first I need to see some data!)

to create a small table you may

“CREATE TABLE SELECT ….. FROM  LIMIT 10;”

for instance!

Please also tell the (exact) MySQL version!

[acpan]

Hi,

Thank you for the previous version. It solved the problem instantly.

MYSQL Version:

5.0.26 Community

—

Windows: 2003 Server Std

Regional Settings:-

Standards & Formats: US

Location: US

Default Input Language: US

Default Input Keyboard: US

Advance: Chinese (PRC)

—

Program use to enter Chinese Text: NANJI Star Word 5.20.61068

Program use to display Chinese Text: NANJI Star Viewer 1.90.60318

-Using Chinese UTF8 Simplified to display Chinese.

—

My Stored Procedure contains chinese character and when called,

will insert chinese characters into 1 of the columes in a table

The column is defined as 'unicode utf-8 ci' using SQlyog Alter Table.

—

[peterlaursen]

I still would like to see a small table dump!

[acpan]

Attached is the export of the small table for your info.

[acpan]

For your info, last row (with the highest ID) was inserted after i used the previous SQLyog 5.2X and the rest

were using 6.04.

Thanks …

acpan

[acpan]

Sorry, mistake, the first row in the attached files was done with the older version and was displayed ok.

[peterlaursen]

1) I request that you install version 6.x again (just install to another folder) and export wwith this one.  I need a utf8 encoded file to check if there are any chinese characters in one of the rows! SQLyog create dumps as utf8 encoded files.

2) I also need a COMPLETE DUMP with all charset settings for the table (and columns if any are difined).  Rightclick table …export .. backup table as SQL dump.  This will give all information!

3) Also please execute

” SHOW VARIABLES LIKE '%character%' “

(and be sure that the database with that table is the USED database when doing!)

Sorry for the trouble, but I really want to understand your issue

[acpan]

Hi, no problem, thanks for your help and looking into this.

> 1) I request that you install version 6.x again (just install to another folder) and export wwith this one.  I need a utf8 encoded file to check if > there are any chinese characters in one of the rows! SQLyog create dumps as utf8 encoded files.

> 2) I also need a COMPLETE DUMP with all charset settings for the table (and columns if any are difined).  Rightclick table …export .. backup > table as SQL dump.  This will give all information!

Pls see attached.

> 3) Also please execute

> ” SHOW VARIABLES LIKE '%character%' ” (and be sure that the database with that table is the USED database when doing!)

“Variable_name” “Value”

“character_set_client” “utf8”

“character_set_connection” “utf8”

“character_set_database” “latin1”

“character_set_filesystem” “binary”

“character_set_results” “utf8”

“character_set_server” “latin1”

“character_set_system” “utf8”

“character_sets_dir” “C:\Program Files\MySQL\MySQL Server 5.0\share\charsets\”

[peterlaursen]

thank you!

This

“character_set_database” “latin1”

— clearly tells that data are NOT stored on the server as chinese characters.  To do this you will either need to use a chinese character set or a unicode character set!

I'll study your dumps in detail tomorrow.

I wrote a new FAQ on this today, that you may read:

http://www.webyog.com/faq/34_152_en.html

[Author]

Posts