How to save a string in a sqlite database having adjcent ' ' in it through C#

Question

I have a string Hi''Hello'''How r u''' that I want to save in sqlite database through C#. when I try doing that it throws the Exception

I have tried all the solutions currently present but still it is not working.

What is the exception? What is your code? Could you please be more specific? — Soner Gönül, Jun 09 '14 at 05:57
SQL logic error or missing database near "sdddfsdf": syntax error for this string ndjnjs'''''sdddfsdf'''''sdcdsdc'''' — Sourabh, Jun 09 '14 at 06:06
`create table t (s varchar2); insert into t values ("Hi''Hello'''How r u'''")';` — Mike Woodhouse, Jun 09 '14 at 07:52

Aman · Answer 1 · 2014-06-09T07:40:41.697

0

Hi''Hello'''How r u''' you will see there are multiple Single quote (') so please replace' by ''. Like as 'Hi''Hello''How r u''' it will work.

for ex. create data table

sqlite> CREATE TABLE COMPANY(
   ID INT PRIMARY KEY     NOT NULL,
   NAME           TEXT    NOT NULL,
   AGE            INT     NOT NULL,
   ADDRESS        CHAR(50),
   SALARY         REAL
);

insert value >

INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (1, 'Paul', 32,'California ', 20000.00 )

OR

INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (1, 'Paul', 32, 'California "and" Japan ', 20000.00 )

OR

 INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY)
    VALUES (1, 'Paul', 32, 'California ''and'' Japan ', 20000.00 )

it will insert but if you will try to insert

INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (1, 'Paul', 32, 'California 'and' Japan ', 20000.00 )

it will break SQl query syntax near 'and' and show error . So remove ' quote or replace ' by ' '.

edited Jun 09 '14 at 07:40

answered Jun 09 '14 at 06:09

Aman

2,196
2
17
19

put your complete insert query also if still you are facing error. – Aman Jun 09 '14 at 06:10
But it will change my original string and I want to keep that as it is – Sourabh Jun 09 '14 at 07:21
you will have to replace `'` by `''` it is a solution. you can not insert single `'` inside the string. – Aman Jun 09 '14 at 07:28
I tried that but it is not working for adjacent single quotes – Sourabh Jun 09 '14 at 07:30
put your insert query here with string which you want to insert – Aman Jun 09 '14 at 07:31
`insert into xyz(id, Message) values(1,'Hi''Hello''How r u''')` it will work. – Aman Jun 09 '14 at 07:33
'''''sdddfsdf''''' add single `'` after and before this string or remove single `'` from both sides. – Aman Jun 09 '14 at 07:39
update chart set ChartName='" + chart.ChartName + "' where ChartId='" + chart.ChartID + "'"; – Sourabh Jun 09 '14 at 08:40

How to save a string in a sqlite database having adjcent ' ' in it through C#

1 Answers1