Bug: 4.05 Copy result to clipboard

[jayshi]

When using “Copy all rows to clipboard” for query result, the last letter/number is always missing. It acts the same when using “Copy selected row(s) to clipboard”, but “export results” works right.

I am using free version 4.05 and Mysql server 4.1.11 for windows.

[peterlaursen]

I have tested with MySQL for windows ver. 4.1.11 and 5.0.4 and Sqlyog 4.05 and 4.06 beta4 and I can't reproduce the error!

See for yourself: Here are sample data form my music database (first 20 records – columns artist, albumtitle & genre). And as you see genres “Jazz”, “Blues” etc. are not abbreviated to “Jaz”, “Blue” etc.

John McLaughlin|The Heart of Things|Jazz||Danu|The Road Less Traveled|Folk||Bud Powell|A Portrait of Thelonious|Jazz||Mississippi John Hurt|Revisited|Blues||Andy Statman Klezmer Orchestra|Klezmer Suite|Klezmer||Herbie Mann|Memphis Underground|Jazz/Soul/Funk||Kek Lang|Chants Room|Folk/Trad.||Astor Piazzolla|Concierto de Nascar|Tango||Grady Tate|All Love/Grady Tate Sings|Jazz||The Mills Brothers|Chronological, Vol. 3|Jazz||Cubanismo|Reencarnacion|Latin||Torben Westergård|Brazilian Heart|Latin||Duke Ellington|The Private Collection vol. 7|Jazz||Kassé-Mady Diabaté|Kassi Kasse|Afrikansk/Vest||Arne Forchhammer Trio|Assimilation|Jazz||Vieja Trova Santiaguera|Hotel Asturias|Latin||Sergio Mendes|Brasileiro|Latin||Fernando Tarres|The Outsider|Jazz/Fusion||Jan Johansson|Folkvisor|Jazz||Sonny Boy Williamson|The Bluebird Blues|Blues

Here I've chosen fields terminated by “|” and lines terminated by “||” (for visual apperance). But it also does not matter what termination and escape characters I use. I also tested with some other data and still can't reproduce your problem.

