UTF-8 Support

'Managing Non-ASCII Character Strings with MySQL Servers' tutorial book was cited in a Plogger bug report in 2006.

The Managing Non-ASCII Character Strings with MySQL Servers tutorial book was cited in a Plogger bug report in 2006.

Subject: [Bugs] [plogger] #122: UTF-8 support
Date: Mar 15, 2006
Author: Victor
Source: http://lists.plogger.org/pipermail/bugs/2006-March/000390.html

I've realized that the UTF8 character set isn't really support in
Plogger. I'm talking about 2.1 version, but seems that version 3 is
affected too.

Although Plogger ''_install.php'' script creates the MySQL tables with
the UTF-8 character set properly, the information is not really stored
in UTF-8 as far as I know. I realized that because the RSS feed
generated with special characters (''??' and so on) didn't work
properly, and get complaints about the use of invalid characters
(''ñ'' and so on). Looking in the database, I see that the
information itself isn't been stored in really UTF-8.

In my Plogger version I fixed this problem doing the next things:

'''1)''' The Admin backend XHTML is not in UTF-8. For that I added the

 <meta http-equiv="Content-Type" content="txt/html; charset=utf-8"/>

in the XHTML generated, and to make sure:

 header("Content-Type: text/html; charset=utf-8");

With this we're sure the XHTML generated is in UTF-8, but we can't
assure the information from the forms is been sent to the MySQL server
in UTF-8. See step # 2

'''2)''' To make sure about the last point mentioned I added the next

   $rs = run_query("SET NAMES 'utf8'");

(I'm not going to explain here this command, don't worry ;), but you
can see more info here:

So, Ok, we're storing properly the utf-8 information in the Database,
but... why the hell my XML isn't valid yet? Let's look at step # 3

Table of Contents

 About This Book

 Reference Citations in 2021

 Reference Citations in 2020

 Reference Citations in 2019

 Reference Citations in 2018

 Reference Citations in 2017

 Reference Citations in 2016

 Reference Citations in 2015

 Reference Citations in 2014

 Reference Citations in 2013

 Reference Citations in 2012

 Reference Citations in 2011

 Reference Citations in 2010

 Reference Citations in 2009

 Reference Citations in 2008

 Reference Citations in 2007

Reference Citations in 2006

 help with SOAP


 handling unicode characters in jsp

 A Tutorial for New Axis2 Users

 Dovecot SSL Warning (Not Error)

 Conexiones permanentes


 Character set problem

 Rpc::xml, examples and docs "for Dummies"

UTF-8 Support

 Conversion of Single and Double in Binary

 arqHP:: XHTML ou HTML

 Looking for JS Code for Chinese Calendar

 Reference Citations in 2005

 Reference Citations in 2004

 Reference Citations in 2003