[DONE] Problem editing CHAR and VARCHAR field

[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

[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..

[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

[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.

[batch4j]

Hi Serge,

I try to test the version and comment with you.

Thanks

[Serge]

EA version is available here:

[batch4j]

Hi Serge,

The EA have the same error.

Do you need more info in order to replicate the error.

Thanks

JuanP

[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)..

[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.

[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