Hi,

It appears the database name length is 40. That probably fits most
people. I want it increased to say 80, if posible...

Here's why (but if someone can show me a different approach, I will
drop the request):

I have a case where customers will all keep data on the same server,
however they all have different sets of data. I was thinking using a
GUID for each customer would be great, however, if an admin will have
to manage the mess, the name of the database must be connected with the
name of the customer, so, I added the name of the customer to the GUID.

I could have database names like:
ABCCUSTOMERXXX-9B27A24391274FD5BFAEB5438777523B

This is when I found out 40 chars is really, really small I don't
have much control on customer names, but say I could do some tricks and
limit it to 20-30 chars.

Now, since I have to think preemptiv, in the future there could be even
different applications distributed and again storing all the data for
different customers, on the same server (why not, at least thats how I
think I may want it), so I will even need to make a difference between
apps too, but here I have control and I could limit myself to a 10
chars application code. In this case I would have database names like:

ABCCUSTOMERXXX-KILLERAPP1-9B27A24391274FD5BFAEB5438777523B
ABCCUSTOMERXXX-KILLERAPP2-FD5BF77523BAEB59B27A243912744387


Has anyone encountered something similar, what solutions do you guys
have or think of?


regards,
Lucian

> Has anyone encountered something similar, what solutions do you guys
> have or think of?

Okay I could recompile edbmanager/edbserver and change the db name
length, however, I'm still a beginner with edb and don't want to do
that...


thx,
Lucian

You can have folder names like
9B27A24391274FD5BFAEB5438777523B

but you can't have database names like that.

Can this restriction be eliminated ?

Lucian

Lucian,

<< It appears the database name length is 40. That probably fits most
people. I want it increased to say 80, if posible... >>

Hmm, I'm not sure if I can or want to do that.  Is there any reason why you
can't just use a unique customer name for each database ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Lucian,

<< You can have folder names like
9B27A24391274FD5BFAEB5438777523B

but you can't have database names like that.

Can this restriction be eliminated ? >>

In general, valid identifiers in ElevateDB must begin with an alpha
character or an underscore (_).

--
Tim Young
Elevate Software
www.elevatesoft.com

> In general, valid identifiers in ElevateDB must begin with an alpha
> character or an underscore (_).

I understand that, but most of the time I matched the database name
with the folder name, so in this case ... I can have a folder name that
starts with a digit but not a database. So it's not possible I take it?

thx
Lucian

> Hmm, I'm not sure if I can or want to do that.  Is there any reason
> why you can't just use a unique customer name for each database ?

Yes, I could have a customer using more than one application, storing
data for both apps on the same server, but data is different so I'd
like different database name for that so that it can be easily viewed
in edb manager. And this is when complications start.

Lucian

Lucian,

<< Yes, I could have a customer using more than one application, storing
data for both apps on the same server, but data is different so I'd like
different database name for that so that it can be easily viewed in edb
manager. And this is when complications start. >>

What do you mean by "data is different", in this context ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Lucian,

Are you saying that the data is different for each combination of
customer+application name ?  If so, then why not just use that combination
for the database name ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Lucian,

<< I understand that, but most of the time I matched the database name with
the folder name, so in this case ... I can have a folder name that starts
with a digit but not a database. So it's not possible I take it? >>

It's possible, but not standard.  Identifiers are normally not allowed to
begin with numbers.  Most languages are like that.

--
Tim Young
Elevate Software
www.elevatesoft.com