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
does JavaScript use the proper way to encode strings as encodeURIComponent is, and for each sent key/value pair? Is MySQL table charset ut8_general_ci ? If not, do you convert sent UTF-8 charset into table charset? In few words we miss the way/library used to send data, the default PHP charset,