Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
Home » U++ Library support » U++ SQL » Some unexpected differences between Sqlite3 and MySql in Upp
Some unexpected differences between Sqlite3 and MySql in Upp [message #39712] Fri, 19 April 2013 15:40 Go to previous message
Alboni is currently offline  Alboni
Messages: 214
Registered: January 2012
Location: Deventer, Netherlands
Experienced Member
Sqlite3:

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.

[Updated on: Thu, 25 April 2013 18:57]

Report message to a moderator

 
Read Message
Read Message
Read Message
Read Message
Previous Topic: Select from two temporary tables
Next Topic: Sqlite foreign key question
Goto Forum:
  


Current Time: Fri Mar 29 02:03:21 CET 2024

Total time taken to generate the page: 0.00883 seconds