Why wont the accents show up ?
i have a page (utf-8) that calls a list of spanish cities from a mysql table
(utf8) via php.
The database table has the correct names (with accents)
The php page will show the correct names if i type them in. (also in source i
see letters with accents)
But the php that grabs the names and displays it - will only show [squares]
instead of accented letters.

Please anyone, whats going on ??

More info...
with the page encoded to utf8:
i can type accents and they show correctly.
The php echo $spanishcity does not - it shows squares.
With the page encoded to charset=iso-8859-1:
i can not type accents ( i have to use alt+number )
but the php does work correctly

aaaaaaaahhhhhhhhhhh

..oO(WebOfWebs)

>Why wont the accents show up ?
> i have a page (utf-8) that calls a list of spanish cities from a mysql table
>(utf8) via php.
> The database table has the correct names (with accents)

Are the database columns defined as UTF-8?

Do you send a "SET NAMES utf8" as the very first query to set the
connection character set?

Are the pages delivered with a correct HTTP Content-Type header with
charset parameter?

Micha

Hi.

Look here, perhaps you find the answer.
http://dev.mysql.com/doc/refman/5.0/...alization.html


"WebOfWebs" <webforumsuser@macromedia.com> escribió en el mensaje de
noticias news:frtn27$8g2$1@forums.macromedia.com...
> Why wont the accents show up ?
> i have a page (utf-8) that calls a list of spanish cities from a mysql
> table
> (utf8) via php.
> The database table has the correct names (with accents)
> The php page will show the correct names if i type them in. (also in
> source i
> see letters with accents)
> But the php that grabs the names and displays it - will only show
> [squares]
> instead of accented letters.
>
> Please anyone, whats going on ??
>
>
>

Thanks for the help - but i still have a problem

my database details
version:5.0.45-community-nt
char set: utf8 (utf-8 unicode)
collation: utf8_general_ci

my table 'places' has records like Cataluña (the n has a tilda)

1)
connection script: //$q="SET NAMES 'utf8' "; $r=mysqli_query($DBlink,$q) or
die(mysqli_error($DBlink)." Q=".$q);
page header: <meta http-equiv="Content-Type" content="text/html;
charset=iso-8859-1" />
= the drop down list of places shows correctly

2)
page header: <meta http-equiv="Content-Type" content="text/html;
charset=utf-8" />
= the drop down has squares

3)
using SET NAMES and page=utf-8
= drop down displays correctly

So, i am thinking that setup(3) is the best for my english/spanish website
I have done the display data, next i will build the user-input form.

I have another problem...
i have an include page: require_once 'newdropdown.php'; which is just php
(triggered by javascript)
SELECT moreplaces...
echo '<select name="new">...

Strangely this always displays incorrectly, no matter what i try.
How can i make this second dropdown display correctly ??

Hum,
in my include page, i tried adding the SET NAMES query
And now the second dropdown displays correctly.

But why do i have to specify this query again - its already in my connection script ?

Hi,
I would need some help if you had solve the accent problems.
I have the same problem with french accents over vowels.
Since I am a beginner and I mainly use creation mode, would you tell me how to
configurate DW3 to have the rght accents returned from the database ?
Greetings.
(I rather speak french)