Having different character formats PHP / Mysql

Question

On my site i'm trying to get different character support for the searches, for example hebrew so something like

אייל גולן

but the thing is, when they make the search it's stored in the database like

#1488;#1497;#1497;#1500; #1490;#1493;#1500;#1503;

What should i do? Is there any way to convert that back to readable hebrew text? or should i find a way to store in the db properly.

Thanks

If possible, you shouldn't be storing hebrew characters like that: Using UTF-8 as the database table encoding, and using native characters would be better. Why are they going into the database like that? At which point are they turned into HTML entities? — Pekka
– Pekka, Commented Apr 17, 2011 at 18:32

Revenant · Accepted Answer · 2011-04-17 20:36:54Z

2

Well, I wouldn't suggest going down to html_entity_decode(). I would use it as last solution. Make your page and database UTF-8 (character set and file if necessary).

Later if you are using any php built-in functions for html characters, make sure they allow UTF8 also.

This will make you code less and give you less headache.

edited Apr 17, 2011 at 20:36

answered Apr 17, 2011 at 19:00

Revenant

3,0147 gold badges33 silver badges55 bronze badges

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

Comments

Calum · Accepted Answer · 2011-04-17 18:33:24Z

0

html_entity_decode() could help you out.

answered Apr 17, 2011 at 18:33

Calum

5,3361 gold badge24 silver badges27 bronze badges

Collectives™ on Stack Overflow

Having different character formats PHP / Mysql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related