Meaningless Drivel is fun!*
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
 
GeeCON Prague 2014
 
subject: HF-SQL - Database types