A variety of data types can be used with Symfoware Server.
Data types belonging to base data types are supported whether you automatically generate applications using tools in Visual Studio (Query Builder in TableAdapter and Server Explorer), or create applications yourself (with DataProvider).
Data Types | Supported | |
|---|---|---|
Operation in the Visual Studio integration window | Fujitsu Npgsql .NET Data Provider | |
character | Y | Y |
character varying | Y | Y |
national character | Y | Y |
national character varying | Y | Y |
text | Y | Y |
bytea | N | Y |
smallint | Y | Y |
integer | Y | Y |
bigint | Conditional (*1) | Y |
smallserial | Y | Y |
serial | Y | Y |
bigserial | Conditional (*1) | Y |
real | Y | Y |
double precision | Y | Y |
numeric | Y | Y |
decimal | Y | Y |
money | N | N |
date | Y | Y |
time with time zone | N | Conditional (*5) |
time without time zone | Y | Y |
timestamp without time zone | Y | Y |
timestamp with time zone | Y | Y |
interval | Conditional (*2) | Y |
boolean | Y | Y |
bit | Conditional (*3) | Conditional (*3) |
bit varying | N | N |
uuid | Conditional (*2) | Y |
inet | Conditional (*2, *4) | Conditional (*4) |
macaddr | N | Y |
cidr | N | N |
Geometric data type (point,lseg,box,path,polygon,circle) | N | Y |
array | N | Y |
oid | N | N |
xml | N | N |
json | N | N |
Types related to text searches(tsvector,tsquery) | N | N |
Enumerated type | N | N |
Composite type | N | N |
Range type | N | N |
Y: Supported
N: Not supported
*1: When used as a dynamic parameter, only data values in the int32 range can be substituted.
*2: When used as a dynamic parameter, it is not possible to substitute parameter values in DataGridView automatically generated by DDEX.
*3: Only lengths of 2 or longer are supported.
*4: Only single hosts are supported.
*5: When updating this data type, set the values as shown below:
The example here shows c3 being made the "time with time zone" data type.
DataRow dr = ds.Tables[0].Rows[ds.Tables[0].Rows.Count - 1]; dr["c3"] = new DateTimeOffset(2000, 1, 1, 0, 0, 0, new TimeSpan(9, 0, 0));
