#25 Posting UTF8 fails to write to database
After creating the ticket am trying to update it and posting UTF8 encoded national characters - tried many european, russian or chiness.
UPDATE tbl_Issues SET contact='',solution='',location='',
dell_project_id='',
dell_part_number='',
dell_manufacturer='',
dell_manufacturer_part_number='',
dell_customer='[Dell Customer name]',
dell_customer_number='[Dell Customer number]',
dell_si_number='[SI Number]',
dell_cost_centre='[Cost centre]',
dell_vertical_segment='[Vertical Segment]',
summary='TEST',description='TEST- п�иве� ',
detail=0,category=0,priority=1,status=1,level=1 WHERE id=120
CentOS 5.3
postgresql-8.1.11-1.el5_1.1
LANG=en_US.UTF-8
DB and Tables created with UTF8 encoding
Tried moving to MDB2 and using SetCharset - generally works fine but with the same unicode result, error as above.
solution is as follows:
Replace anything that looks like this:
$_POST[$key2][$val2] = addslashes(htmlentities(strip_tags($val2, '<a>'), ENT_QUOTES));
With this:
$_POST[$key2][$val2] = addslashes(htmlentities(strip_tags($val2, '<a>'), ENT_QUOTES, 'UTF-8'));
This works - now can do whatever chars tested with Russian, Korean and Chinese