U++ Forum - RDF feed
https://www.ultimatepp.org/forums/
Some unexpected differences between Sqlite3 and MySql in Upp
https://www.ultimatepp.org/forums/index.php?t=rview&goto=39712&th=7579#msg_39712
1)Like() is always case INsensitive, regardless of parameter.
2)SqlSum(INT_FIELD) is type int when Fetching.
3)Query results are by default sorted ascending using the primary key.
MySql
1)Like() is always case sensitive, regardless of parameter.
2)SqlSum(INT_FIELD) is type String when Fetching.
3)Queryresults are not sorted by default.
]]>Alboni2013-04-19T13:40:11-00:00Re: Some unexpected differences between Sqlite3 and MySql in Upp
https://www.ultimatepp.org/forums/index.php?t=rview&goto=39766&th=7579#msg_39766
Check your character encoding and
collation which may have an effect on case sensitivity.
Regards
Biobytes]]>BioBytes2013-04-24T20:11:13-00:00Re: Some unexpected differences between Sqlite3 and MySql in Upp
https://www.ultimatepp.org/forums/index.php?t=rview&goto=39767&th=7579#msg_39767
See http://www.ultimatepp.org/forum/index.php?t=msg&th=7577& amp;start=0&]]>Alboni2013-04-24T21:17:31-00:00Re: Some unexpected differences between Sqlite3 and MySql in Upp
https://www.ultimatepp.org/forums/index.php?t=rview&goto=39772&th=7579#msg_39772
Thanks for the code snippet.
Perhaps could you have a look to the following link: