Hi Maximo, Try this: add this to your HTML document <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
Hope it helps Ken ----- Original Message ----- From: "Maximo Migliari" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 30, 2003 11:19 AM Subject: Character problems > Platform: windows > MySQL version: 4.0.9-gamma > PHP version: 4.3.0 > > Connected through Command Prompt via MySQL client to local MySQL server. > > Output from a SELECT query: > > mysql> select * from category; > +----+--------+-------------------+--------------+-------------+------ --+ > | id | parent | name | num_elements | description | type | > +----+--------+-------------------+--------------+-------------+------ --+ > | 1 | 0 | materias | 0 | 1 | artigo | > | 2 | 0 | artigos | 0 | 2 | artigo | > | 3 | 1 | Tipos de câncer | 0 | 3 | artigo | > | 4 | 1 | Crianças carentes | 0 | 4 | artigo | > | 5 | 3 | Leucemia | 0 | 5 | artigo | > | 6 | 3 | Câncer de pele | 0 | 6 | artigo | > | 7 | 3 | Notícias | 0 | 7 | ultima | > +----+--------+-------------------+--------------+-------------+------ --+ > 7 rows in set (0.00 sec) > > mysql> exit > Bye > > Note that for the name field, the characters ç, í, â, are all appearing > correctly. > > Now when I select this information from PHP and print it as a webpage, this > is what I get: > f instead of â, > ¡ instead of í > ? instead of ç > > What's up? I used to do this before without any problems. I'm assuming > this is some character encoding issue - however, I don't know if its in PHP > or in MySQL the problem. > > Help! > Maximo. > > > -------------------------------------------------------------------- - > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php