语言切换为“法语”,设置 > 上方的搜索栏 > 输入任意字符 > 搜索
报错说是 SQL语法错误,发生在"écran"附近,报错只发生在法语下,其他语言正常,我数据库知识有限,看不出这句SQL语句哪里语法错误了,请大神们 帮忙分析一下.....下面是报错的语句 SELECT data_rank, data_title, data_summary_on, data_summary_off, data_entries, data_keywords, class_name, screen_title, icon, intent_action, intent_target_package, intent_target_class, enabled, data_key_reference FROM prefs_index WHERE prefs_index MATCH 'data_title:y* OR data_title_normalized:y* OR data_keywords:y*' AND locale = 'fr_FR' AND enabled = 1 AND data_rank NOT IN (SELECT data_rank FROM prefs_index WHERE prefs_index MATCH 'data_title:y* OR data_title_normalized:y* OR data_keywords:y*' AND locale = 'fr_FR' AND enabled = 1 AND (data_title = 'Fonds d'écran' AND class_name = 'com.android.settings.DeviceInfoSettings') ) ORDER BY data_rank
SQL中,字符串内容的单引号要双写进行转义
( data_title = 'Fonds d''écran'
AND class_name = 'com.android.settings.DeviceInfoSettings'
)