使用的是UTF_8的编码格式,在检索学生成绩时,SQL语句如下:
SELECT a.record_name, a.record_level, a.student_id, a.index_no FROM t_student_record a , t_student_base_info b WHERE a.student_id = b.student_id AND a.student_id = 1235 AND a.record_level >= '80' AND a.record_level <= '999' ORDER BY a.record_name ASC limit 10 offset 0
上面的语句检索不到成绩为100的学生.
如果SQL语句改为:
SELECT a.record_name, a.record_level, a.student_id, a.index_no FROM t_student_record a , t_student_base_info b WHERE a.student_id = b.student_id AND a.student_id = 1235 AND a.record_level < 60 则可以检索到成绩为100的学生,可惜这样与业务逻辑不符!
请高手指教!!