Re: When did 8 character username restriction change?

"Art S. Kagel" wrote: > > Fuzzy wrote: > > > > Hi all, > > > > I'm trying to figure out when usernames/userid's where allowed to be > > longer than eight characters. > > > > In 7.12 (yeah, I know that's old), I used to get good old -576 errors > > if I tried to use ids longer than 8 characters. Now, in IFS2000, I > > can go crazy (e.g. I have a used "bloodylongusername" successfully.) > > > > Does anyone know when (i.e. what version) the limit was > > removed/increased? > > Long identifiers were introduced in 9.20 (IDS.2000/IIF.2000). All > identifiers (ie tablenames, columnnames, databasenames, etc) are now 128 > bytes long rather than 18 bytes and usernames are now restricted to 32 bytes > rather than 8. Gees, I have users now who call chunks ...._chunk, dbspaces ...._dbs, databases ...._db, tables ...._table, views ...._view, etc. Well views are okay, but can you imagine what they can do with 128 characters? Instead of a table called 'a_table', they can have 'i_have_created_a_little_table_which_we_will_call_a_table'. They should have reduced it from 18, not increased it. :-) Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |This email will self-destruct in |/// / ////| | |10 sec. If you received this email |// / /////| | |in error, sorry about the mess. |/ ////////| +----------------------+-----------------------------------+-----------+