1 turns into T,rue and 0 into fa,lse

clemenslinders's profile image clemenslinders posted 3 years ago in General Permalink

Hi,

Today I used Heidi for the first time (together with SQl server 2016).

I have a table with 3 columns Col1 (boolean) Col2 (NVarChar) Col3 (boolean)

Col 1 = 1 Col 2 = Jim Col 3 = 0

When I change Col 2 to Jimmy than Col 1 turns into T,rue and Col 3 Turns into Fa,lse

Checking with SSMS I noticed that in fact only Col 2 changed to Jimmy and there were no errors.

Refreshing the table again showed 1 and 0 for columns 1 and 3.

So it is not a big problem, but it is rather strange.

Kind regards,

Clemens Linders

Please login to leave a reply, or register at first.