MYSQL提供了奇怪的错误消息-Java 学习之路

出于某种原因，如果我在我的数据库中提交"Nová objednávka pro návštěvníka"，则会导致出现此错误消息 . 我确实在数据库中注意到它是否进入数据库，一些字符被替换为？

An error occurred while saving this configuration: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=', query was: SELECT Job_Id, tablename_colummname, email_template, days FROM Envato_CustomConfig_Job WHERE tablename_colummname = :tablename_c AND email_template = :email AND days = :days AND timeStamp = :timeStamp AND Job_Id != :id LIMIT 1;

继承人我用来创建表的sql .

DROP TABLE IF EXISTS {$this->getTable('Envato_CustomConfig_Job')};
CREATE TABLE {$this->getTable('Envato_CustomConfig_Job')} (
  `Job_Id` int(11) NOT NULL AUTO_INCREMENT,
  `tablename_colummname` varchar(100) NOT NULL,
  `email_template` varchar(100) NOT NULL,
  `days` INT(2) NOT NULL,
  `timeStamp`  varchar(100) NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`Job_Id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

1 回答

0
像这样在你的WHERE-Clause中添加BINARY，例如：
```
WHERE BINARY tablename_colummname = BINARY :tablename_c
```
我希望这有帮助：-）
回复于 2024-05-04T09:37:14+08:00

MYSQL提供了奇怪的错误消息

1 回答

相关问题