HF-SQL - Database types

[Francisco Moroyoqui]

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]

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?

[Surasak Leenapongpanit]

To make sure you use the data types correctly, please check the document of that dbms you are involve.

[Lynn Beighley]

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.