[larsen]

1) Linux

2) I only have a 5.0.51a server as this is the newest version you get from Debian Lenny.

3) It does work then.

4) works, too

5) Sorrry, no powertools with community version here =)

I still see the problem in SQLyog: When I type in “user”, SQLyog recognizes this as a function instead of a table name and capitalizes it. Internally though, it passes it as “user” to the server. Now, when I copy it, SQLyog inserts it as “USER” and also passes it as such to the server, where this of course is not an existing table.

[larsen]

The problem seems to be caused by copying the first statement and inserting it. SQLyog automatically changes the “user” to “USER” when I enter it (first statement). Then it is copied as “USER”.

I can fix the problem with the second statement by simply overwriting “USER” with “user” (what becomes “USER” automatically again).

[larsen]

'Mahesh' wrote on '19:

This is MySQL question instead SQLyog.

I never said it was a SQLyog question =)

Quote:

Length()function Returns the length of the string str, measured in bytes. A multi-byte character counts as multiple bytes. This means that for a string containing five two-byte characters, LENGTH() returns 10, whereas CHAR_LENGTH() returns 5.

thx! i didn´t knew there was a specific function for that case.

[larsen]

1. Click on a database on the left

2. Click on the “Info” tab and choose “Text/Detailed”

3. Select some text

4. Press Ctrl+C

–> Text is copied but the selection is removed

[larsen]

'peterlaursen' wrote on '03:

was it a SQLyog or MONyog question?

Whooops, sorry. Can you please move this topic to the SQLyog forum?

thx =)

[larsen]

Thx!

[larsen]

+1 for this

IMHO it would be best to display it in the “Messages” tab that is already displayed after execution.

[larsen]

Hi,

navyashree.r wrote on May 13 2009, 07:12 AM:

Here, if the focus is in “No. of rows” text box press TAB. The 'Refresh' button gets selected. Now, press 'Enter' the table data will be refreshed.

And also if the focus is in the Grid (1st row, 1st column) position press SHIFT + TAB the Refresh button will be selected. Next, press 'Enter' through keyboard, the table data will be refreshed.

yes and I could also grab my mouse to click on refresh but both ways are not comfortable. Shouldn´t be a problem to check wether enter was pressed while inside the text boxes?

[larsen]

peterlaursen wrote on May 12 2009, 04:45 PM:

OK .. but how will you be able to predict in what order will MYSQL return rows? There is a LIMIT clause but no ORDER BY.

Sorry, I don´t understand the problem. There already is a “refresh” button next to the text fields. What difference would there be wether I pressed “enter” or clicked on “refresh”? I just want to use the keyboard.

[larsen]

Yes, now works as expected. Thx.

[larsen]

hmm… a new one or a new one… I think it´s a new one 😉

What I wanted to say is that there is a bug and I am using 8.04. The bug could have already existed in 8.03.

[larsen]

Khushboo wrote on Mar 13 2009, 03:06 PM:

Please let us know the status.

It works, i.e. an error message is shown.

[larsen]

peterlaursen wrote on Mar 9 2009, 02:56 PM:

.. what means that we will simply prevent updation of such data from the grid. Still you can update all other non-binary data in the table from the RESULT tab (first execute a SELECT with no such binary columns and next work in the RESULT tab).

That´s totally ok with me.

[larsen]

peterlaursen wrote on Mar 6 2009, 08:26 PM:

“it shouldn´t be written back to disk” .. are you telling that after editing that row, this particular column is updated to contain 'binary/ima”?

yes

[larsen]

Quote:

You can “select hex(data) from rawdata” (result will be read-only). You also can change column type to blob or varbinary (what would make more sense as they are binary types), but we will still do not handle it automatically in the GUI.

The old interface sent everything nicely as standard text. When switching to blob/varbinary I should have no problems with that, should I? (the table has to support both types)

Quote:

And I really doubt that any other program version did different with *exactly* those data!

Yeah, I didn´t test it with exactly that data. I think I saw the editor with another field of type blob.

I don´t care if SQLyog shows “(Binary/Image)” when there are NULL bytes. But as this is just a visual placeholder, it shouldn´t be written back to disk. Is it likely that this behaviour is changed?

Lars

[Author]

Posts