[opencms-dev] Alpha1 - Database Character Set Issue

[Alexander Kandzior]

Cyrill,

The honest truth is we actually have not tested with MySQL 4.1.x so far,
only with 4.0.x. I guess they have improved UTF-8 support and now require
the DB to actually be setup with UTF-8. UTF-8 support in MySQL 4.0.x is
actually pretty weak, even though it works fine with OpenCms.

If this is the only issue with 4.1.x I say we look pretty good ;-)

Let me know if you find it works / doesn't work with MySQL 4.1.x in genreal.

Best Regards,
Alex.

Alexander Kandzior
Alkacon Software - The OpenCms Experts
http://www.alkacon.com

 

> -----Original Message-----
> From: opencms-dev-bounces at opencms.org 
> [mailto:opencms-dev-bounces at opencms.org] On Behalf Of Cyrill 
> Brunschwiler
> Sent: Wednesday, September 22, 2004 10:06 PM
> To: opencms-dev at opencms.org
> Subject: [opencms-dev] Alpha1 - Database Character Set Issue
> 
> 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
> 
> 
> _______________________________________________
> This mail is send to you from the opencms-dev mailing list To 
> change your list options, or to unsubscribe from the list, 
> please visit http://mail.opencms.org/mailman/listinfo/opencms-dev
> 
>