It could however be some sort of charset problem. There are unfixed issues with sqlyog and charsets control introduced with Mysql 4.1.1 and later (should be fixed in a couple of months I've been told!)

What is your charset setting (see create statement for the table at the bottom of Objects pane!) ?

since I'm European my charset is “latin1”. Could be a problem with double-byte charsets (Chinese, Korean etc)…

Or you don't happen use only the first “halfpart” of a “two-stroke character” such as “~” (maybe this is just a silly idea!).

[peterlaursen]

I tested once more with a copy of the DB where charset was set as utf8.

Still can't reproduce the error.

But although charset is now uft8, characters in the base are still latin-based characters, so that's not necessisarily all there is to it …

[peterlaursen]

Yes I can reproduce now …

It seems that you will have to enter at least 2 characteres in “line terminated by” -field.

It you only enter 1 character you will miss one character at the end

and if don't enter any actually you will miss 2 characters …

I misunderstood you from the start – I thougt you meant a missing character in each row but thats not it. I now see that it is only at the very end

My data again

Lines terminated with $$:

John McLaughlin|The Heart of Things|Jazz$$Danu|The Road Less Traveled|Folk$$Bud Powell|A Portrait of Thelonious|Jazz$$Mississippi John Hurt|Revisited|Blues$$Andy Statman Klezmer Orchestra|Klezmer Suite|Klezmer$$Herbie Mann|Memphis Underground|Jazz/Soul/Funk$$Kek Lang|Chants Room|Folk/Trad.$$Astor Piazzolla|Concierto de Nascar|Tango$$Grady Tate|All Love/Grady Tate Sings|Jazz$$The Mills Brothers|Chronological, Vol. 3|Jazz$$Cubanismo|Reencarnacion|Latin$$Torben Westergård|Brazilian Heart|Latin$$Duke Ellington|The Private Collection vol. 7|Jazz$$Kassé-Mady Diabaté|Kassi Kasse|Afrikansk/Vest$$Arne Forchhammer Trio|Assimilation|Jazz$$Vieja Trova Santiaguera|Hotel Asturias|Latin$$Sergio Mendes|Brasileiro|Latin$$Fernando Tarres|The Outsider|Jazz/Fusion$$Jan Johansson|Folkvisor|Jazz$$Sonny Boy Williamson|The Bluebird Blues|Blues

Lines terminated with $:

John McLaughlin|The Heart of Things|Jazz$Danu|The Road Less Traveled|Folk$Bud Powell|A Portrait of Thelonious|Jazz$Mississippi John Hurt|Revisited|Blues$Andy Statman Klezmer Orchestra|Klezmer Suite|Klezmer$Herbie Mann|Memphis Underground|Jazz/Soul/Funk$Kek Lang|Chants Room|Folk/Trad.$Astor Piazzolla|Concierto de Nascar|Tango$Grady Tate|All Love/Grady Tate Sings|Jazz$The Mills Brothers|Chronological, Vol. 3|Jazz$Cubanismo|Reencarnacion|Latin$Torben Westergård|Brazilian Heart|Latin$Duke Ellington|The Private Collection vol. 7|Jazz$Kassé-Mady Diabaté|Kassi Kasse|Afrikansk/Vest$Arne Forchhammer Trio|Assimilation|Jazz$Vieja Trova Santiaguera|Hotel Asturias|Latin$Sergio Mendes|Brasileiro|Latin$Fernando Tarres|The Outsider|Jazz/Fusion$Jan Johansson|Folkvisor|Jazz$Sonny Boy Williamson|The Bluebird Blues|Blue

Lines terminated with

John McLaughlin|The Heart of Things|JazzDanu|The Road Less Traveled|FolkBud Powell|A Portrait of Thelonious|JazzMississippi John Hurt|Revisited|BluesAndy Statman Klezmer Orchestra|Klezmer Suite|KlezmerHerbie Mann|Memphis Underground|Jazz/Soul/FunkKek Lang|Chants Room|Folk/Trad.Astor Piazzolla|Concierto de Nascar|TangoGrady Tate|All Love/Grady Tate Sings|JazzThe Mills Brothers|Chronological, Vol. 3|JazzCubanismo|Reencarnacion|LatinTorben Westergård|Brazilian Heart|LatinDuke Ellington|The Private Collection vol. 7|JazzKassé-Mady Diabaté|Kassi Kasse|Afrikansk/VestArne Forchhammer Trio|Assimilation|JazzVieja Trova Santiaguera|Hotel Asturias|LatinSergio Mendes|Brasileiro|LatinFernando Tarres|The Outsider|Jazz/FusionJan Johansson|Folkvisor|JazzSonny Boy Williamson|The Bluebird Blues|Blu

[peterlaursen]

But it occurs only with “variable length”-setting and not “fixed length”

Can you live with putting in 2 characters as line delimiters until it's fixed ??

[Ritesh]

I have forwarded the issue to my development team.

If its a bug then it will be fixed in the next BETA of SQLyog v4.06.

[Ritesh]

Sorry but we are not able to reproduce the error with SQLyog v4.05 or v4.06 BETA 4.

Can you mail me sample data with a query and screenshots of your escape character window?

Note: While working on the report, we came across another bug where the option Field enclosed by optionally… behaves incorrectly. We will be releasing v4.06 BETA 5 soon that will have the bug-fix.

[peterlaursen]

>>> Ritesh

look at my data!! (10:51)

the VERY LAST ENDING should be “…… |Blues” but with a single character as line-delimiter it is only “……|Blue”

[peterlaursen]

I still have an old sqlyog 3.11 installed. Results with this one are sligthly different…

“lines teminated by” checked with value: $$

John McLaughlin|The Heart of Things|Jazz|$$Danu|The Road Less Traveled|Folk|$$Bud Powell|A Portrait of Thelonious|Jazz|$$Mississippi John Hurt|Revisited|Blues|$$Andy Statman Klezmer Orchestra|Klezmer Suite|Klezmer|$$Herbie Mann|Memphis Underground|Jazz/Soul/Funk|$$Kek Lang|Chants Room|Folk/Trad.|$$Astor Piazzolla|Concierto de Nascar|Tango|$$Grady Tate|All Love/Grady Tate Sings|Jazz|$$The Mills Brothers|Chronological, Vol. 3|Jazz|$$Cubanismo|Reencarnacion|Latin|$$Torben Westergård|Brazilian Heart|Latin|$$Duke Ellington|The Private Collection vol. 7|Jazz|$$Kassé-Mady Diabaté|Kassi Kasse|Afrikansk/Vest|$$Arne Forchhammer Trio|Assimilation|Jazz|$$Vieja Trova Santiaguera|Hotel Asturias|Latin|$$Sergio Mendes|Brasileiro|Latin|$$Fernando Tarres|The Outsider|Jazz/Fusion|$$Jan Johansson|Folkvisor|Jazz|$$Sonny Boy Williamson|The Bluebird Blues|Blues|$

“lines teminated by” checked with value: $

John McLaughlin|The Heart of Things|Jazz|$Danu|The Road Less Traveled|Folk|$Bud Powell|A Portrait of Thelonious|Jazz|$Mississippi John Hurt|Revisited|Blues|$Andy Statman Klezmer Orchestra|Klezmer Suite|Klezmer|$Herbie Mann|Memphis Underground|Jazz/Soul/Funk|$Kek Lang|Chants Room|Folk/Trad.|$Astor Piazzolla|Concierto de Nascar|Tango|$Grady Tate|All Love/Grady Tate Sings|Jazz|$The Mills Brothers|Chronological, Vol. 3|Jazz|$Cubanismo|Reencarnacion|Latin|$Torben Westergård|Brazilian Heart|Latin|$Duke Ellington|The Private Collection vol. 7|Jazz|$Kassé-Mady Diabaté|Kassi Kasse|Afrikansk/Vest|$Arne Forchhammer Trio|Assimilation|Jazz|$Vieja Trova Santiaguera|Hotel Asturias|Latin|$Sergio Mendes|Brasileiro|Latin|$Fernando Tarres|The Outsider|Jazz/Fusion|$Jan Johansson|Folkvisor|Jazz|$Sonny Boy Williamson|The Bluebird Blues|Blues|

“lines teminated by” checked but empty

John McLaughlin|The Heart of Things|Jazz|Danu|The Road Less Traveled|Folk|Bud Powell|A Portrait of Thelonious|Jazz|Mississippi John Hurt|Revisited|Blues|Andy Statman Klezmer Orchestra|Klezmer Suite|Klezmer|Herbie Mann|Memphis Underground|Jazz/Soul/Funk|Kek Lang|Chants Room|Folk/Trad.|Astor Piazzolla|Concierto de Nascar|Tango|Grady Tate|All Love/Grady Tate Sings|Jazz|The Mills Brothers|Chronological, Vol. 3|Jazz|Cubanismo|Reencarnacion|Latin|Torben Westergård|Brazilian Heart|Latin|Duke Ellington|The Private Collection vol. 7|Jazz|Kassé-Mady Diabaté|Kassi Kasse|Afrikansk/Vest|Arne Forchhammer Trio|Assimilation|Jazz|Vieja Trova Santiaguera|Hotel Asturias|Latin|Sergio Mendes|Brasileiro|Latin|Fernando Tarres|The Outsider|Jazz/Fusion|Jan Johansson|Folkvisor|Jazz|Sonny Boy Williamson|The Bluebird Blues|Blues

“lines teminated by” unchecked

John McLaughlinThe Heart of ThingsJazzDanuThe Road Less TraveledFolkBud PowellA Portrait of TheloniousJazzMississippi John HurtRevisitedBluesAndy Statman Klezmer OrchestraKlezmer SuiteKlezmerHerbie MannMemphis UndergroundJazz/Soul/FunkKek LangChants RoomFolk/Trad.Astor PiazzollaConcierto de NascarTangoGrady TateAll Love/Grady Tate SingsJazzThe Mills BrothersChronological, Vol. 3JazzCubanismoReencarnacionLatinTorben WestergårdBrazilian HeartLatinDuke EllingtonThe Private Collection vol. 7JazzKassé-Mady DiabatéKassi KasseAfrikansk/VestArne Forchhammer TrioAssimilationJazzVieja Trova SantiagueraHotel AsturiasLatinSergio MendesBrasileiroLatinFernando TarresThe OutsiderJazz/FusionJan JohanssonFolkvisorJazzSonny Boy WilliamsonThe Bluebird BluesBlue

[Ritesh]

peterlaursen wrote on May 4 2005, 09:46 AM:

>>> Ritesh

look at my data!! (10:51)

the VERY LAST ENDING should be “…… |Blues” but with a single character as line-delimiter it is only “……|Blue”

I saw the post but I am not able to reproduce the bug! Its working for me.

[peterlaursen]

>>> Ritesh

Do you still have the data that I sent you to test the “right alignment with GROUP clause”-issue ?

It's the same data that I use in this example. Could you try these ?

What else will we do then to get closer to the problem ?? 😮

You are welcome to send me some sample data that works with your installation, and I'll test on my system.

[Ritesh]

Quote:

I still have an old sqlyog 3.11 installed. Results with this one are sligthly different…

There has been lot of changes on that feature after 3.11. Many known bugs have been fixed.

[peterlaursen]

I don't doubt there has been a lot of changes in the code.

The only reason why I brought it in, was that the new design of the result-pane from 4.05 and onwards could have affected behaviour of the “copy to clipbord”-feature.

[Ritesh]

Here are the steps that I followed:

and the result:

[peterlaursen]

YEAH ..

but what if “lines terminated by” is only ONE character ??

[peterlaursen]

Actually if I let “lines terminated by” = $$$

it returns

'John McLaughlin','The Heart of Things','Jazz'$$$'Danu','The Road Less Traveled','Folk'$$$'Bud Powell','A Portrait of Thelonious','Jazz'$$$'Mississippi John Hurt','Revisited','Blues'$$$'Andy Statman Klezmer Orchestra','Klezmer Suite','Klezmer'$$$'Herbie Mann','Memphis Underground','Jazz/Soul/Funk'$$$'Kek Lang','Chants Room','Folk/Trad.'$$$'Astor Piazzolla','Concierto de Nascar','Tango'$$$'Grady Tate','All Love/Grady Tate Sings','Jazz'$$$'The Mills Brothers','Chronological, Vol. 3','Jazz'$$$'Cubanismo','Reencarnacion','Latin'$$$'Torben Westergård','Brazilian Heart','Latin'$$$'Duke Ellington','The Private Collection vol. 7','Jazz'$$$'Kassé-Mady Diabaté','Kassi Kasse','Afrikansk/Vest'$$$'Arne Forchhammer Trio','Assimilation','Jazz'$$$'Vieja Trova Santiaguera','Hotel Asturias','Latin'$$$'Sergio Mendes','Brasileiro','Latin'$$$'Fernando Tarres','The Outsider','Jazz/Fusion'$$$'Jan Johansson','Folkvisor','Jazz'$$$'Sonny Boy Williamson','The Bluebird Blues','Blues'$

[Ritesh]

If I use $, I get:

Quote:

'John McLaughlin','The Heart of Things','Jazz'$'Danu','The Road Less Traveled','Folk'$'Bud Powell','A Portrait of Thelonious','Jazz'$'Mississippi John Hurt','Revisited','Blues'$'Andy Statman Klezmer Orchestra','Klezmer Suite','Klezmer'$'Herbie Mann','Memphis Underground','Jazz/Soul/Funk'$'Kek Lang','Chants Room','Folk/Trad.'$'Astor Piazzolla','Concierto de Nascar','Tango'$'Grady Tate','All Love/Grady Tate Sings','Jazz'$'The Mills Brothers','Chronological, Vol. 3','Jazz'$'Cubanismo','Reencarnacion','Latin'$'Torben Westergård','Brazilian Heart','Latin'$'Duke Ellington','The Private Collection vol. 7','Jazz'$'Kassé-Mady Diabaté','Kassi Kasse','Afrikansk/Vest'$'Arne Forchhammer Trio','Assimilation','Jazz'$'Vieja Trova Santiaguera','Hotel Asturias','Latin'$'Sergio Mendes','Brasileiro','Latin'$'Fernando Tarres','The Outsider','Jazz/Fusion'$'Jan Johansson','Folkvisor','Jazz'$'Sonny Boy Williamson','The Bluebird Blues','Blues

There is no ' at the end (which is a bug) though there is no truncation of data either.

We will fix the issue with $ and $$$.

[peterlaursen]

It's a good thing when communication is a success … 😀

[jayshi]

Glad we are on the same page, Sorry I did not come to check this post as I was very busy with month end project. I was just using default setting

“Lines Terminated By n” and for Variable Length, I have “Field Terminated By t”, so I was losting my last bit of data.

Thanks.

[Ritesh]

jayshi wrote on May 4 2005, 07:29 PM:

Glad we are on the same page, Sorry I did not come to check this post as I was very busy with month end project.  I was just using default setting

“Lines Terminated By n” and for Variable Length, I have “Field Terminated By t”, so I was losting my last bit of data.

Thanks.

Can you mail me a screenshot of your Escape Character window? I am still not able to reproduce the error where data is being truncated 🙁

[Ritesh]

@jayshi: I got your mail. Can you mail me the screenshot of your escape character window?

[sergius]

I haven't read all the replies here. In case this still matters, I also hit this bug.

MySQL 4.0.16 / Linux

SQLyog 4.0.5 / W2K

I tried to attach a small png screenshot to this post, but the interface wouldn't let me for some reason

[peterlaursen]

they are in the proces of moving the forum to another server, and the new one isn't quite configured yet …

And I don't know if it will ever accept PNG's … but at least JPG's should work very soon.

Sergius could you send a screenshot of your “Escape Character window” to Ritesh then …

[Ritesh]

@jayshi and @sergius: Please mail me the screenshot of your Escape Character window. I believe this bug occurs only with one particular value(s) of escape characters.

[Ritesh]

BTW, have you people tried the latest BETA 5 of v4.06. This BETA fixes couple of bugs which were identified while working on the above issue.

[peterlaursen]

> yes Ritesh, probably …

but try using the default values of the sqlyog program (if they have not been changed by the user yet) !

and besides that gives me a chance to say the the escapes the program proposes when you use the “copy from clipboard” for the first time are rather WEIRD.

I believe that I can make out that these defaults will generate an output that fits for use in a PHP-script, but still … why ??

[peterlaursen]

Give me ten minutes to test …

[peterlaursen]

It's perfect here with the inputs that are within the reach of my imagination …

Just one crazy example

“'Papa' John DeFrancesco”+”Hip Cake Walk”+”Jazz”||”12 Apostles Church Choir”+”The Rough Guide to South African Gospel”+”World”||”3eme concours flamenco”+”Nimes”+”Flamenco”||”A Falta De Pan”+”Rough Guide to the Music of Spain”+”Folk/Fusion”||”Aaron Neville”+”Nature Boy: The Standards Album”+”Jazz”||”Abaji”+”Rêves d'Oasis: Desert Blues 2 (1 of 2)”+”Afrikansk/Vest”||”Abaji”+”Oriental Voyage”+”Folk/Fusion”||”Abbey Lincoln”+”A Turtle's Dream”+”Jazz”||”Abbey Lincoln”+”Abbey Is Blue”+”Jazz”||”Abbey Lincoln”+”Over the Years”+”Jazz”||”Abdel Gadir Salim”+”Popular Music of Sudan”+”Afrikansk/Arabisk”||”Abdel Gadir Salim”+”Ambiances du Sahara: Desert Blues (1 of 2)”+”Afrikansk/Vest”||”Abdel Gadir Salim”+”Ambiances du Sahara: Desert Blues (2 of 2)”+”Afrikansk/Vest”||”Abdel Halim Hafez”+”Rough Guide to the Music of Egypt”+”World”||”Abdou”+”The Rough Guide to Rai”+”Folk/Fusion”||”Abdullah Ibrahim”+”African Horns”+”Jazz”||”Abdullah Ibrahim”+”African Magic”+”Jazz”||”Abdullah Ibrahim”+”African Piano”+”Jazz”||”Abdullah Ibrahim”+”African River”+”Jazz”||”Abdullah Ibrahim”+”Anatomy of a South African Village”+”Jazz”

BTW … what does it mean to check the “optionally” box – I can't reproduce any difference whether this box is check or not …

[Ritesh]

From the MySQL Docs at:

http://dev.mysql.com/doc/mysql/en/load-data.html

Quote:

FIELDS [OPTIONALLY] ENCLOSED BY controls quoting of fields. For output (SELECT … INTO OUTFILE), if you omit the word OPTIONALLY, all fields are enclosed by the ENCLOSED BY character. An example of such output (using a comma as the field delimiter) is shown here:

“1”,”a string”,”100.20″

“2”,”a string containing a , comma”,”102.20″

“3”,”a string containing a ” quote”,”102.20″

“4”,”a string containing a “, quote and comma”,”102.20″

If you specify OPTIONALLY, the ENCLOSED BY character is used only to enclose CHAR and VARCHAR fields:

1,”a string”,100.20

2,”a string containing a , comma”,102.20

3,”a string containing a ” quote”,102.20

4,”a string containing a “, quote and comma”,102.20

Note that occurrences of the ENCLOSED BY character within a field value are escaped by prefixing them with the ESCAPED BY character. Also note that if you specify an empty ESCAPED BY value, it is possible to generate output that cannot be read properly by LOAD DATA INFILE. For example, the preceding output just shown would appear as follows if the escape character is empty. Observe that the second field in the fourth line contains a comma following the quote, which (erroneously) appears to terminate the field:

[peterlaursen]

thanks for the explanation!

And that works too (with another crazy example – not 3-charcter delimiter)

1+”John McLaughlin”+”The Heart of Things”|$|2+”Danu”+”The Road Less Traveled”|$|3+”Bud Powell”+”A Portrait of Thelonious”|$|4+”Mississippi John Hurt”+”Revisited”|$|5+”Andy Statman Klezmer Orchestra”+”Klezmer Suite”|$|6+”Herbie Mann”+”Memphis Underground”|$|7+”Kek Lang”+”Chants Room”|$|8+”Astor Piazzolla”+”Concierto de Nascar”|$|9+”Grady Tate”+”All Love/Grady Tate Sings”|$|10+”The Mills Brothers”+”Chronological, Vol. 3″|$|11+”Cubanismo”+”Reencarnacion”|$|12+”Torben WestergÃ¥rd”+”Brazilian Heart”|$|13+”Duke Ellington”+”The Private Collection vol. 7″|$|14+”Kassé-Mady Diabaté”+”Kassi Kasse”|$|15+”Arne Forchhammer Trio”+”Assimilation”|$|16+”Vieja Trova Santiaguera”+”Hotel Asturias”|$|17+”Sergio Mendes”+”Brasileiro”|$|18+”Fernando Tarres”+”The Outsider”|$|19+”Jan Johansson”+”Folkvisor”|$|20+”Sonny Boy Williamson”+”The Bluebird Blues”

But does that mean then that sqlyog will send a NEW query to the MySQLseserver ??

That could be important to know in the case data have changed in the meantime …

(I thougt it just read from the result pane!)

[peterlaursen]

a correction of my last post

And that works too (with another crazy example – not 3-charcter delimiter)

>>

And that works too (with another crazy example – NOTE 3-character delimiter)

(NOTE: “NOTE” not “NOT” 🙄 )

[peterlaursen]

one more crazy ex that works fine…

35612,'@'Papa@' John DeFrancesco','Hip Cake Walk','Song For My Father'=====35617,'@'Papa@' John DeFrancesco','Hip Cake Walk','Latin Groove'=====35616,'@'Papa@' John DeFrancesco','Hip Cake Walk','Back At The Chicken Shack'=====35615,'@'Papa@' John DeFrancesco','Hip Cake Walk','Moanin@''=====35614,'@'Papa@' John DeFrancesco','Hip Cake Walk','High Rider'=====35611,'@'Papa@' John DeFrancesco','Hip Cake Walk','Freddy The Freeloader'=====35610,'@'Papa@' John DeFrancesco','Hip Cake Walk','The Cat'=====35618,'@'Papa@' John DeFrancesco','Hip Cake Walk','Hip Cake Walk'=====35613,'@'Papa@' John DeFrancesco','Hip Cake Walk','Milestones'=====26714,'12 Apostles Church Choir','The Rough Guide to South African Gospel','Izindaba'=====27533,'3eme concours flamenco','Nimes','Guajira'=====25108,'3eme concours flamenco','Nimes','Taranta'=====25235,'3eme concours flamenco','Nimes','Solea'=====1893,'3eme concours flamenco','Nimes','Danse'=====523,'3eme concours flamenco','Nimes','Solea'=====3504,'3eme concours flamenco','Nimes','Danse'=====6931,'3eme concours flamenco','Nimes','Solea'=====9066,'3eme concours flamenco','Nimes','Tonas'=====8084,'3eme concours flamenco','Nimes','Buleria'=====9741,'3eme concours flamenco','Nimes','Taranta'

here @ is escape character and comes in use because of artist name: 'Papa' John DeFrancesco that contains the ' -character that is also used as field delimiter. And line delimiter is here: ===== (as it should be)

[peterlaursen]

well .. the ' character was used as the character to ENCLOSE fields – rather 😡

[peterlaursen]

BTW …

I think it would be more logical if the “enclosed by”box was followed by the “escaped by”box in the dialogue

since the escape-character escapes the enclose-character …

[Ritesh]

peterlaursen wrote on May 6 2005, 04:10 AM:

But does that mean then that sqlyog will send a NEW query to the MySQLseserver ??

That could be important to know in the case data have changed in the meantime …

(I thougt it just read from the result pane!)

SQLyog does not send any new query to the MySQL server. It just reads the data from the result pane 😀

[peterlaursen]

🙂 That's good …

But honestly , you must admit that the design of the “copy to clipboard”-dialogue is rather poor .. ah ??

Redesign/rearrange it – put a few explanations in it (for instance explain with a few words why it's important to use an escape-character) and change “optional” to “CHARs and VARCHARS only”. You shouldn't need to know all details of MySQL-syntax to use a GUI ….

The dialogue box does not need to be that small. It's rather confusing as it is! And the program's defaults makes it even more confusing!

[Ritesh]

Thanks for your suggestions.

I will discuss the issue with my development team.

[Shadow]

And it might be a good idea to add GUI support for generally used separator characters such as n or rn. Some users may not know how to encode for example Windows style new line character…

[peterlaursen]

Right Shade … 😀

Actually there could be some sort of “templates” described (or even implemented somehow. Buttons ?) like

“High readability” “To use with texteditors” “To use as CSV” “To use with SQL” “Rich Text Format” “XML-schema” etc …

Just in case someone gets bored at webyog or can't sleep at night 😛

[Shadow]

Great idea! 😀

[peterlaursen]

thx …I'll do my best that no-one at webyog get bored or will ever sleep at night 😆

No actually: a drop-down box with templates that reads it's input from an XML-file would allow people to create their own templates easily … But for the near future just some more logic and clarity would be fine… I don't know how much this copy-facility is used at all. Maybe the people that use it know how to handle it.

[Shadow]

I use it frequently to get the correct SQL statement for exporting data from the server, then I copy that statement to a batch file… 🙄

[Author]

Posts