[table]
| | [b]postgresql [/b]| [b]sqlite [/b]| [b]sqlserver [/b]| [b]sybase [/b]| [b]db2 [/b]| [b]mysql [/b]| [b]openbase [/b]| [b]oracle [/b]|
|[b]binary [/b]| bytea | blob | image | image | blob(32768) | blob | object | blob |
|[b]boolean [/b]| boolean | boolean | bit | bit | decimal(1) | tinyint(1) | boolean | number(1) |
|[b]date [/b]| date | date | datetime | datetime | date | date | date | date |
|[b]datetime [/b]| timestamp | datetime | datetime | datetime | timestamp | datetime | datetime | date |
|[b]decimal [/b]| decimal | decimal | decimal | decimal | decimal | decimal | decimal | decimal |
|[b]float [/b]| float | float | float(8) | float(8) | float | float | float | number |
|[b]integer [/b]| integer | integer | int | int | int | int(11) | integer | number(38) |
|[b]string [/b]| (note 1) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | char(4096) | varchar2(255) |
|[b]text [/b]| text | text | text | text | clob(32768) | text | text | clob |
|[b]time [/b]| time | datetime | datetime | time | time | time | time | date |
|[b]timestamp [/b]| timestamp | datetime | datetime | timestamp | timestamp | datetime | timestamp | date |
[/table]
reference:
[url]http://www.blogjava.net/GavinMiao/archive/2011/09/06/358081.html[/url]
[url]http://blog.csdn.net/dengxingbo/article/details/5896314[/url]
[url]http://onlamp.com/onlamp/2001/09/13/aboutSQL.html[/url]
[url]http://www.java2s.com/Code/Java/Hibernate/JavaTypeVSHibernateType.htm[/url]
| | [b]postgresql [/b]| [b]sqlite [/b]| [b]sqlserver [/b]| [b]sybase [/b]| [b]db2 [/b]| [b]mysql [/b]| [b]openbase [/b]| [b]oracle [/b]|
|[b]binary [/b]| bytea | blob | image | image | blob(32768) | blob | object | blob |
|[b]boolean [/b]| boolean | boolean | bit | bit | decimal(1) | tinyint(1) | boolean | number(1) |
|[b]date [/b]| date | date | datetime | datetime | date | date | date | date |
|[b]datetime [/b]| timestamp | datetime | datetime | datetime | timestamp | datetime | datetime | date |
|[b]decimal [/b]| decimal | decimal | decimal | decimal | decimal | decimal | decimal | decimal |
|[b]float [/b]| float | float | float(8) | float(8) | float | float | float | number |
|[b]integer [/b]| integer | integer | int | int | int | int(11) | integer | number(38) |
|[b]string [/b]| (note 1) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | varchar(255) | char(4096) | varchar2(255) |
|[b]text [/b]| text | text | text | text | clob(32768) | text | text | clob |
|[b]time [/b]| time | datetime | datetime | time | time | time | time | date |
|[b]timestamp [/b]| timestamp | datetime | datetime | timestamp | timestamp | datetime | timestamp | date |
[/table]
reference:
[url]http://www.blogjava.net/GavinMiao/archive/2011/09/06/358081.html[/url]
[url]http://blog.csdn.net/dengxingbo/article/details/5896314[/url]
[url]http://onlamp.com/onlamp/2001/09/13/aboutSQL.html[/url]
[url]http://www.java2s.com/Code/Java/Hibernate/JavaTypeVSHibernateType.htm[/url]