U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » Some unexpected differences between Sqlite3 and MySql in Upp

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Some unexpected differences between Sqlite3 and MySql in Upp [message #39712]

Fri, 19 April 2013 15:40

Alboni
Messages: 216
Registered: January 2012
Location: Kajaani, Finland

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

BioBytes
Messages: 308
Registered: October 2008
Location: France

Senior Member

Hello Alboni,

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

Regards

Biobytes

Report message to a moderator

Re: Some unexpected differences between Sqlite3 and MySql in Upp [message #39767 is a reply to message #39712]

Wed, 24 April 2013 23:17

Alboni
Messages: 216
Registered: January 2012
Location: Kajaani, Finland

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&

Report message to a moderator

Re: Some unexpected differences between Sqlite3 and MySql in Upp [message #39772 is a reply to message #39767]

Thu, 25 April 2013 14:33

BioBytes
Messages: 308
Registered: October 2008
Location: France

Senior 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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Apr 25 19:07:17 CEST 2025

Total time taken to generate the page: 0.02795 seconds