MySQL Forums
Forum List  »  Russian

Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT)
Posted by: Valentin Borisenko
Date: October 22, 2009 02:11AM

Доброго всем времени суток, у меня проблемы с кодировками. Как избавиться от ошибки:
Quote

Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Перечитал уже много всего. Ничего не помогает. Пробовал использовать:
Quote

$conn = mysql_connect("localhost", "db_user", "xxxxxxxx") or die("Could not connect to localhost: " . mysql_error());
mysql_select_db("db_name", $conn) or die ("Can't use db_name: " . mysql_error());
mysql_query ("SET NAMES 'CP1251'");
mysql_query ("SET CHARACTER SET 'CP1251'");
не помогло.
Вот кому необходима инфа " SHOW VARIABLES":
Quote

Variable_name Value
character_set_client utf8
character_set_connection utf8
character_set_database latin1
character_set_filesystem binary
character_set_results utf8
character_set_server latin1
character_set_system utf8
character_sets_dir /usr/share/mysql/charsets/
collation_connection utf8_unicode_ci
collation_database latin1_swedish_ci
collation_server latin1_swedish_ci

-----
Deadangel is falling ...

Options: ReplyQuote


Subject
Views
Written By
Posted
Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT)
6389
October 22, 2009 02:11AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.