search

sqlpage / SQLPage

Fast SQL-only data application builder. Automatically build a UI on top of SQL queries.
https://sql-page.com
MIT License
1.66k stars 99 forks source link

Values of type `bit` are decoded as strings instead of booleans in Microsoft SQL server #666

Closed lovasoa closed 3 weeks ago

lovasoa commented 3 weeks ago

@lovasoa However, a new issue has arisen: the value of the bit type is incorrect.

select top 2 * from [ZrAdmin].[dbo].[sys_role];;
select 'test测试' as LogLevel;
select CAST('test测试' as varchar(100)) as LogLevel;

select CAST(1 as bit) as menu_check_strictly;
select CAST(0 as bit) as menu_check_strictly;

image image image image

Originally posted by @BlueHtml in https://github.com/sqlpage/SQLPage/issues/662#issuecomment-2452905163

lovasoa commented 3 weeks ago

@BlueHtml , I fixed this too. Here is a new preview build: https://we.tl/t-F9BvjGElcQ

BlueHtml commented 3 weeks ago

@lovasoa The execution result of this preview build is normal. image