但如果我們儲存的內容一定要分辨字母大小寫時
所以必需從 sql 敘述來解決

ex:

原來:

select stu_name from stu_info where stu_name = 'Jerry' 

select stu_name from stu_info where stu_name = 'jerry' 

改成:

 

select stu_name from stu_info where stu_name  COLLATE Latin1_General_CS_AS = 'Jerry' 

 

select stu_name from stu_info where stu_name  COLLATE Latin1_General_CS_AS = 'jerry' 

 

arrow
arrow
    全站熱搜

    chungweis 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