[Info-ingres] database name length

[Martin Bowes]

The Command reference guide says:

dbname

Specifies the name of the database to be created. The name must be unique and begin with an alphabetic character. The name can have a maximum of 24 alphanumeric characters (the underscore is also allowed).



The iidatabase catalog allows 32 characters and specifying a name longer than 24 is ok as long as its unique in the first 24 characters.



Other than a STAR coordinator database name default being 'ii' plus the local database name I can't think of a good reason for any restriction unless the '/server_class' is getting involved for some reason.



Marty





-----Original Message-----
From: Karl and Betty Schendel [mailto:schendel at kbcomputer.com]
Sent: 09 November 2016 12:01
To: Ingres and related product discussion forum
Subject: Re: [Info-ingres] database name length



Because someone forgot to use the correct length symbol, maybe?



I know of no reason.



> On Nov 9, 2016, at 7:53 AM, Martin Bowes <martin.bowes at ndph.ox.ac.uk<mailto:martin.bowes at ndph.ox.ac.uk>> wrote:

>

> Hi All,

>

> Why does a database name have to be unique in its first 24 characters?

>

> E_DU3022_DB_UNIQUE_CR

> The database name not unique in first 24 characters, this_is_a_very_silly_dat* .

>

> Martin Bowes

> _______________________________________________

> Info-ingres mailing list

> Info-ingres at lists.planetingres.org<mailto:Info-ingres at lists.planetingres.org>

> http://lists.planetingres.org/mailman/listinfo/info-ingres



_______________________________________________

Info-ingres mailing list

Info-ingres at lists.planetingres.org<mailto:Info-ingres at lists.planetingres.org>

http://lists.planetingres.org/mailman/listinfo/info-ingres
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20161109/69a3ce94/attachment.html>