MySQL

Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’

by

Error message on MySql: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’ I have gone through several other posts and was not able to solve this problem. The part affected is something similar to this: CREATE TABLE users ( userID INT UNSIGNED NOT NULL AUTO_INCREMENT, firstName VARCHAR(24) NOT NULL, lastName VARCHAR(24) NOT NULL, … Read more

Choosing a stand-alone full-text search server: Sphinx or SOLR? [closed]

by

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for … Read more

How do I turn off the mysql password validation?

by

It seems that I may have inadvertently loaded the password validation plugin in MySQL 5.7. This plugin seems to force all passwords to comply to certain rules. I would like to turn this off. I’ve tried changing the validate_password_length variable as suggested here to no avail. mysql> SET GLOBAL validate_password_length=4; Query OK, 0 rows affected … Read more

On duplicate key ignore? [duplicate]

by

This question already has answers here: “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE” (12 answers) Closed 9 years ago. I’m trying to finish this query; my tag field is set to UNIQUE and I simply want the database to ignore any duplicate tag. INSERT INTO table_tags (tag) VALUES (‘tag_a’),(‘tab_b’),(‘tag_c’) ON DUPLICATE KEY IGNORE … Read more