Hello.
Your character_set_xxx variables is ok. The problem could be in
the table definition. Send the output of
SHOW CREATE TABLE tbl_gruppen;
Florian Burkart <[EMAIL PROTECTED]> wrote:
> Hey everyone,
>
> can't figure this one out, might be easy for one of you.
>
>
>
> This is the query:
> (SELECT 'Neue Gruppe' AS gruppenstring, '-1' AS gruppe_id)
> UNION ALL
> (SELECT CONCAT( gruppe, ' (', kommentar, ')' ) AS gruppenstring, gruppe_id
> FROM tbl_gruppen
> ORDER BY gruppe);
>
>
>
> This error message is returned on the php website:
> Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and
> (utf8_general_ci,IMPLICIT) for operation 'UNION'
>
>
>
> There is no error message (query executes successfully) in phpmyadmin or when
> connecting by mysql.
>
>
>
> Following query always executes successfully (no long term solution though):
> (SELECT utf8_'Neue Gruppe' AS gruppenstring, utf8_'-1' AS gruppe_id)
> UNION ALL
> (SELECT CONCAT( gruppe, ' (', kommentar, ')' ) AS gruppenstring, gruppe_id
> FROM tbl_gruppen
> ORDER BY gruppe);
>
>
>
> This is the output of
> mysql> show variables like "%character%"; show variables like "%collation%";
> +--------------------------+----------------------------+
> | Variable_name | Value |
> +--------------------------+----------------------------+
> | character_set_client | utf8 |
> | character_set_connection | utf8 |
> | character_set_database | utf8 |
> | character_set_results | utf8 |
> | character_set_server | utf8 |
> | character_set_system | utf8 |
> | character_sets_dir | /usr/share/mysql/charsets/ |
> +--------------------------+----------------------------+
> 7 rows in set (0.00 sec)
>
> +----------------------+-----------------+
> | Variable_name | Value |
> +----------------------+-----------------+
> | collation_connection | utf8_general_ci |
> | collation_database | utf8_general_ci |
> | collation_server | utf8_general_ci |
> +----------------------+-----------------+
> 3 rows in set (0.00 sec)
>
>
>
> This is my.cnf
> ...
> [mysql]
> character-sets-dir=/usr/share/mysql/charsets
> default-character-set=utf8
>
> [mysqladmin]
> character-sets-dir=/usr/share/mysql/charsets
> default-character-set=utf8
>
> [mysqlcheck]
> character-sets-dir=/usr/share/mysql/charsets
> default-character-set=utf8
>
> [mysqldump]
> character-sets-dir=/usr/share/mysql/charsets
> default-character-set=utf8
>
> [mysqlimport]
> character-sets-dir=/usr/share/mysql/charsets
> default-character-set=utf8
>
> [mysqlshow]
> character-sets-dir=/usr/share/mysql/charsets
> default-character-set=utf8
>
> [myisamchk]
> character-sets-dir=/usr/share/mysql/charsets
>
> [myisampack]
> character-sets-dir=/usr/share/mysql/charsets
>
> # use [safe_mysqld] with mysql-3
> [mysqld_safe]
> err-log = /var/log/mysql/mysql.err
>
> # add a section [mysqld-4.1] or [mysqld-5.0] for specific configurations.
> [mysqld]
> character-set-server = utf8
> default-character-set = utf8
> ...
>
>
>
> Probably easy, but help please :)
> Florian
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
