IDatabaseMetaData.TypeInfo Property
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Get a list of the standard SQL types supported by this database.
public Java.Sql.IResultSet? TypeInfo { [Android.Runtime.Register("getTypeInfo", "()Ljava/sql/ResultSet;", "GetGetTypeInfoHandler:Java.Sql.IDatabaseMetaDataInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")] get; }[<get: Android.Runtime.Register("getTypeInfo", "()Ljava/sql/ResultSet;", "GetGetTypeInfoHandler:Java.Sql.IDatabaseMetaDataInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")>]
member this.TypeInfo : Java.Sql.IResultSetProperty Value
a ResultSet object in which each row is an SQL type description
- Attributes
Exceptions
a database error occurred.
Remarks
Retrieves a description of all the data types supported by this database. They are ordered by DATA_TYPE and then by how closely the data type maps to the corresponding JDBC SQL type. If the database supports SQL distinct types, then getTypeInfo() will return a single row with a TYPE_NAME of DISTINCT and a DATA_TYPE of Types.DISTINCT. If the database supports SQL structured types, then getTypeInfo() will return a single row with a TYPE_NAME of STRUCT and a DATA_TYPE of Types.STRUCT. If SQL distinct or structured types are supported, then information on the individual types may be obtained from the getUDTs() method. Each type description has the following columns: TYPE_NAME String => Type name; DATA_TYPE int => SQL data type from java.sql.Types; PRECISION int => maximum precision; LITERAL_PREFIX String => prefix used to quote a literal (may be null); LITERAL_SUFFIX String => suffix used to quote a literal (may be null); CREATE_PARAMS String => parameters used in creating the type (may be null); NULLABLE short => can you use NULL for this type; typeNoNulls - does not allow NULL values; typeNullable - allows NULL values; typeNullableUnknown - nullability unknown; CASE_SENSITIVE boolean=> is it case sensitive; SEARCHABLE short => can you use "WHERE" based on this type:; typePredNone - No support; typePredChar - Only supported with WHERE.. LIKE; typePredBasic - Supported except for WHERE.. LIKE; typeSearchable - Supported for all WHERE; UNSIGNED_ATTRIBUTE boolean => is it unsigned; FIXED_PREC_SCALE boolean => can it be a money value; AUTO_INCREMENT boolean => can it be used for an auto-increment value; LOCAL_TYPE_NAME String => localized version of type name (may be null); MINIMUM_SCALE short => minimum scale supported; MAXIMUM_SCALE short => maximum scale supported; SQL_DATA_TYPE int => unused; SQL_DATETIME_SUB int => unused; NUM_PREC_RADIX int => usually 2 or 10 The PRECISION column represents the maximum column size that the server supports for the given datatype. For numeric data, this is the maximum precision. For character data, this is the length in characters. For datetime datatypes, this is the length in characters of the String representation (assuming the maximum allowed precision of the fractional seconds component). For binary data, this is the length in bytes. For the ROWID datatype, this is the length in bytes. Null is returned for data types where the column size is not applicable.
Java reference for java.sql.DatabaseMetaData.getTypeInfo.
Portions of this page are modifications based on work created and shared by the Android Open Source Project and used according to terms described in the Creative Commons 2.5 Attribution License.