New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Cannot edit blob fields #13683

Closed
raiffeisennet opened this Issue Sep 14, 2017 · 9 comments

Comments

Projects
None yet
2 participants
@raiffeisennet

raiffeisennet commented Sep 14, 2017

How can blob fields be edited? DisplayBinaryAsHex is not supported anymore, so the blob field is shown with numbers only.

@nijel nijel self-assigned this Sep 28, 2017

@nijel nijel added the question label Sep 28, 2017

@nijel

This comment has been minimized.

Show comment
Hide comment
@nijel

nijel Sep 28, 2017

Member

Sorry, but it doesn't make much sense to edit arbitrary binary data. You can download/upload the blob fields. Alternatively you can use transformations to implement some specific editor.

Member

nijel commented Sep 28, 2017

Sorry, but it doesn't make much sense to edit arbitrary binary data. You can download/upload the blob fields. Alternatively you can use transformations to implement some specific editor.

@nijel nijel closed this Sep 28, 2017

@raiffeisennet

This comment has been minimized.

Show comment
Hide comment
@raiffeisennet

raiffeisennet Oct 2, 2017

It was a feature in older phpMyAdmin versions. We use to store json data in blob fields and there is indeed the need to modify this fields.

raiffeisennet commented Oct 2, 2017

It was a feature in older phpMyAdmin versions. We use to store json data in blob fields and there is indeed the need to modify this fields.

@nijel

This comment has been minimized.

Show comment
Hide comment
@nijel

nijel Oct 2, 2017

Member

Any reason for using BLOB instead of TEXT in this case (not to mention JSON data type in recent MySQL versions)?

Member

nijel commented Oct 2, 2017

Any reason for using BLOB instead of TEXT in this case (not to mention JSON data type in recent MySQL versions)?

@raiffeisennet

This comment has been minimized.

Show comment
Hide comment
@raiffeisennet

raiffeisennet Oct 2, 2017

Due to legacy reasons, we used BLOB instead of TEXT, as we encountered encoding problems with the TEXT fields. For that reason, we used BLOB and VARBINARY in the past.

raiffeisennet commented Oct 2, 2017

Due to legacy reasons, we used BLOB instead of TEXT, as we encountered encoding problems with the TEXT fields. For that reason, we used BLOB and VARBINARY in the past.

@nijel

This comment has been minimized.

Show comment
Hide comment
@nijel

nijel Oct 2, 2017

Member

Anyway what you are probably looking for is $cfg['ProtectBinary'] = false

Member

nijel commented Oct 2, 2017

Anyway what you are probably looking for is $cfg['ProtectBinary'] = false

@raiffeisennet

This comment has been minimized.

Show comment
Hide comment
@raiffeisennet

raiffeisennet Oct 2, 2017

I have set this already, this gives me the possibility to show the contents. But i also need to edit them and for this I need a "DisplayBinaryAsHex"=false like in older versions of phpMyAdmin.

raiffeisennet commented Oct 2, 2017

I have set this already, this gives me the possibility to show the contents. But i also need to edit them and for this I need a "DisplayBinaryAsHex"=false like in older versions of phpMyAdmin.

@nijel

This comment has been minimized.

Show comment
Hide comment
@nijel

nijel Oct 2, 2017

Member

Editing works fine for me with this:

screenshot-2017-10-2 localhost localhost bar2 5432gft phpmyadmin 4 8 0-dev

Member

nijel commented Oct 2, 2017

Editing works fine for me with this:

screenshot-2017-10-2 localhost localhost bar2 5432gft phpmyadmin 4 8 0-dev

@raiffeisennet

This comment has been minimized.

Show comment
Hide comment
@raiffeisennet

raiffeisennet Oct 3, 2017

so you edit plain HEX values? i need the real content instead of the HEX value, like it was in older phpMyAdmin versions with DisplayBinaryAsHex=false

raiffeisennet commented Oct 3, 2017

so you edit plain HEX values? i need the real content instead of the HEX value, like it was in older phpMyAdmin versions with DisplayBinaryAsHex=false

@nijel

This comment has been minimized.

Show comment
Hide comment
@nijel

nijel Oct 3, 2017

Member

Sorry, this is no longer supported. Change field type or set input transformation to JSON.

This way you will get editor with JSON syntax highlighting:

screenshot-2017-10-3 localhost localhost bar2 jsontest phpmyadmin 4 7 5-dev

Member

nijel commented Oct 3, 2017

Sorry, this is no longer supported. Change field type or set input transformation to JSON.

This way you will get editor with JSON syntax highlighting:

screenshot-2017-10-3 localhost localhost bar2 jsontest phpmyadmin 4 7 5-dev

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment