search

Shooter7119 / sequel-pro

Automatically exported from code.google.com/p/sequel-pro
Other
0 stars 0 forks source link

BIT(M) fields always padded to 8,16,32,64 (>= M) #1774

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
Query a database table with bit/boolean values.

What is the expected output?
1 or 0
What do you see instead?
00000001 or 00000000

What version of Sequel Pro are you using?
1.0.2
What version of OS X are you using?
10.8.4
What version of MySQL are you connecting to on the server?
Unknown, but relatively recent

Please provide any additional information below.

Original issue reported on code.google.com by goo...@jasonriley.me on 7 Aug 2013 at 5:40

GoogleCodeExporter commented 9 years ago 
BIT(1)  =                                     00000001
BIT(9)  =                            00000000 00000001
BIT(17) =                   00000000 00000000 00000001
BIT(33) = 00000000 00000000 00000000 00000000 00000001

This might be misleading and when trying to enter a value longer than M SP will 
show an error tooltip.
The padding should resemble the actual field size.

Original comment by schlabbe...@gmail.com on 7 Aug 2013 at 3:52

GoogleCodeExporter commented 9 years ago

Original comment by stuart02 on 25 Oct 2013 at 9:40