Open topic with navigation

TIBCO GridServer® 7.1.0

# Data Type Mapping

The following table lists mappings for data types that vary depending on the database type.

Data Type | MS SQL | Oracle | PostgreSQL | HSQL
bigint | bigint | int | bigint | bigint
timestamp | datetime | timestamp | timestamp | timestamp
text | text | clob | text | longvarchar
varchar | varchar | varchar2 | varchar | varchar
identity | int not null identity | int (incl. sequence+trigger) | serial or bigserial not null | int generated by default as identity (start with 1) not null
bigidentity | bigint not null identity | int (incl. sequence+trigger) | bigint not null identity | int generated by default as identity (start with 1) not null

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO GridServer®

Copyright © 2001-2022. TIBCO Software Inc. All Rights Reserved.