Re: convert special characters.

[Karl DeSaulniers <karl@xxxxxxxxxxxxxxx>]

On Aug 9, 2012, at 5:37 AM, Karl DeSaulniers wrote:

> Help!
>
> How do I get special characters to convert correctly when inserting  
> and reading from my database.
> For example.
>
> é => é
> ë => ë
>
> I keep getting
>
> ë and é
>
> using htmlentities, htmlspecialchars, etc...
>
> Any pointers? Please!
> Going bald over here.
>
> here is my funcitons
>
> function stringToMysqlFormat($original_input) {
>               //for inserting the data with special characters INTO  
> mysql
>               $html_encoded =  
> htmlentities(mysql_real_escape_string($original_input));
>               return $html_encoded;
> }
> function mysqlToHTMLFormat($encoded) {
>               //for displaying the data FROM mysql
>               $html_decoded =  
> html_entity_decode(stripslashes($encoded));
>               return $html_decoded;
> }
>
> TIA,
>
> Karl DeSaulniers
> Design Drumm
> http://designdrumm.com


using UTF-8


Karl DeSaulniers
Design Drumm
http://designdrumm.com


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php