Re: Special Characters in INSERT Statement

[Paul DuBois <paul@xxxxxxxxx>]

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@xxxxxxxxx

---------------------------------------------------------------------
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread69378@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php