Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
up vote 9 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

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

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

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

UPDATE:

I've already find this explanation of Microsoft about reserved words for Microsoft Access. and....oh surprise!!! "LONG" appears!!!

List of reserved words in Access 2002 and in later versions of Access

This article lists words and symbols that you should not use in field, object, and variable names in Microsoft Access 2002 and later versions of Access because they are "reserved words." Reserved words have a specific meaning to Access or to the Microsoft Jet database engine. If you use a reserved word or symbol, you may receive an error such as the following:

The wizard was unable to preview your report, possibly because a table needed by your report is exclusively locked.

If you use a reserved word, such as date, value, name, text, and year, in Access 2007, you may receive the following message:

The Name you supplied is a reserved word. Reserved words have a specific meaning to Microsoft Office Access or to the Microsoft Office Access database engine

For existing objects with names that contain reserved words, you can avoid errors by surrounding the object name with brackets ([ ]).

share|improve this answer

We're looking for long answers that provide some explanation and context. Don't just give a one-line answer; explain why your answer is right, ideally with citations. Answers that don't include explanations may be removed.

2  
This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post - you can always comment on your own posts, and once you have sufficient reputation you will be able to comment on any post. - From Review – Kersten Feb 5 at 14:59

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.