Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > mysql点滴_02程序中执行sql语句报字符集问题解决_MySQL

mysql点滴_02程序中执行sql语句报字符集问题解决_MySQL

WBOY
Release： 2016-06-01 13:04:04
Original
1005 people have browsed it

程序中执行 "SELECT t.EVENT_TYPE_ID FROM RATABLE_EVENT_TYPE t WHERE t.NAME='帐期末费用转移事件'" 报错
错误码：1267 不合法的混合字符集。
错误信息：mix of collations (gbk_bin,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='
解决办法：用binary()函数统一字符集 SELECT t.EVENT_TYPE_ID FROM RATABLE_EVENT_TYPE t WHERE t.NAME=binary('帐期末费用转移事件')

Related labels：
character set statement
source：php.cn
Previous article：MySQL多实例配置(二)_MySQL Next article：MySQL存储过程传参之in,out,inout参数用法_MySQL
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Top-level method to replace a string with HTML code (generated from an array) Given a string like this...$htmlPattern="Usernameis:#name#andusercompanyis#company#&q...
From 2024-04-06 17:40:41
0
2
410
Laravel 8 - How to redirect /{editable_text} route to /{user} route I've been trying to create a redirect route to lead me to a user profile. The redirect rou...
From 2024-04-06 17:26:11
0
1
410
Possibility to store ASP Classic code as string in MYSQL database Is it possible to store asp classic code into a MySQL database and have it execute the cod...
From 2024-04-06 13:38:43
0
1
358
Add the Endpoint _header attribute to the JSON response object I'm testing pulling data from a remote endpoint service (npoint.io). When I get back the r...
From 2024-04-05 10:35:39
0
1
1376
Add additional values ​​to displayed format data fields using javascript I'm trying to achieve this: I want to create a form that collects data entered by the user...
From 2024-04-04 15:17:13
0
1
3589
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template