Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Inserting / updating bit columns in MS SQL

igitur's profile image igitur posted 5 years ago in General Permalink
I have a table with a boolean/bit column.

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.