Dmitry Yemanov wrote:

>"Jim Starkey" <jas@...> wrote:
>
>
>>"create domain rdb$user_name varchar(128) CHARACTER SET
>>UNICODE_FSS;",
>>
>>
>
>Strictly speaking, user names are SQL identifiers and hence they should be
>CHAR(31). As Claudio has pointed out, we don't support longer user names
>anyway, neither at the system tables level nor perhaps at the code level.
>The question is whether making it consistent really breaks something. Any
>customers have user names longer than 31 characters without anything granted
>to them?
>
>
>

The SQL standard specifies identifiers have a max length of 127 (if I
remember correctly). I built in 31 in 1982 because it was the VMS
standard and seemed generous. I would rather look forward than back.