Re: Table

Posted in 2012

Topics: Triggers, Constraints & Referential Integrity, Java & JDBC Development, Internationalization & Character Sets

Jack Parker — Fri, 20 Apr 2012 18:35:03 — source: IIUG Forums & Mailing Lists

As an oldtimer, I still keep my names under 12 or so. That said, there = are Java junkies out there - who are probably not on this list - who = think length of variable name is a freebie. That's probably why you = need at least 2GB to drive a laptop these days. j. On Apr 20, 2012, at 2:30 PM, Jonathan Leffler wrote: > We're trying to gauge whether anyone actually uses database object = names=20 > longer than half the maximum length of 128, so 64 characters or more = long.=20 > (Characters means bytes in code sets like ISO 8859-15; it means = characters=20 > in code sets like UTF-8 and GB18030.)=20 >=20 > Table in the subject line is a convenient shorthand for any database = object=20 > name: database, server, table, view, procedure, trigger, column, = index,=20 > UDT, etc.=20 >=20 > My guess is that there are very few names that long used in practice, = but I=20 > live and learn.=20 >=20 > --=20 > Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h>=20= > Guardian of DBD::Informix - v2011.0612 - http://dbi.perl.org=20 > "Blessed are we who can laugh at ourselves, for we shall never cease = to be=20 > amused."=20 >=20 > --f46d0408398956f15a04be207bdb=20 >=20 >=20 > = **************************************************************************= *****=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20= >=20

↪ replying to Jack Parker

Paul Watson — Fri, 20 Apr 2012 22:54:54 — source: IIUG Forums & Mailing Lists

They probably get paid by the letter typed :-) Cheers Paul > As an oldtimer, I still keep my names under 12 or so. That said, there = > are Java junkies out there - who are probably not on this list - who = > think length of variable name is a freebie. That's probably why you = > need at least 2GB to drive a laptop these days. > > j. > > On Apr 20, 2012, at 2:30 PM, Jonathan Leffler wrote: > >> We're trying to gauge whether anyone actually uses database object = > names=20 >> longer than half the maximum length of 128, so 64 characters or more = > long.=20 >> (Characters means bytes in code sets like ISO 8859-15; it means = > characters=20 >> in code sets like UTF-8 and GB18030.)=20 >>=20 >> Table in the subject line is a convenient shorthand for any database = > object=20 >> name: database, server, table, view, procedure, trigger, column, = > index,=20 >> UDT, etc.=20 >>=20 >> My guess is that there are very few names that long used in practice, = > but I=20 >> live and learn.=20 >>=20 >> --=20 >> Jonathan Leffler <jonathan.leffler@gmail.com> #include >> <disclaimer.h>=20= > >> Guardian of DBD::Informix - v2011.0612 - http://dbi.perl.org=20 >> "Blessed are we who can laugh at ourselves, for we shall never cease = > to be=20 >> amused."=20 >>=20 >> --f46d0408398956f15a04be207bdb=20 >>=20 >>=20 >> = > **************************************************************************= > *****=20 >> Forum Note: Use "Reply" to post a response in the discussion forum.=20= > >>=20 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > -- Paul Watson Tel: +1 913-674-0360 Mob: +1 913-387-7529 Web: www.oninit.com www.advancedatatools.com Failure is not as frightening as regret. If you want to improve, be content to be thought foolish and stupid. What this country needs are more unemployed politicians