ansaurus

Question

Answer 1

+2 A:

Pure inserting into the database will definitely not put entities into your input. The conversion must take place somewhere else.

You should step through the whole path the data takes, and see whether there's not a htmlentities executed somewhere.

Pekka 2010-02-08 16:13:56

+1 it does look exactly like an `htmlentities()` done without passing the charset in. Use `htmlentities($string, ENT_QUOTES, 'utf-8')`, or, much simpler, just use `htmlspecialchars` instead, since that doesn't try to molest the non-ASCII characters. It's almost always the better function.

bobince 2010-02-08 16:18:15

yes it was a htmlentities() issue - thanks!

Josh 2010-02-08 16:57:41

Answer 2

A:

You will have to use the html_entity_decode function on your data while saving it to your DB. Somewhere in your code there's probably a call to htmlentities that's responsible for your conversions.

BTW: please make sure calling mysql_real_escape on your data just BEFORE inserting it into your DB (without your vulnarable like ... hell).

aefxx 2010-02-08 16:17:56

The better answer is to fix whatever is calling `htmlentities` in the first place, rather than just encoding it to be unencoded.

friedo 2010-02-08 16:30:42

ansaurus

tags:

views:

answers:

saving hebrew utf8 to database with php

related questions