Ads were blocked by your webbrowser.

This is not a 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 2 months ago in General

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 2 months ago

Which server version and type is it?

RugerSR9's profile image RugerSR9 posted 2 months ago

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

ansgar's profile image ansgar posted 2 months ago

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.