hql mysql 如何实现中文排序
排序要求 按照 s_typeno + s_name 中文拼音进行排序!
下面是sql语句..谢谢大家
/*
SQLyog Trial v10.2
MySQL - 5.5.23 : Database - demo
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`demo` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `demo`;
/*Table structure for table `s_equipment` */
DROP TABLE IF EXISTS `s_equipment`;
CREATE TABLE `s_equipment` (
`s_id` int(11) NOT NULL AUTO_INCREMENT,
`type_id` int(11) DEFAULT NULL,
`s_name` varchar(10) DEFAULT NULL,
`s_qz` varchar(200) DEFAULT NULL,
`s_jianjie` varchar(200) DEFAULT NULL,
`s_typeno` varchar(20) DEFAULT NULL,
`s_isone` bit(1) DEFAULT NULL,
`s_unit` varchar(10) DEFAULT NULL,
`s_price` float DEFAULT NULL,
`s_two` float DEFAULT NULL,
`s_three` float DEFAULT NULL,
`s_four` float DEFAULT NULL,
`s_five` float DEFAULT NULL,
`s_six` float DEFAULT NULL,
`s_seven` float DEFAULT NULL,
`s_images` varchar(100) DEFAULT NULL,
`s_addtime` date DEFAULT NULL,
`s_updtime` date DEFAULT NULL,
`s_user` varchar(20) DEFAULT NULL,
`s_state` int(11) DEFAULT NULL,
`s_bak` varchar(100) DEFAULT NULL,
`s_purchase` float DEFAULT NULL,
`mosaic` bit(1) DEFAULT NULL,
PRIMARY KEY (`s_id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;
/*Data for the table `s_equipment` */
insert into `s_equipment`(`s_id`,`type_id`,`s_name`,`s_qz`,`s_jianjie`,`s_typeno`,`s_isone`,`s_unit`,`s_price`,`s_two`,`s_three`,`s_four`,`s_five`,`s_six`,`s_seven`,`s_images`,`s_addtime`,`s_updtime`,`s_user`,`s_state`,`s_bak`,`s_purchase`,`mosaic`) values (4,15,'圆形球-5寸','常温下放置10天','巴西球皮,5寸含氦气充气,室内布置或放飞仪式','10010101','\0','个',3,8,7,6,5,4,3,'d:/upload/file/sequipment/20160826184410100101.png','2016-07-15','2016-09-05','1',1,NULL,0,''),(5,10,'爱心气球','彩色的气球','气球','100302','\0','平方米',6,5,4,3,3,3,2,'d:/upload/file/sequipment/20160719132027100101.png','2016-07-19','2016-09-19',NULL,1,NULL,0,'\0'),(6,1,'气球啊','气球','气球','10','','个',0,0,0,0,0,0,0,'d:/upload/file/sequipment/2016080211105410.jpg','2016-07-29','2016-09-12',NULL,1,NULL,50,'\0'),(7,1,'气球','气球','气球','10','','个',0,0,0,0,0,0,0,'d:/upload/file/sequipment/2016080211460910.jpg','2016-08-02',NULL,NULL,1,NULL,1,'\0'),(8,65,'小灯','小灯','小灯','10','\0','个',0,0,0,0,0,0,0,'d:/upload/file/sequipment/2016080311001710.jpg','2016-08-02','2016-09-19',NULL,3,NULL,0,'\0'),(9,65,'红灯111','很亮,很便宜','照亮,装饰','100108','','个',0,0,0,0,0,0,0,'d:/upload/file/sequipment/20160809144711100108.jpg','2016-08-09','2016-09-19',NULL,1,NULL,11,'\0'),(10,65,'b白色的灯1','白灯啊','白灯啊','100108','','个',0,0,0,0,0,0,0,'d:/upload/file/sequipment/20160812164916100108.jpg','2016-08-12','2016-09-19',NULL,1,NULL,111,'\0'),(11,15,'蓝色圆形气球碧','碧绿色圆形气球','圆形气球','10010101','','个',0,0,0,0,0,0,0,'d:/upload/file/sequipment/2016090211353810010101.jpg','2016-09-02',NULL,NULL,1,NULL,1,'\0'),(12,15,'紫色圆形气球','红色圆形气球','圆形气球','10010101','','个',11,1,1,1,1,1,1,'d:/upload/file/sequipment/2016090211353810010101.jpg','2016-09-06','2016-09-06',NULL,NULL,NULL,1,'\0'),(13,15,'绿色圆形气球','蓝色圆形气球','圆形气球','10010101','','个',1,1,1,1,1,0,0,'d:/upload/file/sequipment/2016090211353810010101.jpg',NULL,NULL,NULL,NULL,NULL,1,'\0'),(14,15,'红色圆形气球','紫色圆形气球','圆形气球','10010101','','个',1,1,1,1,1,0,0,'d:/upload/file/sequipment/2016090211353810010101.jpg',NULL,NULL,NULL,NULL,NULL,1,'\0'),(15,15,'青色圆形气球','青色圆形气球','圆形气球','10010101','','个',0,0,0,0,0,0,0,'d:/upload/file/sequipment/2016090211353810010101.jpg',NULL,'2016-09-19',NULL,1,NULL,1,'\0'),(16,15,'圆形气球','圆形气球','圆形气球','10010101','','个',1,1,1,1,1,0,0,'d:/upload/file/sequipment/2016090211353810010101.jpg',NULL,NULL,NULL,NULL,NULL,1,'\0'),(17,15,'小白灯','小白灯','小白灯','10010101','','个',0,0,0,0,0,0,0,'d:/upload/file/sequipment/2016090211353810010101.jpg',NULL,'2016-09-19',NULL,1,NULL,1,'\0'),(18,15,'白灯啊','圆形气球','圆形气球','10010101','','个',11,1,1,1,1,0,0,'d:/upload/file/sequipment/2016090211353810010101.jpg',NULL,NULL,NULL,NULL,NULL,1,'\0');
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
如何排序..? 请教大家一下 百度过的代码,没效果,没用额..