PHP, MySQL and UTF-8?

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!news.musoftware.de!wum.musoftware.de!fu-berlin.de!uni-berlin.de!not-for-mail
From	Robert Latest <boblatest@yahoo.com>
Newsgroups	comp.lang.php
Subject	PHP, MySQL and UTF-8?
Date	12 Sep 2011 16:46:13 GMT
Lines	23
Message-ID	<9d6ralFrpkU1@mid.uni-berlin.de> (permalink)
X-Trace	news.uni-berlin.de HJQadOQDNlD31TUPji3DSAsG2KmG0+5kXs1IqWpknjPFwrt0s=
User-Agent	slrn/pre1.0.0-18 (Linux)
Xref	x330-a1.tempe.blueboxinc.net comp.lang.php:3128

Show key headers only | View raw

Hello all,

I have UTF-8 characters in my database. They're there, I can see them in
a MySQL dump as well as in phpmyadmin.

When I retrieve this data from the db and output it via print(), all I get
is question marks. These come from the server because I see them also in
wget's output.

In phpmyadmin I see the correct characters in my db. When I insert them
literally in my HTML they come out as expected. When I print() them as string
literals in php, they come out correctly as well.

I think I'm opening the db correctly:

$c = new PDO("mysql:host=$host;dbname=$dbname;port=$port;charset=UTF-8",
            $user, $pass);

So ... how do I retrieve UTF-8 chars from a database?

Thanks

robert

Back to comp.lang.php | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

PHP, MySQL and UTF-8? Robert Latest <boblatest@yahoo.com> - 2011-09-12 16:46 +0000
  Re: PHP, MySQL and UTF-8? Jerry Stuckle <jstucklex@attglobal.net> - 2011-09-12 15:30 -0400
  Re: PHP, MySQL and UTF-8? "Peter H. Coffin" <hellsop@ninehells.com> - 2011-09-12 14:31 -0500
    Re: PHP, MySQL and UTF-8? "A" <a@a.a> - 2011-09-12 22:27 +0200
  Re: PHP, MySQL and UTF-8? Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2011-09-13 16:53 +0200

csiph-web