SPECS: mysql.spec - set collation to latin2-like, too.

[Elan Ruusamäe]

this will break existing mysql installations which do not specify at all 
charset in their config and therefore depended on latin1 collation.
and the breakage will return error on all queries which use indexed columns, 
and to fix that you need to repair database tables, this is not good at all 
(depending on data size several minutes to days of downtime perhaps!)

please add trigger to update the mysql.conf files or very big fat warning 
about such change

perhaps SAFER and more compatible solution is to specify the latin2 charset in 
config files, so new installations get your desired behaviour and existing 
ones do no break.

On Saturday 09 July 2005 16:57, arekm wrote:
> Author: arekm                        Date: Sat Jul  9 13:57:36 2005 GMT
> Module: SPECS                         Tag: HEAD
> ---- Log message:
> - set collation to latin2-like, too.
>
> ---- Files affected:
> SPECS:
>    mysql.spec (1.281 -> 1.282)
>
> ---- Diffs:
>
> ================================================================
> Index: SPECS/mysql.spec
> diff -u SPECS/mysql.spec:1.281 SPECS/mysql.spec:1.282
> --- SPECS/mysql.spec:1.281	Sat Jul  9 15:49:39 2005
> +++ SPECS/mysql.spec	Sat Jul  9 15:57:31 2005
> @@ -459,6 +459,7 @@
>  	--with%{!?debug:out}-debug \
>  	--with-embedded-server \
>  	--with-charset=latin2 \
> +	--with-collation=latin2_general_ci \
>  	--with-extra-charsets=all \
>  	--with-low-memory \
>  	--with-mysqld-user=mysql \
> @@ -854,6 +855,9 @@
>  All persons listed below can be reached at <cvs_login>@pld-linux.org
>
>  $Log$
> +Revision 1.282  2005/07/09 13:57:31  arekm
> +- set collation to latin2-like, too.
> +
>  Revision 1.281  2005/07/09 13:49:39  arekm
>  - fix log (latin2)
>
> ================================================================
>
> ---- CVS-web:
>     http://cvs.pld-linux.org/SPECS/mysql.spec?r1=1.281&r2=1.282&f=u
>
> _______________________________________________
> pld-cvs-commit mailing list
> pld-cvs-commit at lists.pld-linux.org
> http://lists.pld-linux.org/mailman/listinfo/pld-cvs-commit

-- 
glen