更新時間：2021-05-15 09:29:35作者：網(wǎng)絡(luò)
"0|涓婁紶鏂囦歡鎴愬姛錛?是這里導(dǎo)致語法錯誤？亂碼之后丟了結(jié)束的雙引號？
插入字符的編碼和讀出時用的編碼要一致，就是說：假設(shè)，數(shù)據(jù)庫中數(shù)據(jù)是你通過android代碼插入，以GB2312編碼格式，如：1<a target="_blank" class="baidu-highlight">db</a>.execSQL("insert into question_tb values(?,?,?,?,?,?,?)",new String(val,"gb2312"));插入到表：1234567891011121314151617"Create table IF NOT EXISTS question_tb(" +"code int," +"is_finished int," +"is_english int,"+"pic_name varchar(64)," +"ans_back <a target="_blank" class="baidu-highlight">BLOB</a>," +"ans_true varchar(64)," +"info int"+")";讀出就是：12345678910111213byte[] val = cursor.get<a target="_blank" class="baidu-highlight">Blob</a>(cursor.getColumnIndex("ans_back")); String <a target="_blank" class="baidu-highlight">sn</a>;try { <a target="_blank" class="baidu-highlight">sn</a> = new String(val,"gb2312");} catch (UnsupportedEncodingException e) {e.printStackTrace();}就是說，插入和讀取要么都做轉(zhuǎn)換，要么都不做（android默認UTF-8格式）。