Salesforce

MySQL Data Types (Magic xpa 4.x)

« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

MySQL Data Types (Magic xpa 4.x)

The following table shows the results of a Get Definition operation from a MySQL table, and shows equivalents for MySQL data types.

MySQL Data Type

Attribute

Magic xpa Storage Type

Storage Size

Picture

SQL_CHAR

Alpha

Zstring

n+1, 2- 256

n, 1-255

SQL_VARCHAR

Alpha

Zstring

n+1, 2- 256

n, 1-255

SQL_LONGVARCHAR

BLOB

ANSI

Default (0)

Default (0)

SQL_BIGINT

Numeric

Signed Integer

4

9

SQL_INTEGER

Numeric

Signed Integer

4

9

SQL_SMALLINT

Numeric

Signed Integer

2

5

SQL_TINYINT

Numeric

Unsigned Integer

1

3

SQL_DOUBLE

Numeric

Float

8

According to the Float property in the DBMS Properties (default: 10.3)

SQL_FLOAT

Numeric

Float

4

5.2

SQL_REAL

Numeric

Float

4

5.2

SQL_NUMERIC

Numeric

Float

8

According to the Float property in the DBMS Properties (default: 10.3)

SQL_DECIMAL

Numeric

Float

8

According to the Float property in the DBMS Properties

SQL_DATE

Date

String Date

8

##/##/####

SQL_TIME

Time

String Time

6

##:##:##

SQL_BINARY

Alpha

Zstring

N+1, 2- 256

n, 1-255

SQL_VARBINARY

BLOB

Binary

N+1, 2- 256

n, 1-255

SQL_LONGVARBINARY

BLOB

Binary

SQL_BIT

Logical

Integer Logical

1

5

TIMESTAMP

1. Date

2. Time

Creates two fields, one with String Date and one with String Time, that are connected by the Part of Datetime property.

8

##/##/####

SQLTINYBIT

Numeric

Unsigned Integer

1

The storage size is calculated according to the database of the table - according to the gateway's storage table. The storage size is recalculated on import.

Reference
Attachment 
Attachment