File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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 and Relational Databases
Bookmark "HF-SQL - Database types" Watch "HF-SQL - Database types" New topic

HF-SQL - Database types

Francisco Moroyoqui

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?

Paul Sturrock

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
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:
subject: HF-SQL - Database types
It's not a secret anymore!