Max length of field name

[rzr]

Hello... is there a restriction on what the max lenght of a field name should be?
can a field name be 16-20 characters in lenght ? ex: XXX-XXX-XXX-XXX

10.2A / Windows

 

[RealHeavyDude]

Yes there is. The limit for the length of names of database objects is 32 characters. As of 10.1c this is also true for temp tables.

Heavy Regards, RealHeavyDude.

 

[rzr]

Thanks RHD.... is it a good practice to have '-' within field names ?

 

[TomBascom]

"-" is problematic when dealing with data servers and SQL-92 access. It is better to use "_".

 

[RealHeavyDude]

IMHO it is bad practice.

As soon as you leave the 4GL world chances are that hyphens are not supported without a fuzz by the other technologies, most prominently SQL, Java ...

Heavy Regards, RealHeavyDude.

 

[RealHeavyDude]

There are also other features which are problematic in other technologies like having database fields with extents (1-dimensional array) ...


Heavy Regards, RealHeavyDude.

 

[rzr]

thank you !