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, [EMAIL PROTECTED]
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
