RE: [PHP] Insert Symbol into Mysql

2009-09-16 Thread Andrea Giammarchi
> Yeah, the rules say to snip out parts of the convo which aren't > pertinent, but I know I don't exactly follow that one either! :-/ > > Thanks, > Ash > http://www.ashleysheridan.co.uk to be honest the problem is that I am in hotmail rather than gmail here, and this page is not clever as gmai

RE: [PHP] Insert Symbol into Mysql

2009-09-16 Thread Ashley Sheridan
On Wed, 2009-09-16 at 15:40 +0200, Andrea Giammarchi wrote: > > I don't recall him saying that a utf8 table was not an option or that he > > wasn't using one. > > I know 'cause he replied directly to me rather than this ML > > > > > Also, try not to top post ;) > > I usually hate scroll 'till t

RE: [PHP] Insert Symbol into Mysql

2009-09-16 Thread Andrea Giammarchi
> 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? let's say PHP could have a different charset than the one defined in that MySQL table so this is not a portable solution, specially if you do not perfe

RE: [PHP] Insert Symbol into Mysql

2009-09-16 Thread Andrea Giammarchi
> I don't recall him saying that a utf8 table was not an option or that he > wasn't using one. I know 'cause he replied directly to me rather than this ML > > Also, try not to top post ;) I usually hate scroll 'till the end to find often a single row as reply ... I'll try though > > Thanks

Re: [PHP] Insert Symbol into Mysql

2009-09-16 Thread Jo�o C�ndido de Souza Neto
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" escreveu na mensagem news:1253101315.2275.4.ca...@localhost... On Wed, 2009-09-16 at 17:00 +0530, Samrat Kar wrote: > I want to insert sy

RE: [PHP] Insert Symbol into Mysql

2009-09-16 Thread Ashley Sheridan
On Wed, 2009-09-16 at 14:47 +0200, Andrea Giammarchi wrote: > He has no utf-8 charset in the table, so the first point is valid and > htmlentities is the function ( > http://uk.php.net/manual/en/function.htmlentities.php ) > You need to remember that in this way you need to use htmlentities for

RE: [PHP] Insert Symbol into Mysql

2009-09-16 Thread Andrea Giammarchi
He has no utf-8 charset in the table, so the first point is valid and htmlentities is the function ( http://uk.php.net/manual/en/function.htmlentities.php ) You need to remember that in this way you need to use htmlentities for *everything*, specially for searches, otherwise ° against ° will b

Re: [PHP] Insert Symbol into Mysql

2009-09-16 Thread Ashley Sheridan
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 way

RE: [PHP] Insert Symbol into Mysql

2009-09-16 Thread Andrea Giammarchi
, the MySQL table charset, the way you store/retrieve data into MySQL, etc etc ... we can help but we need more info > From: esam...@barc.gov.in > To: php-general@lists.php.net > Date: Wed, 16 Sep 2009 17:00:31 +0530 > Subject: [PHP] Insert Symbol into Mysql > > I want to i

[PHP] Insert Symbol into Mysql

2009-09-16 Thread Samrat Kar
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