Re: entering Chr(13) & Chr(10) in insert & update

[Stefan Hinz, iConnect \(Berlin\)]

Kayamboo,

>    Is there any way I can insert Chr(13) & Chr(10) along with string
> characters in a blob field  using *insert* or *update* statements.

You can insert these values (CR/LF) just like any other character, but
you have to make sure they have been escaped properly. If you're using
some smart language on the application side (like PHP), it will probably
do this automatically. Otherwise, you will have to use something like
the QUOTE() function, which you can find here:
http://www.mysql.com/documentation/mysql/bychapter/index.html#String_fun
ctions

Regards,
--
  Stefan Hinz <[EMAIL PROTECTED]>
  Geschaftsfuhrer / CEO iConnect GmbH <http://iConnect.de>
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

----- Original Message -----
From: "kayamboo" <[EMAIL PROTECTED]>
To: "list mysql" <[EMAIL PROTECTED]>
Sent: Wednesday, December 25, 2002 7:59 AM
Subject: entering Chr(13) & Chr(10) in insert & update


> mysql, query, sql
>
> Hello folks
>
>    Is there any way I can insert Chr(13) & Chr(10) along with string
> characters in a blob field  using *insert* or *update* statements.
>
>
>
> Thanks for any suggestions
>
> KayambooSuresh
>
>
> ---------------------------------------------------------------------
> 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
>


---------------------------------------------------------------------
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