striping out special character from the mysql database

[dinesh1985singh]

Hello Everyone,

In my database I found few special character,these special character were get stored even after using proper function for striping out these character,like mysql_real_esca pe function in php.
I found these characters in my database

Sipsâ„¢ should be Sips™

There’s should be There’s
Rosé: should be Rosé:
’ should be '

I want to use original characters (like instead of There’s I want to display There’s) .



Please help me out in this regard.

Thanks

[code green]

mysql_real_esca pe function doesnt strip anything out.
It escapes some characters so that SQL will ignore them as commands.
The characters you mention are perfectly legal characters.
European and symbols maybe.
This is something that needs to be handled by the front end.