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', 'MAIN ROAD', 'AAA', 'SSS', '1091',
'weqwe', 'Y')
On Sep 21, 2:44 pm, Bishan <tvbis...@gmail.com> wrote:
> @ 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', '3', '0', 'HOTEL', 'BRONZ', '4', '3',
> 'MAIN ROAD', 'AAA', 'SSS', '1091', 'weqwe', 'Y')'.
>
> On 9/21/11, Zsolt Vasvari <zvasv...@gmail.com> wrote:
>
>
>
> > 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 this group, send email to android-developers@googlegroups.com
> > To unsubscribe from this group, send email to
> > android-developers+unsubscr...@googlegroups.com
> > For more options, visit this group at
> >http://groups.google.com/group/android-developers?hl=en- Hide quoted text -
>
> - Show quoted text -
--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
