Hi Vladimir,
>> Another note, () are also reserved in hostnames, so you could use
>> "(role)" which would be perfectly clear I think.
>
> Sure, but parentheses must also be escaped in most of scripting
> languages.
So must many other characters used in SQL: quotes, at-sign, etc. -- but
why does it matter? The user should basically almost never be using
that reserved value for anything. It would exist as a #define in the
code, and get stored in the column, but the user would only use the
role-specific commands to deal with it, thus never seeing that reserved
value.
Regards,
Jeremy
--
high performance mysql consulting
www.provenscaling.com
