Re: Backslash NOT being stored

I tested here with your syntax on MySQL 4.0.12 using the mysql command line
interface.  Using SELECT to display the info, shows the backslash.  What
version of MySQL are you using?  What interface are you using to display the
data in MySQL?   If it is something like MySQL Front, it could be that the
display program is the one with the problem.

John

----- Original Message ----- 
From: "Paul McNeil" <[email protected]>
To: <[email protected]>
Sent: Friday, April 09, 2004 4:16 AM
Subject: Backslash NOT being stored


> Good day.  If I do the following...
> INSERT INTO myTable (data) VALUES('Here is a backslash \ ');
>
> I escape it prior to sending so the value that gets sent to the DB is....
> INSERT INTO myTable (data) VALUES('Here is a backslash \\ ');
>
> BUT when I check the DB the data field reads
> [Here is a backslash ]
>
> It eats the single backslash.
>
> How can I prevent this?
>
> Thank you.
> Paul C. McNeil
> Developer in Java, MS-SQL, MySQL, and web technologies.
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> GOD BLESS AMERICA!
> To God Be The Glory!
>
> -- 
> MySQL Bugs Mailing List
> For list archives: http://lists.mysql.com/bugs
> To unsubscribe:
http://lists.mysql.com/[email protected]
>
>


-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]