This shows you the differences between two versions of the page.
|
oracle:datatypes [September 26, 2012 1:41 pm] sqlines |
oracle:datatypes [September 26, 2012 1:42 pm] (current) sqlines |
||
|---|---|---|---|
| Line 24: | Line 24: | ||
| | | **Oracle** || **Microsoft SQL Server** ||| | | | **Oracle** || **Microsoft SQL Server** ||| | ||
| | 1 | [[oracle/datatypes/clob|CLOB]], > 4 GB | Variable-length string | [[oracle/datatypes/clob|VARCHAR(max)]], 2 GB {{:exclamation.png|}} | [[oracle/datatypes/clob|NVARCHAR(max)]], 2 GB || | | 1 | [[oracle/datatypes/clob|CLOB]], > 4 GB | Variable-length string | [[oracle/datatypes/clob|VARCHAR(max)]], 2 GB {{:exclamation.png|}} | [[oracle/datatypes/clob|NVARCHAR(max)]], 2 GB || | ||
| - | | 2 | [[oracle/datatypes/nclob|NCLOB]], > 4 GB | Variable-length Unicode UTF-8 or UTF-16 \\ string | [[oracle/datatypes/nclob|NVARCHAR(max)]], 2 GB {{:exclamation.png|}} ||| | + | | 2 | NCLOB, > 4 GB | Variable-length Unicode UTF-8 or UTF-16 \\ string | NVARCHAR(max), 2 GB {{:exclamation.png|}} ||| |