Hi, look at these config options (config_data_layer.php) Karel /** * Needs to be set when you are useing MySQL >= 4.1 * see mysql manual for more info * * $config->data_sql->collation = "utf8_general_ci"; */ $config->data_sql->collation = ""; /** * Set to true when you are useing MySQL >= 4.1 * This option set mysql system variables character_set_client, * character_set_connection, and character_set_results to charset * used in serweb * * $config->data_sql->set_charset = true; */ $config->data_sql->set_charset = false; Zenone napsal(a): > Hi, > I still have troubles with my serveb... (thanks karel for answering

> previous question) I saw the serweb log and it can be read : > > "" 'Jun 13 10:13:52 serweb [error] file: > /usr/local/serweb-0.9.4/data_layer/method.get_aliases.php:27: DB

> unknown error - select username, domain from aliases where > lower(contact)=lower('sip:zenone@192.168.0.120') order by username > [nativecode=1267 ** Illegal mix of collations

> and (utf8_general_ci,COERCIBLE) for operation '='] "" > I followed karel advice of july 2005 and it doesn't work anyway. > I work on a fedora with ser 0.9.6 and serweb 0.9.4. > Thanks for your help! > Michel > > ________________________________________________ > Message sent using UebiMiau 2.7.8 > > > _______________________________________________ > Serusers mailing list > Serusers(a)lists.iptel.org > http://lists.iptel.org/mailman/listinfo/serusers