diff options
author | Francisco Figueiredo Jr. <fxjr@mono-cvs.ximian.com> | 2004-02-11 02:54:46 +0300 |
---|---|---|
committer | Francisco Figueiredo Jr. <fxjr@mono-cvs.ximian.com> | 2004-02-11 02:54:46 +0300 |
commit | a8e3e613a37b23c61da2547044c30075cd877768 (patch) | |
tree | 283b2091126ef706df82801a7114447ac1226c30 /mcs/class/Npgsql/NpgsqlTypes | |
parent | 4fa780dfa7227b782d95991e8f219a0ee7d73bc1 (diff) |
2004-02-10 Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br>
* Added support for datetime and time datatypes with timezone data. Thanks Sami Kuhmonen (sami@iqs.fi).
svn path=/trunk/mcs/; revision=22964
Diffstat (limited to 'mcs/class/Npgsql/NpgsqlTypes')
-rwxr-xr-x | mcs/class/Npgsql/NpgsqlTypes/NpgsqlTypesHelper.cs | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/mcs/class/Npgsql/NpgsqlTypes/NpgsqlTypesHelper.cs b/mcs/class/Npgsql/NpgsqlTypes/NpgsqlTypesHelper.cs index ef5a4da39b2..b98f38aedbe 100755 --- a/mcs/class/Npgsql/NpgsqlTypes/NpgsqlTypesHelper.cs +++ b/mcs/class/Npgsql/NpgsqlTypes/NpgsqlTypesHelper.cs @@ -137,6 +137,7 @@ namespace NpgsqlTypes return IPAddress.NetworkToHostOrder(BitConverter.ToInt64(data, 0)); case DbType.String: case DbType.AnsiString: + case DbType.StringFixedLength: return encoding.GetString(data, 0, fieldValueSize); default: throw new NpgsqlException("Type not supported in binary format"); @@ -266,6 +267,7 @@ namespace NpgsqlTypes case DbType.String: case DbType.AnsiString: + case DbType.StringFixedLength: return data; default: throw new NpgsqlException(String.Format(resman.GetString("Exception_TypeNotSupported"), oidToNameMapping[typeOid])); @@ -321,6 +323,7 @@ namespace NpgsqlTypes return Type.GetType("System.DateTime"); case DbType.String: case DbType.AnsiString: + case DbType.StringFixedLength: return Type.GetType("System.String"); default: throw new NpgsqlException(String.Format(resman.GetString("Exception_TypeNotSupported"), oidToNameMapping[typeOid])); @@ -358,7 +361,7 @@ namespace NpgsqlTypes // Bootstrap value as the datareader below will use ConvertStringToNpgsqlType above. //oidToNameMapping.Add(26, "oid"); - NpgsqlCommand command = new NpgsqlCommand("select oid, typname from pg_type where typname in ('bool', 'bytea', 'date', 'float4', 'float8', 'int2', 'int4', 'int8', 'numeric', 'text', 'time', 'timestamp');", conn); + NpgsqlCommand command = new NpgsqlCommand("select oid, typname from pg_type where typname in ('bool', 'bytea', 'date', 'float4', 'float8', 'int2', 'int4', 'int8', 'numeric', 'text', 'time', 'timestamp', 'timestamptz', 'timetz');", conn); NpgsqlDataReader dr = command.ExecuteReader(); @@ -404,9 +407,11 @@ namespace NpgsqlTypes type = DbType.Decimal; break; case "time": + case "timetz": type = DbType.Time; break; case "timestamp": + case "timestamptz": type = DbType.DateTime; break; default: |