3 Replies Latest reply on Feb 4, 2003 1:33 PM by Jeffrey Cantrill

    MS Access 2000 type mapings

    Jeffrey Cantrill Newbie

      In case anyone is interested, attached are the jaws.xml type mapping for MS Access 2000. I'm also including the access data types that I found on Microsoft's website in case you see that I've missed something.

        • 1. Re: MS Access 2000 type mapings
          Jeffrey Cantrill Newbie

          missing files........hopefully they will remain this time.

          • 3. Re: MS Access 2000 type mapings
            Jeffrey Cantrill Newbie

            <?xml version="1.0" encoding="UTF-8"?>


            AccessDS
            <type-mapping>MS Access2000</type-mapping>
            true

            <default-entity>
            <create-table>true</create-table>
            <remove-table>false</remove-table>
            <tuned-updates>true</tuned-updates>
            <read-only>false</read-only>
            <time-out>300</time-out>
            <select-for-update>false</select-for-update>
            </default-entity>

            <type-mappings>
            <type-mapping>
            MS Access2000

            <java-type>java.lang.String</java-type>
            <jdbc-type>VARCHAR</jdbc-type>
            <sql-type>VARCHAR(255)</sql-type>


            <java-type>java.lang.Integer</java-type>
            <jdbc-type>INTEGER</jdbc-type>
            <sql-type>INTEGER</sql-type>


            <java-type>java.math.BigInteger</java-type>
            <jdbc-type>BIGINT</jdbc-type>
            <sql-type>Integer</sql-type>


            <java-type>java.lang.Float</java-type>
            <jdbc-type>FLOAT</jdbc-type>
            <sql-type>FLOAT</sql-type>


            <java-type>java.lang.Double</java-type>
            <jdbc-type>DOUBLE</jdbc-type>
            <sql-type>DOUBLE</sql-type>


            <java-type>java.math.BigDecimal</java-type>
            <jdbc-type>NUMERIC</jdbc-type>
            <sql-type>NUMERIC</sql-type>


            <java-type>java.lang.Short</java-type>
            <jdbc-type>SMALLINT</jdbc-type>
            <sql-type>SMALLINT</sql-type>


            <java-type>java.lang.Long</java-type>
            <jdbc-type>BIGINT</jdbc-type>
            <sql-type>LONG</sql-type>


            <java-type>java.lang.Byte</java-type>
            <jdbc-type>TINYINT</jdbc-type>
            <sql-type>TINYINT</sql-type>


            <java-type>java.lang.Character</java-type>
            <jdbc-type>CHAR</jdbc-type>
            <sql-type>CHAR(1)</sql-type>


            <java-type>java.lang.Object</java-type>
            <jdbc-type>JAVA_OBJECT</jdbc-type>
            <sql-type>OLEOBJECT</sql-type>



            <java-type>java.sql.Timestamp</java-type>
            <jdbc-type>TIMESTAMP</jdbc-type>
            <sql-type>DateTime</sql-type>



            <java-type>java.sql.Date</java-type>
            <jdbc-type>DATE</jdbc-type>
            <sql-type>DATE</sql-type>



            <java-type>java.sql.Time</java-type>
            <jdbc-type>TIME</jdbc-type>
            <sql-type>TIME</sql-type>



            <java-type>java.util.Date</java-type>
            <jdbc-type>DATE</jdbc-type>
            <sql-type>DATA</sql-type>



            <java-type>java.lang.Boolean</java-type>
            <jdbc-type>BIT</jdbc-type>
            <sql-type>YESNO</sql-type>

            </type-mapping>
            </type-mappings>



            http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acfundsql.asp

            Following is a table that lists the basic Jet text data types, various synonyms, and the number of bytes allocated for each.

            Jet Data Type Synonyms Storage Size
            TEXT: TEXT, TEXT(n), CHAR, CHAR(n), ALPHANUMERIC, ALPHANUMERIC(n), STRING, STRING(n), VARCHAR, VARCHAR(n), NTEXT(n), NCHAR, NCHAR(n), CHAR VARYING, CHAR VARYING(n), CHARACTER VARYING, CHARACTER VARYING(n), NATIONAL CHAR, NATIONAL CHAR(n), NATIONAL CHARACTER, NATIONAL CHARACTER(n), NATIONAL CHAR VARYING, NATIONAL CHAR VARYING(n), NATIONAL CHARACTER VARYING, NATIONAL CHARACTER VARYING(n) Up to 255 characters, 2 bytes per character unless compressed
            MEMO: LONGTEXT, LONGCHAR, NOTE, NTEXT 65,535 characters; 2.14 GB if not binary data

            Following is a table that lists the basic Jet NUMERIC data types, various synonyms, and the number of bytes allocated for each.

            Jet Data Type Synonyms Storage Size
            TINYINT: INTEGER1, BYTE 1 byte
            SMALLINT: SHORT, INTEGER2 2 bytes
            INTEGER: LONG, INT, INTEGER4 4 bytes
            REAL: SINGLE, FLOAT4, IEEESINGLE 4 bytes
            FLOAT: DOUBLE, FLOAT8, IEEEDOUBLE, NUMBER 8 bytes
            DECIMAL: NUMERIC, DEC 17 bytes

            The CURRENCY data type
            The CURRENCY data type is used to store numeric data that contains up to 15 digits on the left side of the decimal point, and up to 4 digits on the right. It uses 8 bytes of memory for storage, and its only synonym is MONEY.


            The BOOLEAN data type
            The BOOLEAN data types are logical types that result in either True or False values. They use 1 byte of memory for storage, and their synonyms are BIT, LOGICAL, LOGICAL1, and YESNO. A True value is equal to –1 while a False value is equal to 0.

            The BINARY data type
            The BINARY data type is used to store a small amount of any type of data in its native, binary format. It uses 1 byte of memory for each character stored, and you can optionally specify the number of bytes to be allocated. If the number of bytes is not specified, it defaults to 510 bytes, which is the maximum number of bytes allowed. Its synonyms are BINARY, VARBINARY, and BINARY VARYING. The BINARY data type is not available in the Access user interface.

            The OLEOBJECT data types
            The OLEOBJECT data types are used to store large binary objects such as Word documents or Excel spreadsheets. The number of bytes is not specified, and the maximum size is 2.14 gigabytes. Its synonyms are IMAGE, LONGBINARY, GENERAL, and OLEOBJECT.

            The DATETIME data type
            The DATETIME data type is used to store date, time, and combination date/time values for the years ranging from 100 to 9999. It uses 8 bytes of memory for storage, and its synonyms are DATE, TIME, DATETIME, and TIMESTAMP.

            The COUNTER data type
            The COUNTER data type is used to store long integer values that automatically increment whenever a new record is inserted into a table. With the COUNTER data type, you can optionally set a seed value and an increment value. The seed value is the starting value that will be entered in the field the first time a new record is inserted into the table. The increment value is the number that is added to the last counter value to establish the next counter value. If the seed and increment values are not specified, both the seed and increment values default to 1. You can have only one COUNTER field in a table, and the synonyms are COUNTER, AUTOINCREMENT, and IDENTITY.