How do you know that the "error" is related to the use of a caret?
Perhaps your .net wrapper is diddling text strings that contain carets for some reason known only to the wrapper writer? Have you checked the wrapper documentation to see if such diddling is documented, and if so, how to turn it off? And where do you get the idea that a caret in a string is a "filter or so"? -- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-----Original Message----- >From: sqlite-users <sqlite-users-boun...@mailinglists.sqlite.org> On >Behalf Of André Borchert >Sent: Saturday, 5 October, 2019 22:56 >To: sqlite-users@mailinglists.sqlite.org >Subject: [sqlite] Error 19 with Caret ^ INSERT > >Hello, > >in my C# program which uses DllImport for sqlite.dll (3.29) I get Error >19 (SQLITE_CONSTRAINT) with this statement: > >INSERT INTO CompanyDetails (RIC) VALUES('AMBEUR.IP^G19') > >The ^ symbol is part of the text I want to save, its not a filter or so, >its just plain text. > >The odd thing is that the sql statement works just fine when I use DB >Browser for SQLite. >The row looks like expected, with the ^ character saved as text. > >Sent with [ProtonMail](https://protonmail.com) Secure Email. >_______________________________________________ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users