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 #175373 is a reply to message #175372]

Mon, 12 September 2011 19:30

Jerry Stuckle
Messages: 2598
Registered: September 2010

Karma:

Senior Member

On 9/12/2011 12:46 PM, Robert Latest wrote:
> 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

What version of PHP are you using?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================

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:23:38 GMT 2024

Total time taken to generate the page: 0.04138 seconds