Re: Encoding problems

Jukka Zitting <[email protected]>
Newsgroups gmane.comp.web.midgard.devel
Message-ID <[email protected]>
Hi,

On 1/27/06, Tarjei Huse <[email protected]> wrote:
> Hmm, would it be possible to make a simple commandline tool to run this
> process, checking the current charsets of midgard and mysql and making
> sure that they are correctly set and advising the user on what to do? I
> bet we'll see a lot of issues like this one in the coming year.

Good idea. The process is a bit dangerous and involves a lot of nasty
corner cases (a database could use different character sets for
different sites), but with good backups, proper checking, and user
interaction it could probably be made safe enough.

> PS: The database was med using datagard, so I guess we need to look into
> dg as well.

I recently changed datagard (in CVS HEAD) to always create databases
in UTF-8. Before that datagard has not specified the database
character set.

BR,

Jukka Zitting

--
Yukatan - http://yukatan.fi/ - [email protected]
Software craftmanship, JCR consulting, and Java development
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.