[peterlaursen]

One thing more: BLOB-viewer lets you insert graphics into a TEXT-field. It shouldn't! See pic.

The funny string 'y0ya' with various accents is how a jpg-file starts.

I guess it must reformat the data – if not MySQL server shouldn't accept that input to a TEXT-field!

I believe I can make out that this formatting (binary >> character) takes place even with BLOB-fields and that this is the root of the problem.

Further after saving data an attempt to open the TEXT-field containing (reformatted) jpg-data crashes SQLyog.

(the other way around: character-data into a BLOB-field probably should be accepted, since it's common practice – though a bad idea in my opinion!)

[peterlaursen]

BTW –

1) would it be a big deal to make the BLOB-viewer window resizable ?

(edited: I see that just4fun has put forward the same suggestion <_< ) 2) would it be a big deal to have an option to choose how wide the BLOB/TEXT column opens in DATA- and RESULT -panes 3) what about a NEXT and PREVIOUS -button in BLOB-viewer (should follow the sort order of DATA or RESULT-pane depending on which one is active) ?

[peterlaursen]

the graphics functionality was broken with 4.06 too!

I don't have older versions installed anymore, so I can't test when it happened!

[peterlaursen]

and …

when graphics has been saved to the database you can't open it in BLOB-viewer! Not from DATA-pane either.

Conclusion: graphics functionality with the BLOB-viewer is broken with 4.07!

[peterlaursen]

above is what it should look like.

Below is what it looks like in BLOB-viewer

[peterlaursen]

correction: Not quite functioning yet!

1)

With text-data there is an almost cosmetical issue: when opening the BLOB-viever, you'll have to click in the window to activate the keyboard with the window. Cursor should be active in the BLOB-viewer window when the window opens. But apart from that I like that you are able to se the beginning of the string from the table view itself.

2)

However some functionality with graphics data now seems broken:

— graphics is not lookin good! there are som artifacts and proportions are changed. See attached pic.

— but most important: import and export of graphics data does not work! (it only doesfrom DATA-pane with a newly created table that has not yet been saved).

— the displaying of the first characters in table view does not make sense with graphics data. I think you should remove it when data are graphics!

Did you totally forget the graphics ?? 🙄

BTW: is it still in the TO-DO list to let BLOB-viewer dislay a binary/hex view of data ?

[peterlaursen]

Quote:

So are you able to edit the result?

If that was a Q for me the A is “Yes”.

I should have known better, but must have been too tired …

[peterlaursen]

Quote:

Select the correct table from the combo dropdown

of course!

[peterlaursen]

It looks like a bug too! 🙁

I can't either from RESULT-pane , but I can from DATA-pane (remember to uncheck the “set NULL”-box)!

Besides I think you should consider using TEXT-types for character data …

[peterlaursen]

😀

[peterlaursen]

exactly the same – empty strings instead of NULL's – last line should read

Code:

insert into `tablename1` values (5,NULL);

and the other lines same way!

[peterlaursen]

pic comes here

[peterlaursen]

in PPL (Peter's Programming Language 😀 ) it would be just …

if not content_of_field IS NULL

then

// your current code here //

else

write('NULL')

endif

SQL-file should look like:

/*

SQLyog Enterprise v4.07 BETA 2

Host – 5.0.7-beta-nt-max : Database – test

*********************************************************************

Server version : 5.0.7-beta-nt-max

*/

create database if not exists `test`;

USE `test`;

/*Table structure for table `test2` */

drop table if exists `test2`;

CREATE TABLE `test2` (

`id` bigint(20) NOT NULL auto_increment,

`text1` varchar(50) default NULL,

`text2` varchar(50) default NULL,

`mytime` timestamp NULL default NULL,

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `test2` */

insert into `test2` values (1,'first',NULL,'2020-05-05 05:05:05');

insert into `test2` values (2,'second',NULL,NULL);

insert into `test2` values (3,'third',NULL,NULL);

That imports right (see pic)

… and Note: last line should NOT be

“insert into `test2` values (3,'third','NULL','NULL');” 😎

Agreed ??

[peterlaursen]

Exporting and importing results in: see new pic …

SQL file looks like

/*

SQLyog Enterprise v4.07 BETA 2

Host – 5.0.7-beta-nt-max : Database – test

*********************************************************************

Server version : 5.0.7-beta-nt-max

*/

create database if not exists `test`;

USE `test`;

/*Table structure for table `test2` */

drop table if exists `test2`;

CREATE TABLE `test2` (

`id` bigint(20) NOT NULL auto_increment,

`text1` varchar(50) default NULL,

`text2` varchar(50) default NULL,

`mytime` timestamp NULL default NULL,

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `test2` */

insert into `test2` values (1,'first','','2020-05-05 05:05:05');

insert into `test2` values (2,'second','','');

insert into `test2` values (3,'third','','');

There is not written “NULL” to the export file as I think there should be, but empty strings instead.

Result is NULL strings becoming empty strings ('') and NULL timestamps becoming 0000-00-00-000000 (and NULL numbers probably 0's (zero's).

So I must say: bug confirmed !

[peterlaursen]

I can now reproduce my issue. it was not an issue with SJA (that works perfectly in this respect) but with export/import facility.

Se pic…

[Author]

Posts