Paul McCullagh wrote:
On Mar 18, 2010, at 1:17 AM, Arjen Lentz wrote:
Hi Brian
On 18/03/2010, at 4:04 AM, Brian Aker wrote:
So Drizzle is case insensitive all the world around. AKA we follow
the standard in this regard no matter the operating system (with
MySQL by default the UNIX world is case sensitive,.. legacy of
everything be based on the file system).
Drizzle accomplishes this by doing case folding, aka we lower case
everything internally. All upper case make me THINK YOU ARE YELLING.
Here is the thing though, right now to make DD/IS look right I have
to play with case. Internally we see things as lower case, but
externally it seems like UPPER case for those table names seems correct.
This is really bikeshed to me. People's thoughts on the display?
There is BTW no requirement that a table function be upper case, I
just have done that when doing the create object. So no matter what
table functions will be whatever ever the author/creator calls them.
I prefer uppercase for keywords and lowercase for identifiers.
Is there a necessity to have infoschema uppercase? I find it hideously
unreadable.
Ditto on that!
Does the SQL standard state that uppercase names must be used?
That would be typical. Probably suggested by some Oracle guy because
Oracle only uses uppercase because it was invented before computers had
lowercase letters ;)
Paul,
here is a relevant excerpt from the SQL standard:
An <SQL language identifier> is equivalent to an <SQL language identifier> in
which every letter that is
a lower-case letter is replaced by the corresponding upper-case letter or
letters. This treatment includes
determination of equivalence, representation in the Information and Definition
Schemas, representation in
diagnostics areas, and similar uses.
Note that this does not cover delimited (double-quoted) identifiers, which are
compared regardless of case.
Thanks,
Roy
Regards,
Arjen.
--
Arjen Lentz, Exec.Director @ Open Query (http://openquery.com)
Exceptional Services for MySQL at a fixed budget.
Follow our blog at http://openquery.com/blog/
OurDelta: packages for MySQL and MariaDB @ http://ourdelta.org
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
--
Paul McCullagh
PrimeBase Technologies
www.primebase.org
www.blobstreaming.org
pbxt.blogspot.com
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
