Re: Insert Symbol into Mysql
| From: | Jo�o C�ndido de Souza Neto | Date: | Wed, 16 Sep 2009 13:16:43 +0000 |
| Subject: | Re: Insert Symbol into Mysql | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-298096@lists.php.net to get a copy of this message | ||
If he´s really using a any other charset instead of utf8 table, why not
using utf8_decode and utf8_decode in his php files to solve this?
"Ashley Sheridan" <ash@ashleysheridan.co.uk> escreveu na mensagem
news:1253101315.2275.4.camel@localhost...
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