语言切换为“法语”，设置 > 上方的搜索栏 > 输入任意字符 > 搜索

Question

报错说是 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

Answer 1

SQL中，字符串内容的单引号要双写进行转义

(    data_title = 'Fonds d''écran'
 AND class_name = 'com.android.settings.DeviceInfoSettings'
)