使用 UTF-8 编码的 SQLite3 LIKE 查询 [英] SQLite3 LIKE query with UTF-8 encoding

问题描述

对于 MySQL，我正在使用它并且与 UTF-8 配合得很好.

for MySQL I'm using this and works very well with UTF-8.

SELECT * FROM cat.item_list WHERE CONVERT(item_name USING utf8) LIKE (:searchString)

我用 sqlite 尝试过相同的查询，但它不起作用.我应该为 UTF-8 SQLite3 搜索查询做什么?(喜欢)

I've tried same query with sqlite but it doesn't work. What should I do for UTF-8 SQLite3 search query? (with LIKE)

我当前的 sqlite3 qry(不适用于 UTF-8 字符集):

my current sqlite3 qry (which doesn't work with UTF-8 charsets):

SELECT * FROM item_list WHERE item_name LIKE '%$safeName%'

推荐答案

我是这样解决的:

    $tr_chars = array('ç','Ç','ı','İ','ğ','Ğ','ü','ö','Ş','ş','Ö','Ü'); 
    $safeName = str_replace($tr_chars, '_', $safeName);

这篇关于使用 UTF-8 编码的 SQLite3 LIKE 查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！