将com_name字段的属性修改为binary ALTER TABLE company CHANGE com_name com_name VARCHAR( 255 ) BINARY NOT NULL 或者在编译mysql的时候加入--with-charset=gb2312
是mysql支持中文的问题,有三种解决的方法,Starboy() 说了两种,还有一种是SQL语句这样写:select * from company where locate(com_name) like '%宁波%'
To:lapmx(易家)你所说的方法不行嘛,这是我的执行的错误提示: 查询语句是:select * from resource where locate(content) like '%非典%' order by publishdate desc limit 0,25 错误代码是:1064 错误信息是:You have an error in your SQL syntax near ') like '%非典%' order by publishdate desc limit 0,25' at line 1 为什么?而且我也没有查到locate函数
To Starboy():按照你所说的方法,无法进行修改嘛,我使用的是虎翼网的空间是不是他们的服务有什么限制?我用phpmyadmin执行以后的错误提示如下: SQL 语句 : ALTER TABLE resource CHANGE content content longtext BINARY NOT NULL MySQL 返回: You have an error in your SQL syntax near 'BINARY NOT NULL' at line 1 是不是说BINARY属性只能是varchar类型的字段,但是我现在要用longtext类型的怎么办,谢谢各位高手的回答
ALTER TABLE company CHANGE com_name com_name VARCHAR( 255 ) BINARY NOT NULL
或者在编译mysql的时候加入--with-charset=gb2312
查询语句是:select * from resource where locate(content) like '%非典%' order by publishdate desc limit 0,25
错误代码是:1064
错误信息是:You have an error in your SQL syntax near ') like '%非典%' order by publishdate desc limit 0,25' at line 1
为什么?而且我也没有查到locate函数
SQL 语句 :
ALTER TABLE resource CHANGE content content longtext BINARY NOT NULL
MySQL 返回:
You have an error in your SQL syntax near 'BINARY NOT NULL' at line 1
是不是说BINARY属性只能是varchar类型的字段,但是我现在要用longtext类型的怎么办,谢谢各位高手的回答