Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

Relating to my question about the split tool here, as suggested I ask a new question: is there any place with a list of invalid characters to use in a database in ArcGIS 10?

edit: It is in relation to the error I got before which is "The name starts with an invalid character". It didn't say where beyond that.

share|improve this question
1  
Clarify your question. Invalid where? column names? Indexes names? table names? actual row data? –  George Jul 27 '11 at 16:43
    
The error she received was "000361 : The name starts with an invalid character". This indicates an invalid table or field name. Emily, have you tried renaming the fields in the shape file to contain only alphanumerics and to not start with numbers? I don't know if an underscore is allowed at the beginning of a column name in a geoDB, and can't test at the moment. –  user3461 Jul 27 '11 at 16:50
    
All of the fields start with a lowercase alphabetical character. –  Emily Jul 27 '11 at 17:04
    
what are the names in lowercase? –  Mapperz Jul 27 '11 at 17:45
    
What database format are you using? shapefile, personal gdb, file gdb, SDE? Each one has its own set of potential possibilities. –  RyanDalton Jul 27 '11 at 20:02
show 1 more comment

4 Answers 4

up vote 6 down vote accepted

I am guessing you are referring to "Reserved Words" and special characters. Take a look at the following links, but ultimately reserved words and reserved characters are going to be more DATABASE (shapefile, MS Access, Oracle, SQL Server, etc) dependent vs ARCGIS dependent.

ESRI KB- What characters should not be used in ArcGIS for field names and table names?

ESRI Forum- .dbf files/naming conventions

ESRI Blog- Words (by Reservation Only)

share|improve this answer
add comment

I don't know about a definitive, complete list, because it depends on the DBMS, but ArcObjects and arcpy/arcgisscripting have functions for helping you write valid SQL queries and validate table/field names. ArcObjects also has DBMS-specific invalid character lists.

GP methods:

ArcObjects methods:

share|improve this answer
add comment

From personal experience you should make sure that names (1) begin with a letter, (2) contain no spaces, (3) contain 7 or fewer characters, and (4) only use alphanumeric characters.

share|improve this answer
    
Are you referring to geodatabases other then PGDB / FGDB? Because in the desktop environment PGDB / FGDB you can begin table or a feature class name with an underscore, use an underscore anywhere in the name. Feature Class and Table names in an FGDB can have 160 characters and field names 64 characters. No special limitation on the number of numeric characters other that the names cannot begin with a number. –  Jakub Jul 28 '11 at 13:08
add comment

Remember, too, that ESRI appends to names you give columns etc, and if you don't pay attention, you could go over the permitted width for columns, table names etc. I think 22 is the magic number on that. also, this will depend on the RDBMS you se, and each one will be different.

share|improve this answer
    
I've never heard of this but would be interested in learning more. Can you provide an example of what you are describing? Or link to any documentation for others to get a better understanding? Also, an explanation of where the 22 character limit comes from? –  RyanDalton Jul 28 '11 at 16:07
    
I think it is a limitation on Oracle, in that you can only have column names of 30 cahrs. However, the other day, I was creating am mosaic, it had a long field name, which was rejected. On delving deeper, I found that ArcGIS was appending characters to the column/field name and this was taking it over the Oracle limit. By elimination, and studying what was being appended, I came to the 22 char rule. –  Hairy Aug 1 '11 at 7:28
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.