json_encode and mysql unicode problem

Question

i have the following javascript code:

http://www.nomorepasting.com/getpaste.php?pasteid=22561

Which works fine(the makewindows function has been changed to show it is a php variable), however the html contains unicode characters, and will only be assigned characters leading up to the first unicode character. If I make a small test file and echo out article_desc directly, all the html is output, although quetsions marks are displayed instead of the correct symbols. However json_encode seems to cut short the html, resulting in errors.

edit: here is a dump straight from the mysql database of the html I am trying to display:

http://www.yousendit.com/download/TTZueEVYQzMrV3hMWEE9PQ

it says utf-8 in the source. the actual page code generated from echoing out article_desc is here:

http://www.nomorepasting.com/getpaste.php?pasteid=22566

it is definitely the same record, so I am unsure why it seems to very different.

edit: this was fixed by calling: mysql_query('SET NAMES utf8');

can you see if the unicode is correct in the database? i.e. are the question marks there or not? — Tom Haigh
– Tom Haigh, Commented Dec 8, 2008 at 14:16
From what I can tell there are no question marks in the database, but perhaps not correct unicode either. — user1253538
– user1253538, Commented Dec 9, 2008 at 12:12

troelskn · Accepted Answer · 2008-12-08 20:37:05Z

3

json_encode expects strings to be UTF-8 encoded byte streams. You'll have to either use utf-8 encoded strings internally (Which is the only current way to deal with unicode characters in PHP anyway), or use a different library for generating json.

answered Dec 8, 2008 at 20:37

troelskn

118k27 gold badges135 silver badges156 bronze badges

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

2 Comments

user1253538 Over a year ago

Is there a way to convert the data or insert it into the mysql database as unicode?

troelskn Over a year ago

You can convert latin1 strings (Which is the default for php5), using utf8_encode(). Why is it that you can't use Zend Framework components?

SandRock · Accepted Answer · 2011-02-02 10:51:24Z

2

I had the same issue. I am using Zend_Db/mysqli and my database content is actually UTF8.

I solved the problem by asking my database adapter to use UTF8:

$conf->db->params['charset'] = 'UTF8';

If you use PDO instead of mysqli, you can do it this way:

$pdoParams = array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES UTF8;');
$conf->db->params['driver_options'] = $pdoParams;

If you don't use Zend_Db but use mysqli, you might want to look at http://php.net/manual/en/mysqli.set-charset.php.

Source: http://www.zfsnippets.com/snippets/view/id/13

answered Feb 2, 2011 at 10:51

SandRock

5,6173 gold badges35 silver badges53 bronze badges

Comments

zkanoca · Accepted Answer · 2013-11-17 03:43:31Z

1

json_encode( utf8_encode( $Content ) );

This will solve your issue.

edited Nov 17, 2013 at 3:43

zkanoca

10k10 gold badges55 silver badges99 bronze badges

answered Jan 19, 2009 at 20:51

alessa

Comments

Irmantas · Accepted Answer · 2008-12-08 13:59:46Z

-1

i don't think you need json_encode. json_encode encodes PHP arrays and objects to readable JavaScript format. If you send plain text or html within ajax you don't need json_encode

answered Dec 8, 2008 at 13:59

Irmantas

3,3412 gold badges20 silver badges10 bronze badges

1 Comment

Tom Haigh Over a year ago

json_encode will also handle stuff like escaping quotes for you

Collectives™ on Stack Overflow

json_encode and mysql unicode problem

4 Answers 4

2 Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related