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

Re: PHP, MySQL and UTF-8? [message #175381 is a reply to message #175372]

Tue, 13 September 2011 14:53

Thomas 'PointedEars'
Messages: 701
Registered: October 2010

Karma:

Senior Member

Robert Latest wrote:

> 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.

As for the wget output, your console might not be UTF-8-compliant, or you
might not have declared the proper character encoding for the HTTP resource
and the resource type (e. g., HTML) requires you to escape them then, which
you also failed to do.

> 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.

This and

> I think I'm opening the db correctly:
>
> $c = new PDO("mysql:host=$host;dbname=$dbname;port=$port;charset=UTF-8",
> $user, $pass);

suggests that the Content-Type header field of the HTTP response for your
Web site has the wrong value. And I think that is a FAQ.

PointedEars
--
Danny Goodman's books are out of date and teach practices that are
positively harmful for cross-browser scripting.
-- Richard Cornford, cljs, <cife6q$253$1$8300dec7(at)news(dot)demon(dot)co(dot)uk> (2004)

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 08:50:01 GMT 2024

Total time taken to generate the page: 0.03519 seconds