It's all Unicode, all characters are created equal.
On Sep 21, 1:38 pm, Bishan tvbis...@gmail.com wrote:
How to insert ' character or special character into Database using sqlite ?
--
You received this message because you are subscribed to the Google
Groups Android Developers group.
To post to
@ Zsolt
no. i got this error.
09-21 12:07:26.876: INFO/Database(19855): sqlite returned: error code
= 1, msg = near S: syntax error
09-21 12:07:26.876: ERROR/Database(19855): Failure 1 (near S: syntax
error) on 0x2ae178 when preparing 'INSERT INTO Client VALUES
('110003', 'MITHUL'S ', 'R1',
Are you using the helper methods to create the insert statement, or
are you building it yourself? If you do it yourself, you must escape
the single quote as double quoutes, so your statement should be:
INSERT INTO Client VALUES ('110003', 'MITHUL''S ', 'R1', '3', '0',
'HOTEL', 'BRONZ', '4', '3',
One hint: MITHUL'S
http://www.sqlite.org/faq.html#q14
Or .. you know .. you could stop doing hardcoded queries and use the
supporting functionality present in Android.
On Sep 21, 8:44 am, Bishan tvbis...@gmail.com wrote:
@ Zsolt
no. i got this error.
09-21 12:07:26.876:
4 matches
Mail list logo