CODEWITHSUNDEEP
sqlsqlite
mRhNs13
mRhNs13

Reputation: 479

Unable to insert query with special characters in sqllite

I have tried to insert rows with special characters in sqllite db. The query is as follows: 

  Insert into table "abc"("id","Name")values ('2','*!@%^#~_(EEEWEEee,><|}{)^$#@?/.')

It shows the error as unrecognized token. But in SQL server alone it gets inserted. Please let me know is there any solution. Thanks in advance.

Upvotes: 0

Views: 145

Answers (1)

Thomas G
Thomas G

Reputation: 10216

Your query should not contain table after into

This will work fine (I just tested it on SQLite)

 Insert into "abc"("id","Name")values ('2','*!@%^#~_(EEEWEEee,><|}{)^$#@?/.')

Results :

SELECT * FROM "abc";

id  name
2   *!@%^#~_(EEEWEEee,><|}{)^$#@?/.

Upvotes: 2

Related Questions