Wednesday, April 9, 2014

sqlite execution results are not the same problems in computers and mobile phones


Table Table, field sname, to deal with the status display.

Wrote a condition update statement:
update Table
set
sname =
case when sname = 'local has completed' then 'Local has completed (including competing products)'
else 'local has completed (competing products)' end
where rowid = @ rowid

In the PC, using SQLite Expert on sname value is not "local completed" line, run this statement,
The result is "local Completed (competing products)";
But in the end of the phone, turned into a "local has completed (including competing products)."

Not sure what the problem is, please enlighten me great God, thank you.
<-! Main posts under Banner (D4) -><-! Posts under the main text (D5) ->
Reply:
You try to try on a mobile phone into English
Reply:
LS phones SQLite database "Local completed" this record may already exist. If the data is empty, then you can add a data first, or the modification of existing records into other original content try again. If that does not work, the problem may be encoded in the database character set.

No comments:

Post a Comment