[DONE] Problem editing CHAR and VARCHAR field

Note: please leave bug reports and feature requests on

[DONE] Problem editing CHAR and VARCHAR field

Postby batch4j » Tue Nov 06, 2012 12:08 pm

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
Attachments
issue.zip
This is a file with the incident about save and read from HEX to text and to HEX or TEXT to Cell,
(246.93 KiB) Downloaded 752 times
batch4j
 
Posts: 28
Joined: Tue Oct 30, 2012 2:23 pm

Re: Problem editing CHAR and VARCHAR field

Postby Serge » Tue Nov 06, 2012 2:46 pm

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..
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: Problem editing CHAR and VARCHAR field

Postby batch4j » Wed Nov 07, 2012 8:49 am

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
batch4j
 
Posts: 28
Joined: Tue Oct 30, 2012 2:23 pm

Re: Problem editing CHAR and VARCHAR field

Postby Serge » Wed Nov 07, 2012 12:08 pm

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.
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: Problem editing CHAR and VARCHAR field

Postby batch4j » Wed Nov 07, 2012 12:11 pm

Hi Serge,

I try to test the version and comment with you.

Thanks
batch4j
 
Posts: 28
Joined: Tue Oct 30, 2012 2:23 pm

Re: Problem editing CHAR and VARCHAR field

Postby Serge » Wed Nov 07, 2012 8:22 pm

EA version is available here:
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: Problem editing CHAR and VARCHAR field

Postby batch4j » Thu Nov 08, 2012 9:49 am

Hi Serge,

The EA have the same error.

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

Thanks

JuanP
batch4j
 
Posts: 28
Joined: Tue Oct 30, 2012 2:23 pm

Re: Problem editing CHAR and VARCHAR field

Postby Serge » Thu Nov 08, 2012 12:11 pm

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
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: Problem editing CHAR and VARCHAR field

Postby Serge » Thu Nov 08, 2012 2:27 pm

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.
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: Problem editing CHAR and VARCHAR field

Postby batch4j » Thu Nov 08, 2012 2:48 pm

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
batch4j
 
Posts: 28
Joined: Tue Oct 30, 2012 2:23 pm

Next

Return to Support



Who is online

Users browsing this forum: No registered users and 9 guests