Displaying binary columns

I started using HeidiSQl a couple of days ago and I'm impressed by its speed and friendly interface. Congrats!

From my perspective, it makes no sense to treat binary columns like regular numbers and include a comma every 3-digits in the Data tab.

Is there any way to configure the default output format for the columns in the Data tab? If not, it might be useful to have such a feature.

Thanks

Sorry, I was referring to BIT columns not binary

You can disable number formatting in Tools > Preferences > Text formatting: "Local number format"

Thanks for your rapid response.

This works but it is an all-or-nothing solution.

I'd definitely suggest to exclude the BIT data type from the formatting routine. Should not be difficult. I will try to make some time and check the source code to see if I can help with this.

It's not a question of complexity. The question is: Should the BIT data type any longer be part of the "Integer" data type group? I guess it could also live in the "Other" group, together with ENUM and SET, could it?

... in that case, BIT would no longer be displayed like other numerical data types, and as such get a local formatting.

BIT data type is mostly used for masks, flags, etc. in which every bit have a different meaning thus not usually treated as a number. Consequently I would say that it would be preferable not to apply a numeric format to it.

For maximum flexibility, you could leave the user the choice about the format of BIT data (or any other).