Edit simple text in the Blob Editor

[expired user #93]'s profile image [expired user #93] posted 18 years ago in General Permalink
You can answer in German, too.

Hello

There is a simple Database containing 1 table - and 5 records

there are 5 ids for each record.

table: sitename
record Seite 1- seite 2- seite 3- seite 4- seite 5
id1 deutsch id2 englisch id3 etc.

In heidisql it says id 1-5 from top down - and seite 1-5 from left to right (memo) in each position

[size=18:fe9eabceef]in theses (memo)s i do have simple text. How do I change this text?[/size:fe9eabceef]

when I click on blob editor, i can see the text, but i cant change it.

http://www.uuag.com/sq100.jpg
[img][/img][url][/url]
ansgar's profile image ansgar posted 18 years ago Permalink
Which version are you using?

The editable-option in the blob-editor is disabled, when HeidiSQL finds any non-latin1-char in the cell-content in order to avoid data-loss when posting the text to the server with a charset which doesn't support these chars!

When I see the text you have in your table, me seems that only these chars are special in any way: < > ' . I would say that these characters are also in latin1, although I don't know exactly. We will check that.
[expired user #93]'s profile image [expired user #93] posted 18 years ago Permalink
Hi

Thank You for Your reply.

I installed version 3.0 RC3 Revision 111.

Looks like this is the latest version.


There is just simple html text in those fields, I
[expired user #103]'s profile image [expired user #103] posted 18 years ago Permalink
High, anse,

i have the same problem. my opinion is, that HeidiSQL has problems in editing MEMO Field if there are chr( 13 ) chr( 10 ) characters in the MEMO Text.

Do you know any solution for this?

thanks
Claus
[expired user #192]'s profile image [expired user #192] posted 17 years ago Permalink
Is there a solution already for this prblem
ansgar's profile image ansgar posted 17 years ago Permalink
not yet but we are working on that.
ansgar's profile image ansgar posted 17 years ago Permalink
the bug is fixed now! happy

The next release should be out soon. I'm not quite sure if we should make a RC4 or the final 3.0 now because we have some complicated bugs left. But maybe this version-thing doesn't matter so much, so we most probably make a new RC.
superspace's profile image superspace posted 17 years ago Permalink
Woohoo!!!!

This is one annoying bug!!!!

So good its fixed.

Now.. about the connection problem... haven't checked whether anyone has logged it yet. If not I'll have to log it and hopefully it will be included in the next RC. :P
[expired user #285]'s profile image [expired user #285] posted 17 years ago Permalink
Hi,

I uninstalled MySQL Front and replaced it with HeidiSQL, but I cant seem to edit/save BLOB data through HeidiSQL.

Is there a patch to fix this or is it still in the pipeline? MySQL Front didnt have this problem!

Regards :)

p.s. Nice to see you back in action Anse.
ansgar's profile image ansgar posted 17 years ago Permalink
RC4 will be out in November. :)

Greetings,
Anse
[expired user #285]'s profile image [expired user #285] posted 17 years ago Permalink
Its mid November and still waiting for the next release/update.

I really need the blob editor Anse. If its already fixed, please release an RC4 while the remaining bugs get fixed then release it as Final. :idea:
ansgar's profile image ansgar posted 17 years ago Permalink
Sorry, but you have to wait a few days, maybe a week or two but I'm still thinking we can release the RC4 in November.
[expired user #285]'s profile image [expired user #285] posted 17 years ago Permalink
Fingers crossed 10 days to go till December :twisted:
ansgar's profile image ansgar posted 17 years ago Permalink
yeah I'm still optimistic that we will do that in november :)

And indeed: you will love the fixes and the new features.

Ansgar

Please login to leave a reply, or register at first.