Daya,
Wednesday, November 13, 2002, 7:51:53 AM, you wrote:
DKD> Can naybody tell me how do i ignore special character while insering in
DKD> mysql database. For example while i m inserting string 'dk\bd\r' it takes \b
DKD> and \r as diffenrent character, although i can ignore it with one more
DKD> escape character like this 'dk\\bd\\r'. Field type is Text. Is there any
DKD> other way to do this.
Special characters must be escaped, you can do it with functions in
programming languages like addslashes() in PHP; since 4.0.3 you can
use QUOTE() function in MySQL:
http://www.mysql.com/doc/en/String_functions.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
