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 1 year 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 1 year ago Permalink

Which server version and type is it?

RugerSR9's profile image RugerSR9 posted 1 year ago Permalink

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

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.
ansgar's profile image ansgar posted 1 year 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.

web3dprint's profile image web3dprint posted 1 month ago Permalink

Which would be issue #264 on github HeidiSQL/HeidiSQL

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




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.