Author: tbedford
Date: 2008-07-15 16:20:27 +0200 (Tue, 15 Jul 2008)
New Revision: 11253
Log:
Fixing C/NET bug:
#26502
Added entries for TEXT data types.
Cleaned up table.
Modified:
trunk/refman-common/connector-net.xml
Modified: trunk/refman-common/connector-net.xml
===================================================================
--- trunk/refman-common/connector-net.xml 2008-07-15 12:30:54 UTC (rev 11252)
+++ trunk/refman-common/connector-net.xml 2008-07-15 14:20:27 UTC (rev 11253)
Changed blocks: 3, Lines Added: 99, Lines Deleted: 79; 15440 bytes
@@ -10663,49 +10663,95 @@
>Description</emphasis></entry>
</row>
<row>
- <entry>VarString</entry>
- <entry>A variable-length string containing 0 to 65535 characters</entry>
+ <entry>Newdate</entry>
+ <entry>Obsolete. Use Datetime or Date type.</entry>
</row>
<row>
<entry>Timestamp</entry>
<entry>A timestamp. The range is '1970-01-01 00:00:01' to sometime in the year
- 2038</entry>
+ 2038.</entry>
</row>
<row>
+ <entry>Time</entry>
+ <entry><para>
+ The range is '-838:59:59' to
+ '838:59:59'
+ </para></entry>
+ </row>
+ <row>
+ <entry>Date</entry>
+ <entry>Date The supported range is '1000-01-01' to '9999-12-31'</entry>
+ </row>
+ <row>
+ <entry>Datetime</entry>
+ <entry>The supported range is '1000-01-01 00:00:00' to '9999-12-31 23:59:59'</entry>
+ </row>
+ <row>
+ <entry>Year</entry>
+ <entry>A year in 2- or 4-digit format (default is 4-digit). The allowable
+ values are 1901 to 2155, 0000 in
+ the 4-digit year format, and
+ 1970-2069 if you use the 2-digit
+ format (70-69).</entry>
+ </row>
+ <row>
+ <entry>TinyBlob</entry>
+ <entry>A BLOB column with a maximum length of 255 (2^8 - 1) characters</entry>
+ </row>
+ <row>
+ <entry>Blob</entry>
+ <entry>A BLOB column with a maximum length of 65535 (2^16 - 1) characters</entry>
+ </row>
+ <row>
+ <entry>MediumBlob</entry>
+ <entry>A BLOB column with a maximum length of 16777215 (2^24 - 1) characters</entry>
+ </row>
+ <row>
<entry>LongBlob</entry>
<entry>A BLOB column with a maximum length of 4294967295 or 4G (2^32 - 1)
characters</entry>
</row>
<row>
- <entry>Time</entry>
+ <entry>Int16</entry>
<entry><para>
- The range is '-838:59:59' to
- '838:59:59'.
+ A 16-bit signed integer. The
+ signed range is -32768 to 32767.
+ The unsigned range is 0 to 65535
</para></entry>
</row>
<row>
- <entry>TinyBlob</entry>
- <entry>A BLOB column with a maximum length of 255 (2^8 - 1) characters</entry>
+ <entry>Int24</entry>
+ <entry>Specifies a 24 (3 byte) signed or unsigned value</entry>
</row>
<row>
- <entry>Datetime</entry>
- <entry>The supported range is '1000-01-01 00:00:00' to '9999-12-31 23:59:59'.</entry>
+ <entry>Int32</entry>
+ <entry><para>
+ A 32-bit signed integer
+ </para></entry>
</row>
<row>
- <entry>Decimal</entry>
+ <entry>Int64</entry>
<entry><para>
- A fixed precision and scale
- numeric value between -1038 -1
- and 10 38 -1.
+ A 64-bit signed integer
</para></entry>
</row>
<row>
- <entry>UByte</entry>
- <entry/>
+ <entry>Byte</entry>
+ <entry><para>
+ The signed range is -128 to 127.
+ The unsigned range is 0 to 255.
+ </para></entry>
</row>
<row>
- <entry>Blob</entry>
- <entry>A BLOB column with a maximum length of 65535 (2^16 - 1) characters</entry>
+ <entry>Float</entry>
+ <entry><para>
+ A small (single-precision)
+ floating-point number. Allowable
+ values are -3.402823466E+38 to
+ -1.175494351E-38, 0, and
+ 1.175494351E-38 to
+ 3.402823466E+38.
+ </para></entry>
</row>
<row>
<entry>Double</entry>
@@ -10720,38 +10766,31 @@
</para></entry>
</row>
<row>
- <entry>Newdate</entry>
- <entry>Obsolete Use Datetime or Date type</entry>
+ <entry>UByte</entry>
+ <entry>An 8-bit unsigned value</entry>
</row>
<row>
- <entry>Byte</entry>
- <entry><para>
- The signed range is -128 to 127.
- The unsigned range is 0 to 255.
- </para></entry>
+ <entry>UInt16</entry>
+ <entry>A 16-bit unsigned value</entry>
</row>
<row>
- <entry>Date</entry>
- <entry>Date The supported range is '1000-01-01' to '9999-12-31'.</entry>
+ <entry>UInt24</entry>
+ <entry>A 24-bit unsigned value</entry>
</row>
<row>
- <entry>VarChar</entry>
- <entry>A variable-length string containing 0 to 255 characters</entry>
+ <entry>UInt32</entry>
+ <entry>A 32-bit unsigned value</entry>
</row>
<row>
- <entry>UInt16</entry>
- <entry/>
+ <entry>UInt64</entry>
+ <entry>A 64-bit unsigned value</entry>
</row>
<row>
- <entry>UInt24</entry>
- <entry/>
- </row>
- <row>
- <entry>Int16</entry>
+ <entry>Decimal</entry>
<entry><para>
- A 16-bit signed integer. The
- signed range is -32768 to 32767.
- The unsigned range is 0 to 65535
+ A fixed precision and scale
+ numeric value between -1038 -1
+ and 10 38 -1
</para></entry>
</row>
<row>
@@ -10771,67 +10810,48 @@
<entry>Obsolete Use VarChar type</entry>
</row>
<row>
+ <entry>VarChar</entry>
+ <entry>A variable-length string containing 0 to 255 characters</entry>
+ </row>
+ <row>
+ <entry>VarString</entry>
+ <entry>A variable-length string containing 0 to 65535 characters</entry>
+ </row>
+ <row>
<entry>Enum</entry>
<entry>An enumeration. A string object that can have only one value, chosen
from the list of values 'value1',
'value2', ..., NULL or the special
"" error value. An ENUM can have a
- maximum of 65535 distinct values</entry>
+ maximum of 65535 distinct values.</entry>
</row>
<row>
<entry>Geometry</entry>
<entry/>
</row>
<row>
- <entry>UInt64</entry>
- <entry/>
- </row>
- <row>
- <entry>Int64</entry>
- <entry><para>
- A 64-bit signed integer.
- </para></entry>
- </row>
- <row>
- <entry>UInt32</entry>
- <entry/>
- </row>
- <row>
- <entry>Int24</entry>
- <entry>Specifies a 24 (3 byte) signed or unsigned value.</entry>
- </row>
- <row>
<entry>Bit</entry>
<entry>Bit-field data type</entry>
</row>
<row>
- <entry>Float</entry>
- <entry><para>
- A small (single-precision)
- floating-point number. Allowable
- values are -3.402823466E+38 to
- -1.175494351E-38, 0, and
- 1.175494351E-38 to
- 3.402823466E+38.
- </para></entry>
+ <entry>TinyText</entry>
+ <entry>A nonbinary string column supporting a maximum length of 255 (2^8 - 1)
+ characters</entry>
</row>
<row>
- <entry>Year</entry>
- <entry>A year in 2- or 4-digit format (default is 4-digit). The allowable
- values are 1901 to 2155, 0000 in
- the 4-digit year format, and
- 1970-2069 if you use the 2-digit
- format (70-69)</entry>
+ <entry>Text</entry>
+ <entry>A nonbinary string column supporting a maximum length of 65535 (2^16 -
+ 1) characters</entry>
</row>
<row>
- <entry>Int32</entry>
- <entry><para>
- A 32-bit signed integer
- </para></entry>
+ <entry>MediumText</entry>
+ <entry>A nonbinary string column supporting a maximum length of 16777215 (2^24
+ - 1) characters</entry>
</row>
<row>
- <entry>MediumBlob</entry>
- <entry>A BLOB column with a maximum length of 16777215 (2^24 - 1) characters</entry>
+ <entry>LongText</entry>
+ <entry>A nonbinary string column supporting a maximum length of 4294967295
+ (2^32 - 1) characters</entry>
</row>
</tbody>
</tgroup>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r11253 - trunk/refman-common | anthony.bedford | 15 Jul |
