VVM Ravikumar Sarma Chengalvala writes:
> Hi Sinisa,
>
> Thanks for spending the time.Here are few observations
> on mysql_escape_string().I have checked it up and
> found to be working but with the following problems.
> i)
> It works well when I want to insert strings like:
> "'xyz" or "x'yz".
> ii)
> When I use "x\yz" with the function I see a junk
> character appearing like "x(junt char)yz" in mysql
> console window and as "x|yz" in GUI window.
> Please note that the line shown ablove appears as a
> thick line.
> iii)
> If I want to store something like"\x\yz",it even
> ignores the first backslash.
> iv)
> This happens when I pass it through the
> function.Otherwise if I send something like"\\x\\yz"
> directly without going through the function then it
> stores it as "\x\yz".
> v)
> This is the problem with the function itself or shall
> I have to do something else.
> Regards,
> Ravi
>
Hi!
Depends what you mean by "appearing" in mysql window or in GUI window.
If you use the above function, then the only place it should appear is
in your program.
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
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
