List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 24 2001 1:20am
Subject:Re: Special Characters in INSERT Statement
View as plain text  
At 5:30 PM -0500 3/23/01, Lee Jenkins wrote:
>I apologize because I know I've seen this somewhere on the list before
>(should have saved it).  I'm trying to insert some data into CHAR fields
>that have trailing Ascii 0 characters, but get a syntax error.
>The data would like this:
>Where "X" represents the ascii character 0.

Escape them using \0.

>INSERT INTO MyTable (ThisNumber) VALUES
>...Creates the syntax error.
>Any help would be appreciated.
>Lee Jenkins

Paul DuBois, paul@stripped
Special Characters in INSERT StatementLee Jenkins23 Mar
  • Re: Special Characters in INSERT StatementPaul DuBois24 Mar