Recently, I have investigated the failure of searching for short MMs in multi-language mode. When the mobile phone system language is set to English (Spanish, Turkey etc), the search is successful, but the language is Hindi and Arabic, an error occurs:
E/XXX: Got exception: Android. database. SQLite. sqliteexception:
No such column: Unsupported partition usage:, while compiling: Select PDU. _ id, thread_id, ADDR. address, part. text as body, PDU. date from PDU, part, ADDR where (part. mid = PDU. _ id) and (ADDR. msg_id = PDU. _ id) and
(ADDR. type = partition) and (Part. Ct = 'text/plain ') group by thread_id order by thread_id ASC, date DESC
The query statement is as follows:
String mmsquery = string. Format (
"Select % s from PDU, part, ADDR, words where (part. Mid = PDU. _ id) and" +
"(ADDR. msg_id = PDU. _ id) and" +
"(ADDR. type = % d) and" +
"(Part. Ct = 'text/plain '))",
Mmsprojection,
Pduheaders.)
In Arabic, the upper limit represents the number "151",
ADDR. Type obtains the integer value. The decimal value of pduheaders. To is 151.
It seems that the value of pduheaders. To is expressed in the local language. Arabic numerals are used for Chinese, English, and Spanish, so there is no problem.
Has anyone ever encountered this problem? How can this problem be solved?