Welcome Guest, Not a member yet? Register   Sign In
MySQL and extended ASCII
#5

[eluser]Xandrios[/eluser]
Thanks. It now works, kinda. I set both the page and Mysql tables to UTF-8, which did not work. After converting the database values with utf8_encode() it looks a lot better. However every once in a while there is a strange character. Example:

Quote: Gozando con Shakira…

Por Rocío Saavedra
SALTILLO, COAH. MAYO 31, 2007 (VANGUARDIA).- Todo lo que inicia tiene que finalizar y la más reciente gira de Shakira “Fijación Oral” no fue la excepción, después de un año de 120 conciertos ofrecidos en 36 países desde junio de 2006 Shakira entregó su alma, energía y amor el miércoles por la noche en el Auditorio del Parque Fundidora de Monterrey, Nuevo León.

The weird one here is '…'. Its not supposed to be there, and with normal ISO encoding it is not. Using PHPMyAdmin the (UTF8 encoded) value is displayed as "Gozando con ShakiraÂ…". Which doesnt seem to be right as well.

The other extended characters work fine, as can be seen in the text. Unfortunately the … keeps popping up here-and-there..


Messages In This Thread
MySQL and extended ASCII - by El Forum - 07-12-2007, 01:16 PM
MySQL and extended ASCII - by El Forum - 07-12-2007, 01:59 PM
MySQL and extended ASCII - by El Forum - 07-12-2007, 02:23 PM
MySQL and extended ASCII - by El Forum - 07-12-2007, 08:21 PM
MySQL and extended ASCII - by El Forum - 07-20-2007, 10:42 AM



Theme © iAndrew 2016 - Forum software by © MyBB