row field very large

3 posts

[expired user #2758] posted 17 years ago in General

I used heidisql for a few month without any problem.

But now, varchar fields are very large (more than 800 pixels large) when if I resize manually when do a refresh (F5), or restart heidisql, fields resize to the large value...

I tried to resintall the latest version, same thing.

10163 posts

ansgar posted 17 years ago

Just set the following option:
Tools > Preferences > Data-Appearance > "Maximum column width ..."

3 posts

[expired user #2758] posted 17 years ago

Ok, thank for the workaround

10163 posts

ansgar posted 17 years ago

ehm, that is not a workaround, it was supposed to be a feature, guy :)

3 posts

[expired user #2758] posted 17 years ago

Okay

But the value is 0 (automatic) and I never change this value, so do you have an idea of why it was ok before without changing this value?

Anyway, the main thing is that's work :)

Thank you

10163 posts

ansgar posted 17 years ago

I think 0 is the default value which applies on a first time installation.

6 posts

[expired user #2117] posted 16 years ago

Thank you very much for this, I had this same problem appear suddenly for no apparent reason.

1 posts

[expired user #3370] posted 16 years ago

Yes, this annoying me too. I have 0 (automatic width) in this parameter, but some fields became very long, and even if field is not very long, it still much longer than length of data. Is it bug or feature, and how can this be fixed?

10163 posts

ansgar posted 16 years ago

Would it be an option for you to set the preference value to let's say 120 or so (before we call it a bug:))?

4 posts

[expired user #3398] posted 16 years ago

Hi anse,

I have the same problem.
If I change the value to 0, many columns are displayed very long. Also if the cells are empty in all rows.

If I change it to eg. 120 the "empty" columns are also Displayed so long.

I hope you unterstand my problem ;)

Isn't there any possibility to size the columns depanding on the data?
long data -> big field, no/short data -> small field.

8 posts

[expired user #3652] posted 16 years ago

Hi guys,

I have been using HeidiSQL for about 3-4 months now and find it very easy to use. Great tool to have around.

One problem I have come across is the same as the users who have posted before me.

Was curious is it possible to have a setting which will either adapt to the field name size or/and field text, the lower of the two will be selected as the width?

This way if there is no data in the field it will just display the width of the field, and if there is data you will need to either hover over it to see the full size of the data.

Thanks.

10163 posts

ansgar posted 16 years ago

Good idea, really, very creative. However, that would slow down the process of displaying data significantly as we will have to check the length of *each* cell in *each* row while creating the columns. Even cells which are not yet fetched must be checked which is not possible I'd say as we're fetching chunks of data on demand as you scroll down a huge table.

Did you know
- the columns keep their resized state when refreshing data and
- that they now support autosizing on doubleclicking the border between two columns
in the latest builds? That's not exactly what you meant but probably it helps a bit.

10163 posts

ansgar posted 16 years ago

I think what is most annoying here is that numeric columns take too much space. VirtualTree has an easy way to implement an autosized column depending on its datatype, how's that idea?

8 posts

[expired user #3652] posted 16 years ago

I think what is most annoying here is that numeric columns take too much space. VirtualTree has an easy way to implement an autosized column depending on its datatype, how's that idea?

How about loading the table data, and then autosizing the columns then? Looking at whats smaller perhaps (?) or maybe just making it the width of the field names?

10163 posts

ansgar posted 16 years ago

How about loading the table data, and then autosizing the columns then?

That implies that the complete data gets loaded at the beginning, which wouldn't be a good idea for my 55 gb laws table smile

Or did you mean that we only use the visible fields for autosizing? Would be odd I think.

8 posts

[expired user #3652] posted 16 years ago

How about loading the table data, and then autosizing the columns then?

That implies that the complete data gets loaded at the beginning, which wouldn't be a good idea for my 55 gb laws tableOr did you mean that we only use the visible fields for autosizing? Would be odd I think.

Well I guess that could be a problem. How about just making an option where the field names will determine the default width of the columns? This would be less problematic?

10163 posts

ansgar posted 16 years ago

Related change: http://changes.heidisql.com/1712

8 posts

[expired user #3652] posted 16 years ago

Related change: http://changes.heidisql.com/1712[/quote:a2a657e88c]

What does the value have to be set to for it to automatically do this? I can't seem to set it to 0?

10163 posts

ansgar posted 16 years ago

Misunderstanding, sorry: r1712 didn't fullfill this request, it was just a related change, possibly of interest here.

I wouldn't say we should do this resizing automatically when the preference value of "Maximum column width..." is set to "0" or?

8 posts

[expired user #3652] posted 16 years ago

Misunderstanding, sorry: r1712 didn't fullfill this request, it was just a related change, possibly of interest here.

I wouldn't say we should do this resizing automatically when the preference value of "Maximum column width..." is set to "0" or?

Well if "0" sets the default which is a reasonable size then I guess no need for it.

Can the column header sizes be saved, that way once you create a new table you can fix the widths of each column yourself and they will be saved? Maybe even have an option under "Columns" with "Save header size"? Or per column widths?

10163 posts

ansgar posted 16 years ago

Thanks a lot for the idea. Posted as rfe 732

8 posts

[expired user #3652] posted 16 years ago

Not a problem. :)

10163 posts

ansgar posted 16 years ago

Try it out - nightly build of r1776 and following fixes should avoid some annoyance from now on.

8 posts

[expired user #3652] posted 16 years ago

Try it out - nightly build of r1776 and following fixes should avoid some annoyance from now on.

seems to work for now ;)