| List: | Commits | « Previous MessageNext Message » | |
| From: | anthony.bedford | Date: | July 15 2008 4:20pm |
| Subject: | svn commit - mysqldoc@docsrva: r11253 - trunk/refman-common | ||
| View as plain text | |||
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 |
© 1995-2008 MySQL AB, 2008-2009 Sun Microsystems, Inc.
Page generated in 0.516 sec. using MySQL 5.1.14-beta-log