wood burning stoves 2.0*
The moose likes JDBC and the fly likes HF-SQL - Database types Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "HF-SQL - Database types" Watch "HF-SQL - Database types" New topic
Author

HF-SQL - Database types

Francisco Moroyoqui
Greenhorn

Joined: Nov 24, 2004
Posts: 6
Hi Lynn,

Are database column types covered in the book? If so, I would think that they would be very RDBMS-specific (Oracle vs MySQL vs MSSQL vs etc). Do you explain then the differences among some of them?

Thanks.
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336


I would think that they would be very RDBMS-specific

You are aware that there are ANSI standards for datatypes which all good relational databases implement?


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Surasak Leenapongpanit
Ranch Hand

Joined: May 10, 2002
Posts: 341
To make sure you use the data types correctly, please check the document of that dbms you are involve.
Lynn Beighley
author
Ranch Hand

Joined: Sep 12, 2007
Posts: 82
Indeed, column types between database flavors are very similar. There are some syntactical and structural differences, but once you understand how to use, say, a variable character text data type, then the actual DBMS syntax can be looked up.


Lynn Beighley<br />Author, Head First SQL
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: HF-SQL - Database types
 
Similar Threads
Performance - XA Vs Non XA
Scalar vs Non-Scalar
CMP vs BMP
select * vs select column1,column2 ..
Property Files Vs Database table