Re: Insert Symbol into Mysql
| From: | Ashley Sheridan | Date: | Wed, 16 Sep 2009 11:41:55 +0000 |
| Subject: | Re: Insert Symbol into Mysql | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-298093@lists.php.net to get a copy of this message | ||
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. °
± £ (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