[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\”

[acpan]

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

[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]

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

[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.

—

[acpan]

Just to add, it's community version 5.20.

Thanks

acpan

[Author]

Posts