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 next message
Alboni is currently offline  Alboni
Messages: 203
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

Re: Some unexpected differences between Sqlite3 and MySql in Upp [message #39766 is a reply to message #39712] Wed, 24 April 2013 22:11 Go to previous messageGo to next message
BioBytes is currently offline  BioBytes
Messages: 288
Registered: October 2008
Location: France
Experienced Member
Hello Alboni,

Check your character encoding and
collation which may have an effect on case sensitivity.

Regards

Biobytes
Re: Some unexpected differences between Sqlite3 and MySql in Upp [message #39767 is a reply to message #39712] Wed, 24 April 2013 23:17 Go to previous messageGo to next message
Alboni is currently offline  Alboni
Messages: 203
Registered: January 2012
Location: Deventer, Netherlands
Experienced Member
I examined the code and different sql is generated.
See http://www.ultimatepp.org/forum/index.php?t=msg&th=7577& amp;start=0&
Re: Some unexpected differences between Sqlite3 and MySql in Upp [message #39772 is a reply to message #39767] Thu, 25 April 2013 14:33 Go to previous message
BioBytes is currently offline  BioBytes
Messages: 288
Registered: October 2008
Location: France
Experienced Member
Hello Alboni,

Thanks for the code snippet.

Perhaps could you have a look to the following link:

http://dev.mysql.com/doc/refman/4.1/en/case-sensitivity.html

Hope it could be helpful

Regards

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


Current Time: Fri Jan 22 04:38:58 CET 2021

Total time taken to generate the page: 0.01197 seconds