PHP 5.2.17; html_entity_decode - Character decoding issue

Question

So guys im facing a terrible problem that is taking my pacience to solve.

I made a two functions, one to encode data colleted from a wysiwyg editor to send it to a mysql database (the table charset im working with is UTF-8) and other to do the reverse way (Database to wysiwyg), as you can see below.

function displayTextWithTags($textToBeDisplayed) {
    return html_entity_decode(html_entity_decode($textToBeDisplayed));
}

function sendTextToDatabase($text){
    return trim(htmlentities(htmlentities($text, ENT_QUOTES)));
}

It works very well in my development server, which is running a php 5.4.4, but when i upload my application to the my client's server (running php 5.2.7), the decoding does not work properly...

For example, if i send a &\Eacute;&\eacute; (I placed a \ so you can read the code) to the database i'll get a Éé when im retriving it in my development server and a �?é when im retriving it from the client's server.

I've been lurking stack for hours to find an answer for my problem but i did not succeed, so im begging you for help.

The Wavelength · Accepted Answer · 2012-10-19 15:09:39Z

1

I'd suggest using base64_encode and base64_decode. That should solve any problems.

answered Oct 19, 2012 at 15:09

The Wavelength

2,9342 gold badges27 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user1759677 Over a year ago

Thanks for the suggestion but my boss wants that the data stored in the data base is human readable... So i must find another workaround..

Community · Accepted Answer · 2017-05-23 12:06:21Z

0

I had this problem before but I use ADODB database wrapper. For it I had to use this:

 $db->EXECUTE("set names 'utf8'");

Not sure is you are using a database wrapper class but basically you need to set your schema names to utf8. HERE is an example.

edited May 23, 2017 at 12:06

CommunityBot

11 silver badge

answered Oct 19, 2012 at 15:09

nathan hayfield

2,7051 gold badge20 silver badges29 bronze badges

1 Comment

user1759677 Over a year ago

Yes, i use a wrapper class with and i use the command that you suggested, but thanks for answering.

Niels B. · Accepted Answer · 2012-10-19 15:14:53Z

0

I think we need some clarification here. What do you mean by "retrieving"? I assume you mean 'displayed in browser', so have you first of all checked the character encoding served by your client's webserver by looking in your http headers? It may output as ISO-8859-1.

On a side note, why are you running your entity decoding and encoding twice?

answered Oct 19, 2012 at 15:14

Niels B.

6,3704 gold badges30 silver badges45 bronze badges

Collectives™ on Stack Overflow

PHP 5.2.17; html_entity_decode - Character decoding issue

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related