ArticleDirectory
Preface
Preface
PostgreSQL 8.1 was launched. I plan to migrate some SQL server applications to PostgreSQL. The first thing I need to migrate is tables, therefore, we must first figure out the ing relationship between the data types in the two databases. I checked the PostgreSQL documentat
I. Base and management of the database:Persistence Technology: Memory--FILE----database (most commonly used, popular)1. Database:1. Store massive data (P) Big data, cloud computing2. Security3. Easy to manage and operate (DDL,DML.TCL ...)4. Sharing of data (concurrent access)2. Product Brand: (relational database)Oracle: Oracle (SUN:JAVA) ordbm (object-oriented r
The varchar (max), nvarchar (max), and varbinary (max) data types are added to SQL Server 2005.
Shard data type (large-value data types) , Marked with the Max specifier. The varchar (m
bigint integer data (all numbers) from -2^63 (-9223372036854775808) to 2^63-1 (9223372036854775807). The storage size is 8 bytes.
int from -2^31 (-2,147,483,648) to 2^31-1 (2,147,483,647) of integer data (all numbers). The storage size is 4 bytes. The SQL-92 synonym for int is integer.
smallint integer data from -2^1
Label:In the query process and query results for SELECT, each column, variable, expression, and parameter has a related data type. The data type is used to specify the type of data that an object can hold. The data types of SQL
0 to 255.
Bit:1 or 0 of integer data.
(4) Decimal and numeric
The two types of data are equivalent. have two parameters: P (Precision) and S (scale). p Specifies the maximum number of decimal digits that can be stored to the left and right of the decimal point, and P must be a value from 1 to 38. s specifies the maximum number of decimal digits that can be store
.
"Common", which represents time.
Binary
Binary
Byte[]
Represents fixed-length binary data with a maximum of 8,000 characters
varbinary (n)
Byte[]
Represents a variable-length binary data that stores up to 8,000 characters
varbinary (max)
Byte[]
Represents variabl
(32,767.Tinyint: integer data from 0 to 255.Bit: an integer of 1 or 0.
(4) decimal and numericThe two data types are equivalent. There are two parameters: P (precision) and S (number of decimal places ). P specifies the maximum number of decimal digits that can be stored on the left and right of the decimal point. P must be a value ranging from 1 to 38. S spec
.Tinyint: integer data from 0 to 255.Bit: an integer of 1 or 0.
(4)Decimal and numericThe two data types are equivalent. There are two parameters: P (precision) and S (number of decimal places ). P specifies the maximum number of decimal digits that can be stored on the left and right of the decimal point. P must be a value ranging from 1 to 38. S specifies the
[]
varchar
VARCHAR
String
tinyint
TINYINT
Short
uniqueidentifier
CHAR
String
Xml
LongVarCharSQLXML (Java SE 6.0)
StringSQLXML
Time
Time (1)
Java.sql.Time (1)
Date
DATE
Java.sql.Date
DateTime2
TIMESTAMP
Java.sql.Timestamp
DateTimeOffset (2)
Microsoft.sql.Types.DATETIMEOFFSET
Microsoft.sql.DateTimeOff
(9223372036854775807.INT: integer data from-2 ^ 31 (-2,147,483,648) to 2 ^ 31-1 (2,147,483,647.Smallint: integer data from-2 ^ 15 (-32,768) to 2 ^ 15-1 (32,767.Tinyint: integer data from 0 to 255.Bit: an integer of 1 or 0.
(4) decimal and numericThe two data types are equiv
java.math.bigdecimal
numeric
numeric
numeric
numeric
other
java.lang.object
other
other
other
NBSP;OTHERNBSP;
real
java.lang.float
real
real
real
real
smallint
java.lang.integer
smallint
smallint
smallint
smallint
time
java.sql.time
time
sql-server Common data typesAuthor statement:The first time to write a blog, there are some deficiencies, and then I first involved in software development this industry, is a small white, the article will certainly appear some wrong place, hope to find the wrong friends can timely point out, insufficient places also please all the way the great God to teach, so
Objective
In the previous articles we explained the index of knowledge, this section we continue to explain the following content, short content, in-depth understanding.
Data type
SQL Server supports two types of character data, one is general and the other is Unicode. Ge
factors on a pair of results. Model the relationship between the input and the output. To measure the impact of each input on the output and weigh the role of different inputs in the completed model. 9. Linear Regression algorithm Linear regression algorithm is a commonly used method for statistic and prediction, which makes a variant of decision Tree algorithm, helps to calculate the linear relation between dependent variable and independent variable, estimates the best linear equation of pred
: Rounding to the nearest value, rounding up, downloading, and rounding to zero. Microsoft SQL Server uses top rounding. All values must be accurate to the specified precision, but small floating point values may change. Because the binary representation of floating point numbers can use any of the many valid rounding rules, it is impossible for us to reliably quantify a floating point value.Convert decimal
bytes.Category five: String dataChar: Length is set, with a minimum of 1 bytes and a maximum of 8,000 bytes. The insufficient length will be blank.VARCHAR: The length is also set, the shortest is 1 bytes, the longest is 8,000 bytes, the trailing blanks will be removed.Text: Long-width is also set, the longest can be stored 2G of data.Category six: Unincode string dataNCHAR: The length is set, the shortest is 1 bytes, and the maximum is 4,000 bytes. The length of the gap is blank. Storing one ch
SQL Server 2008 finally released the new version, although it was just another community beta rather than a full version. Whenever new software is released, the most problematic question to ask most is: What are some of the new features? SQL Server 2008 has many new features and new tools. However, this article is inte
PostgreSQL 8.1 Sensational release, I also intend to migrate some of the original SQL Server applications to PostgreSQL, the first need to migrate a table, then this must first understand the data types in the two database mapping relationship. Check out the PostgreSQL document specially made to the following table to
, with a minimum of 1 bytes and a maximum of 8,000 bytes. The insufficient length will be blank.VARCHAR: The length is also set, the shortest is 1 bytes, the longest is 8,000 bytes, the trailing blanks will be removed.Text: Long-width is also set, the longest can be stored 2G of data.Category six: Unincode string dataNCHAR: The length is set, the shortest is 1 bytes, and the maximum is 4,000 bytes. The length of the gap is blank. Storing one character requires 2 bytes.Nvarchar: The length is set
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.