From: Edward H. Trager (ehtrager@umich.edu)
Date: Sat Apr 16 2005 - 17:29:17 CST
With regard to MySQL and PHP and Unicode:
We have used, and continue to use, the combination of MySQL and PHP for
Unicode-based web applications. All of the data in our database tables are
encoded in UTF-8. The web pages are presented in XHTML 1.0 using UTF-8
and CSS level 1 & 2.
We have used PCRE (Perl compatible Regular Expressions) regular expression
stuff in PHP to some extent. I've found some quirks with it, but so far
managed to find work-arounds. I haven't compared PCRE with, say, ICU's
regular expression implementation, so I can't really comment on that.
Depending on what you want to do, the lack of built-in localized collation
support might mean that you or your developers have to write extra code to
get the results you want. Feel free to write me off list if you have
specific questions.
- Ed
On Saturday 2005.04.16 14:59:44 -0700, Tex Texin wrote:
> (I dont think this made it to the list first time.)
>
> Hi,
> PHP's support for Unicode is at the "you can hack it in" level at the
> moment.
> Most of the messages you found probably discussed hacks.
>
> MySQL has Unicode support but it's at the level of "first release"
> quality.
>
> tex
>
>
> "Donald Z. Osborn" wrote:
> >
> > On Arlo's question (which is way beyond me technically) one skeptical take on
> > PHP and Unicode is offered on a blog at at
> > http://www.acko.net/php-no-unicode-support . The php-i18n list at
> > http://www.phpbuilder.com/lists/ has some discussion of this: 300+ hits on its
> > site search for "Unicode" including a mention of slow progress, but I didn't
> > sample but a couple of messages that Google found.
> >
> > Thanks to Tom for the pointer re Moin Moin.
> >
> > I ultimately decided to work with Mediawiki but in scouting out the settings on
> > the server have noticed PHP's limitations with regard to Unicode. Not sure yet
> > what this will mean in practice.
> >
> > Don Osborn
> > Bisharat.net
> >
> > Quoting "Arlo J. Bensinger" <ajb102@psu.edu> Sat, 2 Apr 2005 10:08:48 -0500
> > (EST):
> >
> > > We've been using UniWakka with some success, although I'm only "learning"
> > > Unicode presently, and I think UniWakka uses some form of data conversion so
> > > the stored data is not "really" Unicode.
> > >
> > > Forgive me if this is a naive question, but as we are committed to using PHP
> > > and
> > > MySQL to backend our wiki, is it even possible to have a true Unicode wiki
> > > until these tools become Unicode native? We have been testing a Unicode
> > > MySQL
> > > installation, and it continues to be problematic with PHP (at least as far
> > > as
> > > my coding skills enable me to code).
> > >
> > > If anyone here has found or used or set up good documentation on doing
> > > Unicode via MySQL and PHP, could you please let me know?
> > >
> > > Arlo
> > >
> > > Arlo Bensinger
> > > Technology Coordinator, CALPER
> > > http://calper.la.psu.edu
> > >
> > > "And what is Good, Phaedrus, and what is not - need we ask anyone to tell us
> > > these things?"
> > >
> > > On Sat, 02 Apr 2005 09:24:57 +0000, Tom Emerson wrote:
> > >
> > > > Donald Z. Osborn writes:
> > > > > I wanted to pick up on Neil's suggestion of Mediawiki to ask about other
> > > Unicode
> > > > > savvy (can I still say that?) wiki software. I'm aware that Zwiki and
> > > > > Purplewiki support UTF-8. PmWiki is easy to set up, but mangled some
> > > test
> > > lines
> > > > > with extended Latin characters. Are there other recommendations? I
> > > haven't
> > > > > managed to find a good current review of wikis, let alone one that
> > > focuses
> > > on
> > > > > multilingual capacities and unicode support.
> > > >
> > > > MoinMoin, http://moinmoin.wikiwikiweb.de/, supports UTF-8 and is easy
> > > > to set-up. Visually it doesn't compare to MediaWiki, though this is
> > > > improving. We've been using it internally at Basis Technology and have
> > > > been happy.
> > > >
> > > > -tree
> > > >
> > > > --
> > > > Tom Emerson Basis Technology
> > > Corp.
> > > > Software Architect
> > > http://www.basistech.com
> > > > "Beware the lollipop of mediocrity: lick it once and you suck forever"
> > > >
> > > >
> > > >
> > >
> > >
> > >
>
> --
> -------------------------------------------------------------
> Tex Texin cell: +1 781 789 1898 mailto:Tex@XenCraft.com
> Xen Master http://www.i18nGuy.com
>
> XenCraft http://www.XenCraft.com
> Making e-Business Work Around the World
> -------------------------------------------------------------
>
>
>
This archive was generated by hypermail 2.1.5 : Sat Apr 16 2005 - 17:08:33 CST