Hi Niels, You've just found the first problem with using TEXT columns. What you need to do is put another ' in front of it i.e. ''. Depending on the language you are using, you may find it includes a function that "escapes" special characters like '. For example, PHP supply "sqlite_escape_string".
The alternative is to store the data as binary. To do this, I believe you need to do the prepare/bind/exec statements. Hope that some help. Regards Nick -----Original Message----- From: Niels Boldt [mailto:[EMAIL PROTECTED] Sent: 28 February 2006 10:26 To: [email protected] Subject: [sqlite] Problems with character ' *** WARNING *** This mail has originated outside your organization, either from an external partner or the Global Internet. Keep this in mind if you answer this message. Hi Guys I'm having some problems dealing with the character '. Sqlite thinks fair enough that it should terminate the string, which I would like it to avoid. Are there any solutions to my problems. Thanks, Niels ******************************************************************** This email and any attachments are confidential to the intended recipient and may also be privileged. If you are not the intended recipient please delete it from your system and notify the sender. You should not copy it or use it for any purpose nor disclose or distribute its contents to any other person. ********************************************************************
