FAQ:  Does ArcGIS work with objects or user names that contain special characters?

相关信息
Article ID: 40571
Software:
ArcSDE 8.1, 8.1.2, 8.2, 8.3, 9.0, 9.1, 9.2, 9.3, 9.3.1, 10, 10.1, 10.2, 10.2.1, 10.2.2
ArcGIS - ArcEditor 8.1, 8.1.2, 8.2, 8.3, 9.0, 9.1, 9.2, 9.3, 9.3.1, 10
ArcGIS - ArcInfo 8.1, 8.1.2, 8.2, 8.3, 9.0, 9.1, 9.2, 9.3, 9.3.1, 10
ArcGIS - ArcView 8.1, 8.1.2, 8.2, 8.3, 9.0, 9.1, 9.2, 9.3, 9.3.1, 10
ArcGIS for Desktop Advanced 10.1, 10.2, 10.2.1, 10.2.2, 10.3
ArcGIS for Desktop Standard 10.1, 10.2, 10.2.1, 10.2.2, 10.3
ArcGIS for Desktop Basic 10.1, 10.2, 10.2.1, 10.2.2, 10.3
Platforms: N/A

问题描述
Does ArcGIS work with objects or user names that contain special characters?
已邀请:

EsriSupport

赞同来自:

解决方案
All databases have rules that define what characters can be used in object names. Most allow the creation of object names containing unsupported characters provided the name is delimited with quote marks or brackets.

ArcGIS does not place delimiters around object names when querying the database. Therefore, if the database does not support the characters in an undelimited object name, ArcGIS cannot support them.

For example, even though Oracle allows the creation of a user name that contains a forward slash (/) or dollar sign ($) when created with quotes, ArcGIS queries the database with the unquoted user name, and the connection fails. Similarly, PostgreSQL allows the creation of mixed case object names, such as database names or table names, if the name is delimited when the object is created. However, when ArcGIS queries the database cluster with the undelimited, lower case name, the objects are not found.

Read the appropriate DBMS documentation for information on supported undelimited object names.

创建及修改时间
Created: 9/20/2012

Last Modified: 11/7/2014
原文链接
http://support.esri.com/en/kno ... 40571

要回复问题请先登录注册