Matisse Data Type Reference
Werbung
MT_BOOLEAN MT_BYTE MT_CHAR MT_DOUBLE MT_FLOAT MT_INTEGER MT_INTERVAL MT_LONG MT_NUMERIC MT_SHORT MT_STRING MT_STRING MT_DATE MT_TIMESTAMP MT_AUDIO MT_BYTES MT_IMAGE MT_TEXT MT_VIDEO MT_NULL MtBoolean MtByte MtChar MtDouble MtFloat MtInteger MtInterval MtLong MtNumeric MtShort MtString MtString MtTimestamp MtTimestamp MtAudio MtByte* MtImage MtText MtVideo NULL NULL MtArray<unsigned char> MtArray<unsigned char> MtArray<unsigned char> MtArray<unsigned char> MtArray<unsigned char> matisse::MtTimestamp matisse::MtTimestamp std::string std::string short matisse::MtNumeric MtLong matisse::MtInterval int float double char unsigned char bool C++ null byte[] byte[] byte[] byte[] byte[] java.util. GregorianCalendar java.util. GregorianCalendar String String short java.math. BigDecimal long long (millisec) int float double byte byte boolean Java 1. See Matisse ODL Programmer’s Guide for instructions on setting precision and scale. 2. See Matisse SQL Programmer’s Guide for instructions on setting precision and scale. C enum C API Matisse Scalar and Media Data Types Matisse Data Type Reference null byte[] string byte[] byte[] byte[] DateTime DateTime string string short Decimal int64 TimeSpan int float double char byte bool .NET NULL MtVideo MtText MtImage List<Byte> MtAudio Timestamp NULL VIDEO CLOB / TEXT IMAGE BLOB / BYTES AUDIO TIMESTAMP DATE NVARCHAR / VARCHAR CHARACTER SET UTF16 String UTF16 Date VARCHAR / STRING String SHORT NUMERIC2 Numeric1 Short LONG INTERVAL INT / INTEGER FLOAT DOUBLE CHAR BYTE BOOLEAN SQL Long Interval Integer Float Double Char Byte Boolean ODL streamable; 2GB max.. streamable; 2GB max. streamable; 2GB max. streamable; 2GB max. streamable; 2GB max. yyyy-mm-dd hh:mm:ss.[uuuuuu] 0001-01-01 00:00:00.000000 to 8163-12-31 23:59:59.999999 yyyy-mm-dd 0001-01-01 to 8163-12-31 _UTF16 ’aabb..’ 2GB max. 2GB max. 16-bit signed integer fixed-point; 19 digits max. 64-bit signed integer [+/-]days hh:mm:ss[.uuuuuu] max. 1,491,308 days 32-bit signed integer 32-bit floating-point 64-bit floating-point single 8-bit character 8-bit signed integer TRUE or FALSE notes MT_BOOLEAN_LIST MT_BYTES MT_DOUBLE_LIST MT_FLOAT_LIST MT_INTEGER_LIST MT_INTERVAL_LIST MT_LONG_LIST MT_NUMERIC_LIST MT_SHORT_LIST MT_STRING_LIST MT_STRING MT_DATE_LIST MT_TIMESTAMP_LIST MtBoolean* MtByte* MtDouble* MtFloat* MtInteger* MtInterval* MtLong* MtNumeric* MtShort* MtString* MtString MtTimestamp* MtTimestamp* 1 String java.util. GregorianCalendar[] java.util. GregorianCalendar[] MtArray<matisse::MtTimestamp>1 MtArray<matisse::MtTimestamp>1 String[] short[] java.math.BigDecimal[] std::string MtArray<std::string> MtArray<short> MtArray<matisse::MtNumeric> long[] long[] MtArray<MtLong> int[] MtArray<matisse::MtInterval>1 float[] double[] byte[] boolean[] Java MtArray<int> MtArray<float> MtArray<double> MtArray<unsigned char> MtArray<bool> C++ Copyright © 2017 Matisse Software, Inc. All Rights Reserved. 1. Requires namespace. C enum C API Matisse List Data Types TimeSpan[] DateTime[] string string[] short[] Decimal[] int64[] DateTimel[] int[] float[] double[] byte[] bool[] .NET List<Timestamp> LIST(TIMESTAMP) LIST(DATE) LIST(NVARCHAR / VARCHAR CHARACTER SET UTF16) List<String UTF16> List<Date> LIST(STRING) LIST(SHORT) LIST(NUMERIC) LIST(LONG) LIST(INTERVAL) LIST(INTEGER) LIST(FLOAT) LIST(DOUBLE) BLOB / BYTES LIST(BOOLEAN) SQL List<String> List<Short> List<Numeric> List<Long> List<Interval> List<Integer> List<Float> List<Double> List<Byte> List<Boolean> ODL