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: 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 -- 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