[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

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 insert symbols like degree

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 ways to do

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 #176;

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 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 a...@ashleysheridan.co.uk escreveu na mensagem news:1253101315.2275.4.ca...@localhost... On Wed, 2009-09-16 at 17:00 +0530, Samrat Kar

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 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

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 the end to

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 gmail one