Database datatype comparison sheet
Sometimes when writing automated SQL injection tools or exploit based on SQLi vulnerabilities you can fight with the different implementation of standard SQL datatype of DBMS.
Reading a lot of documentation i wrote a comparison sheet between datatypes used by Mysql, SQL Server, Oracle, DB2, SQLite, PostgreSQL, Sybase ASE, Firebird.
You can download Adobe Acrobat [PDF] or OpenOffice [ODS].
References:
- http://www-css.fnal.gov/dsg/external/freeware/mysql-vs-pgsql.html
- http://dev.mysql.com/doc/refman/5.0/en/data-types.html
- http://dev.mysql.com/doc/refman/5.0/en/data-type-overview.html
- http://troels.arvin.dk/db/rdbms/#data_types
- http://www.linuxnetworks.de/doc/index.php/OpenDBX/DBMS_Datatypes
- http://www.peachpit.com/articles/article.aspx?p=30885&seqNum=7
- http://download-west.oracle.com/docs/cd/B12037_01/server.101/b10759/sql_elements001.htm
- http://technet.microsoft.com/en-us/library/ms187752.aspx
- http://publib.boulder.ibm.com/infocenter/iwedhelp/v6r0/index.jsp?topic=/com.ibm.db2e.doc/dbsap_b8.html
Did you enjoy this post? Why not leave a comment below and continue the conversation, or subscribe to my feed and get articles like this delivered automatically to your feed reader.






















Comments
No comments yet.
Leave a comment