When I Export To Html The

[yhzwql]

i am from china, i try 5.14, when i export to html it is wrong(2.png),but i use select * from mybd.table and export the result to html it looks right (1.png), and my database properties is 4.png, and in sqlyog 5.14 looks good

and i export to cxv looks right (5.png)

export to xml looks wrong (6.png)

when i use select * from …. then export to xml,html is right

[peterlaursen]

There are several issues here. And we will need your help to sort it out…

1) “i try 5.14, when i export to html it is wrong(2.png),but i use select * from mybd.table and export the result to html it looks right (1.png)”

Try opening the files in Notepad!

Export table from the Object Browser includes a charset META-tag like

..export table from RESULT pane does not have a 'charset=' and then the browser will have to decide … and it seems to decide right!

2) Actually it surprises me that you are able to work with chinese string data so well in the GUI.

What MySQL charset do you use for string columns with chinese data?

(it surprises me that you use latin1 as server default!)

Also what LOCALE is your Windows? and your OFFICE software?

And is this 'simplified chinese' or 'traditional chinese' ?

3) CSV: I think it is Excel that is 'smart' enought to realize that this is chinese. Especially if you use a chinese Windows localization and a Chinese Office Suite. How does the file display if you open it in Notepad?

4) XML has the same issue as HTML. When exporting from Object Browser there is a header like

but there is not when exporting from RESULT-pane

I believe it is a bug (something that was forgotten) when it is NOT there! But to be able to export multibyte characters as UTF8, I think SQLyog must be compiled with Unicode. You Chinese LOCALE settings 'saves it' when no charset is specified, I belive.

We have a general FAQ here: http://webyog.com/faq/34_102_en.html

.. but that may not be fully correct if you are using Chinese software.

I really do not know how Chinese is implemented is Windows for non-Unicode programs.

You are welcome to comment on it!

Do you still have the FILES (HTML, CSV and XML files). If so please attach them too!

Also a dump of the table (or any small table with those characters) would be nice (though I doubt that my Danish Windows LOCALE support displaying it in SQLyog. Though I should be able to view the HTML at least!)

[yhzwql]

peterlaursen wrote on Jun 22 2006, 02:05 AM:

There are several issues here. And we will need your help to sort it out…

1) “i try 5.14, when i export to html it is wrong(2.png),but i use select * from mybd.table and export the result to html it looks right (1.png)”

Try opening the files in Notepad!

Export table from the Object Browser includes a charset META-tag like

..export table from RESULT pane does not have a 'charset=' and then the browser will have to decide … and it seems to decide right!

2) Actually it surprises me that you are able to work with chinese string data so well in the GUI.

What MySQL charset do you use for string columns with chinese data?

(it surprises me that you use latin1 as server default!)

Also what LOCALE is your Windows? and your OFFICE software?

And is this 'simplified chinese' or 'traditional chinese' ?

3) CSV: I think it is Excel that is 'smart' enought to realize that this is chinese. Especially if you use a chinese Windows localization and a Chinese Office Suite. How does the file display if you open it in Notepad?

4) XML has the same issue as HTML. When exporting from Object Browser there is a header like

but there is not when exporting from RESULT-pane

I believe it is a bug (something that was forgotten) when it is NOT there! But to be able to export multibyte characters as UTF8, I think SQLyog must be compiled with Unicode. You Chinese LOCALE settings 'saves it' when no charset is specified, I belive.

We have a general FAQ here: http://webyog.com/faq/34_102_en.html

.. but that may not be fully correct if you are using Chinese software.

I really do not know how Chinese is implemented is Windows for non-Unicode programs.

You are welcome to comment on it!

Do you still have the FILES (HTML, CSV and XML files). If so please attach them too!

Also a dump of the table (or any small table with those characters) would be nice (though I doubt that my Danish Windows LOCALE support displaying it in SQLyog. Though I should be able to view the HTML at least!)

ok, i get the table export to htmlxmlcsv file and resurt to htmlxmlcsv file to u

only table export to htmlxml is wrong, others are looks right

and i open table export csv look right,u can see 8.png

my os is windows xp sp2, office is 2002, all are chinese simplified chinese

btw, our country www page i see is gbk or gb2312 code ,but i use this code in sqlyog, all looks wrong in sqlyog

why?? i can't attach files……

[peterlaursen]

I you have problems attaching files the try zip them.

I do not understand you very well. But once I get the files I think I will be able to!

[Author]

Posts