binary用法

SELECT * FROM `fuhu_appstore`.`administrator` where binary username='ZKH'   加了binary才，区分大小写，只查出结果'ZKH',而非 'zkh'.

 

 

	public CriteriaProvider searchAdminByUsername() {
		CriteriaProvider adminSearch = CriteriaProvider.getInstance();
		adminSearch.addCriterion(Restrictions.sqlRestriction("binary username = '" + getUsername() + "'"));
		return adminSearch;
	}