Page 1 of 2
[DONE] Problem editing CHAR and VARCHAR field

Posted:
Tue Nov 06, 2012 12:08 pm
by batch4j
Dear Sirs,
I test the lastest version RC1 in order to check that the HEX editor work well with CHAR and VARCHAR field. I detect a problem with the Hext to text and text to cell .
I send to you some snapshoot.
Please, if you need more info I try to provide asap.
Thanks you
Re: Problem editing CHAR and VARCHAR field

Posted:
Tue Nov 06, 2012 2:46 pm
by Serge
Hello,
What database is it and what driver do you use? Very strange approach to data storage

I think problem is in binary->string translation. Sequence of bytes can't be converted into string using current charset. So string is cut at the first "bad" byte. It seems to be a zero byte.
But probably it is a bug in DBeaver. I'll check Hex editor one more time..
Re: Problem editing CHAR and VARCHAR field

Posted:
Wed Nov 07, 2012 8:49 am
by batch4j
Hi,
I think that is a problem of TEXT editor instead of HEX editor or Cell Editor.
I use db2 Zos and db2- Luw
By example, I create a field with all 255 diferent bytes If you see the Cell editor apperar symbols, but when you edit with text remove from the first 00.
To, This error appear in the previous version 1.6.4, try o read using a text.
Try to insert the following in a CHAR field ( '123casa' || x'00001214'). and try to read using first HEX or text.
I think that is a problem to pass from Cell to Text and to Hex to Text and viceversa. Posible problem with Text component.
Please send to me a email whit all the info what you need. If you want Icould work in solved this error, but I need a full zip with the code.
Thanks you
Re: Problem editing CHAR and VARCHAR field

Posted:
Wed Nov 07, 2012 12:08 pm
by Serge
Hi,
I think that I have enough information about this issue.
I've made a workaround. Today evening I'll publish EA version which will support binary string edit with one limitation - you can't increase binary value length.
If it will work then I'll try to remove this limitation in final release. Actually it is in HexEditorControl.
You can get DBeaver sources directly from VC system - you can find SVN cridentials on download page.
Re: Problem editing CHAR and VARCHAR field

Posted:
Wed Nov 07, 2012 12:11 pm
by batch4j
Hi Serge,
I try to test the version and comment with you.
Thanks
Re: Problem editing CHAR and VARCHAR field

Posted:
Wed Nov 07, 2012 8:22 pm
by Serge
EA version is available here:
Re: Problem editing CHAR and VARCHAR field

Posted:
Thu Nov 08, 2012 9:49 am
by batch4j
Hi Serge,
The EA have the same error.
Do you need more info in order to replicate the error.
Thanks
JuanP
Re: Problem editing CHAR and VARCHAR field

Posted:
Thu Nov 08, 2012 12:11 pm
by Serge
Hmm. I'm afraid you were right and problem is in SWT Text control. It removes everything after first zero byte.
Also it is platform-dependent behaviour as Text is a native component and actual implementation is in UI system. This problem appears is at least on Windows so we have to fix it anyway.
I'll ty to make some workaround (avoid using Text for binary edited data)..
Re: Problem editing CHAR and VARCHAR field

Posted:
Thu Nov 08, 2012 2:27 pm
by Serge
I've fixed hex editor yet another time and now it works fine in Windows.
I had to remove text-binary changes reflection so these sub-editors are now completely independent.
New EA will be published tonight.
Re: Problem editing CHAR and VARCHAR field

Posted:
Thu Nov 08, 2012 2:48 pm
by batch4j
Hi,
I try to test asap, but I have holidays up to monday.
Please, put the url of new version that you have that I test it.
Thanks