[opencms-dev] Alpha1 - Database Character Set Issue

[Cyrill Brunschwiler]

Hi

Btw, i didn't test any other OpenCms version since 5.0.1. I'm impressed. 
Great work guys!

Issue:
°°°°°°
Run into charset conflict while importing the workplace:
SQL Exception: Illegal mix of collations (latin1_bin,IMPLICIT) and 
(utf8_general_ci,COERCIBLE) for operation '='

Environement:
°°°°°°°°°°°°°
- Debian Linux (testing), Kernel 2.6.x
- MySQL Server 4.1.3-beta-standard
- Tomcat 5.0.27
- JDK 1.4.2_05

Solutions:
°°°°°°°°°°
- Start mysqld with:
  --default-character-set=utf8 \
  --default-collation=utf8_general_ci
  (this works for me)

or

- alter database characterset:
  ALTER DATABASE cms CHARACTER SET utf8;
  ALTER DATABASE cms COLLATE utf8_general_ci;
  (didn't work for me, needs more investigation)

rgrds,
Cyrill