Re: HTML in MySQL? Date: Fri, 9 Sep 2005 23:28:22 +0400

Hello!

> Be careful here Vladimir, the (\n) are not 'null' characters; but newline
> characters.  

Agree, I was wrong.

> And i would highly recommend *not* replacing them with <br> 
> tags as you write them into the database.  This is asking for trouble on
> so many levels.
>
> The database will cope with carriage returns and newlines just like any
> other character, so will have no problems.
>
> HTML is just string; treat it as such and don't give it anymore credit
> than that and you'll be fine.

If you need to output a HTML string (not in a textarea field), you'll need 
to replace "\n" with "<br>". That is why, I think that it is better to 
replace it before saving (You will not need to replace "\n" during the output 
process. It will save you some lines of code, and add productivity.). Of 
course, you need to be sure that your program will make HTML output more 
often, than any other type of output.

-- 
Удачи!
Владимир

Please, avoid sending me Word or PowerPoint attachments.
See http://www.gnu.org/philosophy/no-word-attachments.html