[redland-dev] Some basic questions: mostly mysql related

[Jasper van de Gronde]

Dave Beckett wrote:
> Murray Woodman wrote:
>> ...
>> The MySQL character set seems to be latin1. Is there any reason why this
>> is not unicode? You probably want to keep it backwards compatible with
>> earlier versions of MySQL. Unicode still goes in and out OK - it just
>> looks a little weird when it's in there and I guess the sorting will be
>> a little off. Would there be any danger in me altering the tables in
>> MySQL to make the the charset unicode?
> 
> I didn't write the original scheam, but Unicode sounds like a much better
> idea to me than latin1.   Danger is presumably all existing stores would
> have to migrate.

When I installed MySQL it asked what the default character set should 
be, if you set this to UTF-8 it might just work (judging from what you 
say redland probably gives UTF-8 to MySQL anyway).