utf8 output from database

[elyob]

Hi,

I'm having problems outputting data from my MySQL database. The output
should be Playa del inglés but instead I get ... Playa Del Ingl?s. I've
tried utf8_encode(), but this just converts to Playa Del Inglã©s.

Any advice? It seems to show fine in PHPMyadmin.

Thanks

[Jerry Stuckle]

elyob wrote:

Hi,

I'm having problems outputting data from my MySQL database. The output
should be Playa del inglés but instead I get ... Playa Del Ingl?s. I've
tried utf8_encode(), but this just converts to Playa Del Inglã©s.

Any advice? It seems to show fine in PHPMyadmin.

Thanks

Hi, elyob,

Are you using an HTML charset that displays the "é"?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[elyob]

"Jerry Stuckle" <js*******@attglobal.net> wrote in message
news:-s********************@comcast.com...

elyob wrote:

Hi,

I'm having problems outputting data from my MySQL database. The output
should be Playa del inglés but instead I get ... Playa Del Ingl?s. I've
tried utf8_encode(), but this just converts to Playa Del Inglã©s.

Any advice? It seems to show fine in PHPMyadmin.

Thanks

Hi, elyob,

Are you using an HTML charset that displays the "é"?

I thought so ...

[elyob]

"elyob" <ne*********@gmail.com> wrote in message
news:43********@news1.homechoice.co.uk...

"Jerry Stuckle" <js*******@attglobal.net> wrote in message
news:-s********************@comcast.com...

elyob wrote:

Hi,

I'm having problems outputting data from my MySQL database. The output
should be Playa del inglés but instead I get ... Playa Del Ingl?s. I've
tried utf8_encode(), but this just converts to Playa Del Inglã©s.

Any advice? It seems to show fine in PHPMyadmin.

Thanks

Hi, elyob,

Are you using an HTML charset that displays the "é"?

I thought so ...

<meta http-equiv="content-type" content="text/html;charset=utf-8" />

[Jerry Stuckle]

elyob wrote:

"elyob" <ne*********@gmail.com> wrote in message
news:43********@news1.homechoice.co.uk...

"Jerry Stuckle" <js*******@attglobal.net> wrote in message
news:-s********************@comcast.com...

elyob wrote:

Hi,

I'm having problems outputting data from my MySQL database. The output
should be Playa del inglés but instead I get ... Playa Del Ingl?s. I've
tried utf8_encode(), but this just converts to Playa Del Inglã©s.

Any advice? It seems to show fine in PHPMyadmin.

Thanks

Hi, elyob,

Are you using an HTML charset that displays the "é"?

I thought so ...

<meta http-equiv="content-type" content="text/html;charset=utf-8" />

I'm going to show my ignorance of foreign languages here - is this
Italian, French or what? And what's the hex value of the character?

I have seen other problems like this; it's generally the charset isn't
set up to display that particular character. And I'm not sure UTF-8
will do it.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[Jerry Stuckle]

elyob wrote:

"elyob" <ne*********@gmail.com> wrote in message
news:43********@news1.homechoice.co.uk...

"Jerry Stuckle" <js*******@attglobal.net> wrote in message
news:-s********************@comcast.com...

elyob wrote:

Hi,

I'm having problems outputting data from my MySQL database. The output
should be Playa del inglés but instead I get ... Playa Del Ingl?s. I've
tried utf8_encode(), but this just converts to Playa Del Inglã©s.

Any advice? It seems to show fine in PHPMyadmin.

Thanks

Hi, elyob,

Are you using an HTML charset that displays the "é"?

I thought so ...

<meta http-equiv="content-type" content="text/html;charset=utf-8" />

One other thing - what happens if you use iso-8859-1?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[Sander Tekelenburg]

In article <L8********************@comcast.com>,
Jerry Stuckle <js*******@attglobal.net> wrote:

[...]

I have seen other problems like this; it's generally the charset isn't
set up to display that particular character. And I'm not sure UTF-8
will do it.

The charset parameter doesn't 'do' anything. It simply claims which
character repertoire applies. If the content is utf-8, the charset
should say so. If the content is for example mac-roman, claiming
"charset=utf-8" doesn't *make* it utf-8. You'll need to transliterate to
utf-8 first.

Thus, you need to always, in this order,
- know what character repertoire your original content is in
- optionally transliterate to another character repertoire
- ensure all tools you use handle that character repertoire properly
- provide the correct charset value to let user-agents know how to
handle the data

--
Sander Tekelenburg, <http://www.euronet.nl/~tekelenb/>

Mac user: "Macs only have 40 viruses, tops!"
PC user: "SEE! Not even the virus writers support Macs!"

[Andy Hassall]

On Tue, 15 Nov 2005 14:59:17 -0000, "elyob" <ne*********@gmail.com> wrote:

<meta http-equiv="content-type" content="text/html;charset=utf-8" />

PHP is a server-side programming language, and so is capable of outputting
real HTTP headers. These are by far more preferable to meta Content-type
headers, which are more useful for storage media that don't have separate
metadata - i.e. when just dumped to a filesystem.

<?php header("Content-type: text/html;charset=utf-8"); ?.

... is much more likely to cause the browser to accept the encoding of the
page as UTF-8.

--
Andy Hassall :: an**@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

[Andy Hassall]

On Tue, 15 Nov 2005 12:05:32 -0000, "elyob" <ne*********@gmail.com> wrote:

I'm having problems outputting data from my MySQL database. The output
should be Playa del inglés but instead I get ... Playa Del Ingl?s. I've
tried utf8_encode(), but this just converts to Playa Del Inglã©s.

Any advice? It seems to show fine in PHPMyadmin.

What is the encoding of the page in PHPMyAdmin?

(Right click, View Page Info in Firefox)

How does the character appear in the page source in PHPMyAdmin? Is it encoded
as an HTML character entity (&eacute; or something like that), or output
directly?

The key with solving character encoding issues is knowing exactly how
characters have been stored and encoded at every point in the system - from
initial input, stored in the database, any conversions on fetching from the
database, and on output to the final page. Once you lose track of the encoding
then you are in trouble.
--
Andy Hassall :: an**@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool