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:
>
>23302220202XXXXXXXXXXXXXXXXXXXXXXXXX
>
>Where "X" represents the ascii character 0.

Escape them using \0.

http://www.mysql.com/doc/S/t/String_syntax.html


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


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