FUDforum: comp.lang.php » PHP, MySQL and UTF-8?

Home » Imported messages » comp.lang.php » PHP, MySQL and UTF-8?

Show: Today's Messages :: Polls :: Message Navigator

PHP, MySQL and UTF-8? [message #175372]

Mon, 12 September 2011 16:46

Robert Latest
Messages: 1
Registered: September 2011

Karma:

Junior Member

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

Report message to a moderator

[Message index]

		PHP, MySQL and UTF-8? By: Robert Latest on Mon, 12 September 2011 16:46
		Re: PHP, MySQL and UTF-8? By: Jerry Stuckle on Mon, 12 September 2011 19:30
		Re: PHP, MySQL and UTF-8? By: Peter H. Coffin on Mon, 12 September 2011 19:31
		Re: PHP, MySQL and UTF-8? By: A on Mon, 12 September 2011 20:27
		Re: PHP, MySQL and UTF-8? By: Thomas 'PointedEars' on Tue, 13 September 2011 14:53

Previous Topic:	Re: Startup City 2011 (September 24th,Mumbai)
Next Topic:	Social Bookmarks Script

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 06:42:14 GMT 2024

Total time taken to generate the page: 0.06986 seconds