Re: Insert Symbol into Mysql

Ashley Sheridan <ash@xxxxxxxxxxxxxxxxxxxx> · Wed, 16 Sep 2009 12:41:55 +0100



On Wed, 2009-09-16 at 17:00 +0530, Samrat Kar wrote:
> I want to insert symbols like degree, plusminus, currency along with string
> into Mysql database. Front is HTML form with javascript. Server side scripts
> are written in PHP. Please help.
> 
>  
> 
> Regards,
> 
>  
> 
> Samrat Kar
> 
Two ways to do this:

     1. Insert the characters as their escaped HTML codes, e.g. &#176;
        &#177; &#163; (for °, ± and £)
     2. Set the DB to use a utf8 character set, and insert the
        characters directly as is, without escaping them

Thanks,
Ash
http://www.ashleysheridan.co.uk


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php