Thread

  1. Apostrophes et al in a files with text attribute

    Michael <wwwadmin@wizard.ca> — 1998-05-15T13:08:56Z

    I have passed text via a Perl CGI to my database, and tried storing text
    
    into a field with the text attribute.  Only problem is if there is an
    apostrophe in the string as in the word "can't"
    it will not INSERT.... hmm... isn't "isn't" text?
    
    hehehe.. anyways, what is the usual work around?
    
    
    
    
    
    
  2. Re: [GENERAL] Apostrophes et al in a files with text attribute

    Marc G. Fournier <scrappy@hub.org> — 1998-05-15T13:51:45Z

    On Fri, 15 May 1998, The Web Administrator wrote:
    
    > I have passed text via a Perl CGI to my database, and tried storing text
    > 
    > into a field with the text attribute.  Only problem is if there is an
    > apostrophe in the string as in the word "can't"
    > it will not INSERT.... hmm... isn't "isn't" text?
    > 
    > hehehe.. anyways, what is the usual work around?
    
    escape it with a \ and it will work...