[android-developers] Re: How to insert special character into Database
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
Re: [android-developers] Re: How to insert special character into Database
@ 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
[android-developers] Re: How to insert special character into Database
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
[android-developers] Re: How to insert special character into Database
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
