Re: [sqlite] Insert with an '

2018-06-11 Thread John McKown
Very good point. I think that everyone should do it that way. It is a bit more work, but is vastly superior. On Mon, Jun 11, 2018, 03:23 Olivier Mascia wrote: > > Le 11 juin 2018 à 10:07, Peter Nacken a écrit : > > > > I try to insert email addresses into a table and get an error with > address

Re: [sqlite] Insert with an '

2018-06-11 Thread Richard Damon
On 6/11/18 4:23 AM, Olivier Mascia wrote: >> Le 11 juin 2018 à 10:07, Peter Nacken a écrit : >> >> I try to insert email addresses into a table and get an error with addresses >> they have a single quotation mark ( na'm...@domain.ltd ). >> Sorry I forgot I‘m using C# > (Assuming: "create table T(

Re: [sqlite] Insert with an '

2018-06-11 Thread Peter Nacken
Dear all, Thanks for your help. It works ! Peter > Am 11.06.2018 um 11:14 schrieb Tim Streater : > >> On 11 Jun 2018, at 09:07, Peter Nacken wrote: >> >> I try to insert email addresses into a table and get an error with addresses >> they have a single quotation mark ( na'm...@domain.ltd ).

Re: [sqlite] Insert with an '

2018-06-11 Thread Tim Streater
On 11 Jun 2018, at 09:07, Peter Nacken wrote: > I try to insert email addresses into a table and get an error with addresses > they have a single quotation mark ( na'm...@domain.ltd ). > > Sorry I'm facing this problem for weeks, I can't find a solution. > > Is there a known workaround for it ?

Re: [sqlite] Insert with an '

2018-06-11 Thread Olivier Mascia
> Le 11 juin 2018 à 10:07, Peter Nacken a écrit : > > I try to insert email addresses into a table and get an error with addresses > they have a single quotation mark ( na'm...@domain.ltd ). > Sorry I forgot I‘m using C# (Assuming: "create table T(E text);" for the following.) If you're build

Re: [sqlite] Insert with an '

2018-06-11 Thread Simon Slavin
On 11 Jun 2018, at 9:07am, Peter Nacken wrote: > I try to insert email addresses into a table and get an error with addresses > they have a single quotation mark ( na'm...@domain.ltd ). > > Sorry I'm facing this problem for weeks, I can't find a solution. Every single ' character in a strin

Re: [sqlite] Insert with an '

2018-06-11 Thread Peter Nacken
Sorry I forgot I‘m using C# > Am 11.06.2018 um 10:07 schrieb Peter Nacken : > > Hi, > > I'm new in SQLite. > > I try to insert email addresses into a table and get an error with addresses > they have a single quotation mark ( na'm...@domain.ltd ). > > Sorry I'm facing this problem for weeks

[sqlite] Insert with an '

2018-06-11 Thread Peter Nacken
Hi, I'm new in SQLite. I try to insert email addresses into a table and get an error with addresses they have a single quotation mark ( na'm...@domain.ltd ). Sorry I'm facing this problem for weeks, I can't find a solution. Is there a known workaround for it ? Thanks for help Peter ___