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.

Queries Being Built Incorrectly

RugerSR9's profile image RugerSR9 posted 10 months ago in General Permalink

HeidiSQL is building queries incorrectly resulting in / SQL Error (102): Incorrect syntax near '0'. /.

Example: "EmailConfirmed"=b'0' AND "LockoutEnabled"=b'1'

Not sure why there are "b"'s after the equal sign, but it puts them there anytime the field is of type BIT.

I started having issues yesterday, updated to 10.1.0.5559 but that didn't solve the issue.

ansgar's profile image ansgar posted 9 months ago Permalink

Which server version and type is it?

RugerSR9's profile image RugerSR9 posted 9 months ago Permalink

SQL Server and 2012 (I believe), will confirm on Monday.

ansgar's profile image ansgar posted 9 months ago Permalink

That b'' notation is working for MySQL and MariaDB, but I suppose not for MSSQL and neither PostgreSQL. You should search the bug tracker for a relevant issue report, and star this issue then.

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