像这样使用

 "select * from $pwsXDataHistory where type = '$type' COLLATE NOCASE and $t_uStatus != '$DELETE' order by $t_name COLLATE NOCASE asc ");

这不是特定于sqlite，但你可以这样做

SELECT * FROM ... WHERE UPPER(name) = UPPER('someone')

可以使用like查询将各自的字符串与表值进行比较。

Select column name from table_name where column name like '各自的比较值';

像这样使用

 "select * from $pwsXDataHistory where type = '$type' COLLATE NOCASE and $t_uStatus != '$DELETE' order by $t_name COLLATE NOCASE asc ");

你可以这样做:

SELECT * FROM ... WHERE name LIKE 'someone'

(这不是解决方案，但在某些情况下非常方便)

"The LIKE operator does a pattern matching comparison. The operand to the right contains the pattern, the left hand operand contains the string to match against the pattern. A percent symbol ("%") in the pattern matches any sequence of zero or more characters in the string. An underscore ("_") in the pattern matches any single character in the string. Any other character matches itself or its lower/upper case equivalent (i.e. case-insensitive matching). (A bug: SQLite only understands upper/lower case for ASCII characters. The LIKE operator is case sensitive for unicode characters that are beyond the ASCII range. For example, the expression 'a' LIKE 'A' is TRUE but 'æ' LIKE 'Æ' is FALSE.)."

如果列的类型是char，那么你需要用空格来附加你正在查询的值，请参考这里的问题。除此之外，还可以使用COLLATE NOCASE或其他解决方案(upper()等)。