On Sep 18, 2007, at 3:46 AM, Joel Sooriah wrote:
Current version of mysql is 5.0.45
So you want to define the character set as utf-8 and the collation as
utf8_general_ci (assuming you want case-insensitivity - utf8_bin is
more accurate, but I believe it's more processing intensive. I stick
to utf8_general_ci).
The mysql client connection (probably via a php extension in this
case) also defines it's own character set... so you want to make sure
to set that to utf-8. http://us.php.net/manual/en/function.mysqli-
set-charset.php If you're using the mysql extension and not mysqli,
you have to do it via a sql command called via mysql_query -- I can't
remember the syntax for that off the top of my head.
2007/9/17, Rob Marscher <[EMAIL PROTECTED]>:
On Sep 17, 2007, at 12:54 PM, Joel Sooriah wrote:
having a problem right now concerning the use of accentuated
characters in a xml document.
Are you storing the xml document in a mysql table? Which version of
mysql?
You need to make sure that the character sets match all the way from
the database layer down through your web server - using utf8 is a
safe bet.
Of course, this is causing me much
problem concerning the validity of my document, due to the use of
';'
in the textContent of my node.
Using CDATA would solve that problem:
http://www.w3schools.com/xml/xml_cdata.asp
_______________________________________________
New York PHP Community MySQL SIG
http://lists.nyphp.org/mailman/listinfo/mysql
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
