1. Connect to MySQL DB and expand it's node.
2. Rightclick "Tables" node and choose "Create Table".
3. Add table with 1 columns with BIT type and some values with "Insert Record" dialog.
4. Rightclick added table and choose "View Data".
Result: Data is shown as checkbox.
5. Click some cell.
Result: Checkbox becomes string "true" or "false".
Agree, what you think will be better, string "true", "false" or checkbox?
Actually I'm not sure that all these values are appropriated.
Please correct me if I'm wrong, but I read here that BIT value isn't the same as BOOL in MySQL:
It should be 1 or 0 - that's what a BIT is, it's not a boolean, which is what a checkbox or "true"/"false" implies.
ahimanikya, can You take a look at this issue? This issue is P3, but it looks like presented functionality doesn't work
well and therefore this issue is going to be included into NetBeans 6.5 Patch 1.
Please fix it till 27 November (this is code freeze date for Patch 1) or update this issue with justification why the
fix isn't possible till this date.
The issue didn't pass the nomination process by nomination cut-off date. It has been marked as 65fixes2-candidate.
I went through the list of issues and found that this issue isn't fixed yet, but we found out that BIT type for MySQL it
isn't boolean, so we just have wrong appearance for this type and therefore it is P1.
Sivashankari, please look at it.
Its better we express BIT as BOOLEAN, setting value to "0" or "1" can confuse user with numeric columns.
But I agree we need to be consistent. The Bug is valid, it should turn to "true" or "false" after editing, it remain a
Verified with build 081205.
The fix has been ported into the release65_fixes repository.