U++ framework: U++ SQL » Lowercase field name in table

Home » U++ Library support » U++ SQL » Lowercase field name in table - error

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

Re: Lowercase field name in table - error [message #36798 is a reply to message #36795]

Fri, 06 July 2012 09:05

mirek
Messages: 14291
Registered: November 2005

Ultimate Member

Sender Ghost wrote on Thu, 05 July 2012 12:32

In opposite of uppercase, I read about lowercase identifiers on MySQL documentation.

Actually, if anything, I believe that above link is more or less supportive to make everything uppercase.

If you consider

sql.Execute("SELECT COUNT(*) cnt FROM info");

then it is not unlikely that some DB returns "CNT".

As case sensitivity itself is DB dependent issue, having everything insensitive and upper-case on U++ side seems like the most prudent option.

Mirek

Report message to a moderator

[Message index]

		Lowercase field name in table - error By: mezise on Sat, 30 June 2012 00:51
		Re: Lowercase field name in table - error By: mirek on Wed, 04 July 2012 15:25
		Re: Lowercase field name in table - error By: mezise on Thu, 05 July 2012 09:49
		Re: Lowercase field name in table - error By: mirek on Thu, 05 July 2012 10:01
		Re: Lowercase field name in table - error By: mezise on Thu, 05 July 2012 11:01
		Re: Lowercase field name in table - error By: mirek on Thu, 05 July 2012 11:11
		Re: Lowercase field name in table - error By: mezise on Thu, 05 July 2012 11:57
		Re: Lowercase field name in table - error By: Sender Ghost on Thu, 05 July 2012 18:32
		Re: Lowercase field name in table - error By: mezise on Thu, 05 July 2012 19:52
		Re: Lowercase field name in table - error By: mirek on Fri, 06 July 2012 09:05
		Re: Lowercase field name in table - error By: Sender Ghost on Fri, 06 July 2012 10:25

Previous Topic:	What does this code do exactly?
Next Topic:	Cannot connect to MySQL database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Sep 08 16:35:29 GMT+2 2026

Total time taken to generate the page: 0.00872 seconds