Frisco wrote:Dear anda_skoa,

frisco@linux:/etc$ echo $LANG
de_DE@euro

Is it that what you mean?

Yes, the output of "locale" actually, but this is almost the same.

I am wondering if it could be a locale problem, e.g. mysql not supporting UTF-8 if not run in an UTF-8 locale.
But I had almost the same locale setup before (de_AT@euro) and it worked there.

Maybe someone else has an idea.

Cheers,
_

bcooksley wrote:I suggested using the System Wide database to check if it was a multiple instances issue. Also, running multiple instances uses more system resources ( I rarely run Akonadi because the combined use of memory is approximately 10% for mysql, akonadicontrol, akonadiserver, and the agents )

Right. I just wanted to point out that in general suggestions that require special knowlegde on the user's part (e.g. how to do MySQL administration) should usually be treated as a last resort thing when doing user support.

Cheers,
_

anda_skoa wrote:

Frisco wrote:Dear anda_skoa,

frisco@linux:/etc$ echo $LANG
de_DE@euro

Is it that what you mean?

Yes, the output of "locale" actually, but this is almost the same.

I am wondering if it could be a locale problem, e.g. mysql not supporting UTF-8 if not run in an UTF-8 locale.
But I had almost the same locale setup before (de_AT@euro) and it worked there.
...
_

Strange enough:
frisco@linux:~$ echo $LANG
de_DE@euro
frisco@linux:~$ echo $LOCALE

frisco@linux:~$

Should I try setting $LOCALE to s.th.? What exactly?

/etc/mysql/my.cnf says:
default-character-set = latin1

default-collation is unset.

But AFAIK each database and table can have it's own character-set and collation, so this shouln't be a problem.

System is Debian Testing with mysql 4.1.15, which should be sufficient I guess.

Cheers
Frisco

Frisco wrote:Strange enough:
frisco@linux:~$ echo $LANG
de_DE@euro
frisco@linux:~$ echo $LOCALE

frisco@linux:~$

Should I try setting $LOCALE to s.th.? What exactly?

locale is a command, just run it.
However the probelm seems to be somewhere else, unfortunately I have way too few experience with MySQL to suggest any place where to do further investigations

Frisco wrote:System is Debian Testing with mysql 4.1.15, which should be sufficient I guess.

I have MySQL 5.0.81-1 (Debian unstable).
According to packages.debian.org Debian Testing has 5.0.51, actually even Stable has that one.
Maybe you have an incomplete upgrade?

Cheers,
_