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.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
