Maximum Characters for field name

Posts   
 
    
Posts: 40
Joined: 26-Nov-2004
# Posted on: 03-Mar-2005 18:24:22   

Hi Guys,

The only database we use here is Sql Server and I know the there is a limit of 64 characters for naming table fields. We are about to start a new project and push it to other db types.

Being a lazy git, i thought i get the collective's knowledge for the others. My main concern is oracle.

I remember sometime ago, and may be I am wrong, was there an issue with LLBLGen Pro and field name lengths?

Cheers guys,

Gareth

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39933
Joined: 17-Aug-2003
# Posted on: 03-Mar-2005 18:44:40   

On oracle, keep names below 30 characters. using names longer than 30 characters for tables will make you run into problems. For entities this doesn't matter, just the table/field names simple_smile

Frans Bouma | Lead developer LLBLGen Pro
Posts: 40
Joined: 26-Nov-2004
# Posted on: 03-Mar-2005 21:17:29   

Cheers.