File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
HF-SQL - Database types
Joined: Nov 24, 2004
Oct 16, 2007 15:25:00
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?
Joined: Apr 14, 2004
Oct 17, 2007 02:39:00
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?
Joined: May 10, 2002
Oct 17, 2007 11:22:00
To make sure you use the data types correctly, please check the document of that dbms you are involve.
Joined: Sep 12, 2007
Oct 17, 2007 11:35:00
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
CMP vs BMP
Scalar vs Non-Scalar
Property Files Vs Database table
select * vs select column1,column2 ..
Performance - XA Vs Non XA
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015