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
