List:General Discussion« Previous MessageNext Message »
From:Ken Menzel Date:January 31 2003 2:40pm
Subject:Re: Character problems
View as plain text  
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" <maximo@stripped>
To: <mysql@stripped>
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 <mysql-thread131234@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-kenm=icarz.com@stripped>
> Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
>
>

Thread
Character problemsMaximo Migliari30 Jan
  • Re: Character problemsDan Nelson31 Jan
  • Re: Character problemsKen Menzel31 Jan