Long Data Types之创建表

创建table：create table links(text long varchar); 

               create table test(file long varbinary); 

其中text和file是列名称。

Long Data Types

Store data up to 32,000,000 bytes:

• LONG VARBINARY—Variable-length raw-byte data, such as IP addresses. LONG VARBINARY values are not extended to the full width of the column.
• LONG VARCHAR—Variable-length strings of letters, numbers, and symbols. LONG VARCHAR values are not extended to the full width of the column.

The maximum size for the LONG data types is 32,000,000 bytes. Use the LONG data types only when you need to store data greater than 65,000 bytes, which is the maximum size for VARBINARY and VARCHAR data types. Such data might include unstructured data, online comments or posts, or small log files.

转载于:https://www.cnblogs.com/reborn2012/p/3508868.html