Received: from rm-rstar.sfu.ca (root@rm-rstar.sfu.ca [142.58.120.21]) by hub.org (8.9.3/8.9.3) with ESMTP id QAA31851 for ; Fri, 7 May 1999 16:19:28 -0400 (EDT) (envelope-from gburnham@sfu.ca) Received: from apemantus (apemantus.educ.sfu.ca [142.58.6.61]) by rm-rstar.sfu.ca (8.9.1/8.9.1/SFU-5.0H) with SMTP id NAA27134; Fri, 7 May 1999 13:16:03 -0700 (PDT) Message-ID: <011201be98c6$8861a600$3d063a8e@educ.sfu.ca> From: "Gregory W Burnham" To: "Henk Jan Barendregt" , References: <373346BF.15166AB9@barendregt.xs4all.nl> Subject: Re: [INTERFACES] How to store ' Date: Fri, 7 May 1999 13:16:46 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2014.211 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211 You can store the single quote if you escape it first: This\'s a string that will work Gregory W Burnham Software Engineer / Systems Administrator Excite Labs Simon Fraser University Vancouver, BC V5A 1S6 604 291 3615 ph 604 291 5679 fx ----- Original Message ----- From: Henk Jan Barendregt To: Sent: Friday, May 07, 1999 1:02 PM Subject: [INTERFACES] How to store ' > > Hello, > > Is there a way to store a string with the ' character in it ? > I have to import a database with a lot of strings containing the ' > character. > If it is not possible i should write a script to replace them with a ` > char. > > Thanks in advance, > > Henk Jan > >