Follow-up Comment #26, bug #1981 (project savane):
I agree with you, Silvain. I think that enabling of UTF-8 should be possible
without too much trouble. I further think that we should do this *before* we
release 1.0.6, as it would be a great opportunity to get a smooth
transition.
WRT the database, it is indeed not that trivial as I first thought.
Unfortunately, the CONVERT() function is only available in MySQL 4.1 or
greater and is therefore clearly ruled out. To do the conversion nonetheless,
we have to do it "manually".
But here's the good news: I thought a lot about the way how to do it, and I
think I discovered a really easy way which should have no side-effects:
1. Get a dump of the entire savane database
2. Store this dump in a temporary file
3. Convert the file from ISO-8859-1 to UTF-8, using iconv
4. Dump the converted file back into the MySQL database server
Some remarks about step 3: All the "metainformation" for MySQL, like table
structures and INSERT commands etc. are plain ASCII, so those are not affected
by the conversion. I cannot think of any error which could leave the database
in an unusable state, but since this is obviously the most critical task,
comments are very welcome.
OK, on we go: The site-specific files can easily be converted using iconv. No
problem here.
About gettext/ngettext: The .po files can be in whatever encoding, it doesn't
matter anymore. Any necessary conversion is done on the fly. Moreover, the
adaptions needed for savane to put out *real* UTF-8 are trivial and really
minor. I've tested them already, those fixes work smoothly.
I would like to point out that I'd *really* appreciate this bug to be solved
before 1.0.6, and I don't think that the changes needed are too intrusive to
be performed at this (relatively) late point in the process.
Mathieu, what do you think? Would it be possible to let the release task for
1.0.6 depend on this bug as well?
_______________________________________________________
Reply to this item at:
<http://gna.org/bugs/?func=detailitem&item_id=1981>
_______________________________________________
Message sent via/by Gna!
http://gna.org/
_______________________________________________
Savane-dev mailing list
[email protected]
https://mail.gna.org/listinfo/savane-dev
