Inserting / updating bit columns in MS SQL
When I open the table, the data in that column is displayed as 0s and 1s. That's fine.
When I edit or add a record, I enter the field's value as 0 or 1. When I post the changes (ctrl+Enter) the field suddenly shows the field value as True or False (sometimes with a comma as if the characters are digits and needs to be split up in thousands).
When I hit F5 to refresh the table, it shows as 0s and 1s again.
It's only a display issue, but it is quite weird to see.
Please login to leave a reply, or register at first.