insert a uuid:string '0Xcd...' -> 1/logic-error near "0Xcd" , syntax error
hello, table objekt ( id varchar(64) , .. ) query 'insert into objekt(id,nu,na,ty,kz,tw,fu,ar,cr,er,gr,hr,kr,lr,rr,tr,ur) values('0XcdxC8pn9k93uig42TqAP',5205,'','MSR-Verteiler: MSR 3',0,0,'',81,0,1,1,0,11,1,21,6,0);' ERROR check.prepare (1/SQL logic error) 'near "0Xcd": syntax error' error-message: (result/sqlite3_errstr(result)) + sqlite3_errmsg(handle) thanks in advance, andreas this time, i found the mistake myself. but thanks for help in recent days.
Unable to reproduce the problem. Please send the complete text of the SQL that you are trying to evaluate.
(3) By doug (doug9forester) on 2020-11-09 15:38:36 in reply to 1.1 [link] [source]
I find it strange that the query string reuses the single quote. No parser could handle this:
What's up with that? Do you need to escape single quotes within your query quoted string?
(4) By Larry Brasfield (LarryBrasfield) on 2020-11-09 15:46:36 in reply to 3 [source]
Yes, they are escaped with a single quote per escaped single quote.
hi, thanks for your answers. the error was caused by another query. i did not think twice. my strings came from another source, already single-quoted, so " .. where id=''uuidstring'';" was the actual mistake.
if you want to say that 'a 'b' c' does not work. this is actually "a 'b' c". the outer single quotes from my simple printf-debugging. i know about "'" and '"'. but if you think of something different, i would like to know.