|  | Posted by Joγo Morais on 06/12/02 12:01 
> I think it is easier to store the text raw in the db, and when> displaying it in a browser, use htmlentities.
 
 But in this case, should I use iso-8859-1 collation?
 
 Hmm what If I have a site that's visited by users with different
 nationalities and they insert text into database with different
 language charsets?
 
 
 > (Of course, make sure you escape the text before inserting to avoid SQL
 > injection, eg via mysql_real_escape.)
 Thanks for the tip, but my doubt here has nothing to do with
 security. :)
 
 
 > In my opinion that is the cleanest way to store data, and you can also
 > use the data for other purposes, eg searching without having to worry
 > about changed characters because of the htmlentities.
 Thanks for your opinion mate.
  Navigation: [Reply to this message] |