Re: HTML in MySQL?

[gerald_clark]

Vladimir B. Tsarkov wrote:

>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.
>
>  
>
But once you have done that, you can never recover the origional text.
Try it on this email if you doubt it.