Jump to content

Talk:Character large object

Page contents not supported in other languages.
From Wikipedia, the free encyclopedia

The article states that only Oracle has support for CLOBs. Microsoft SQL Server contains 'text' and 'ntext' data types, which while not called 'CLOB's, are certainly the same concept.

Furthermore, the documentation for Postgres indicates that its three character types will be stored as CLOBs (that is, an in-table link to out-of-table storage) when they are significant in length.

The MySQL SQL documentation indicates a distinction between 'char' and 'text' types that also, by the existence of the distinction and the maximum size of the text types, implies CLOB-style out-of-table storage, though it is not explicitly verified in the text. (I may check the internals documentation later).

At any rate, it seems the only claim the article ought to be making about CLOBs with respect to Oracle would be the name - Oracle may be the only database retaining CLOB as a name. But I haven't checked Oracle's docs yet.

Gotta run for now, but I'll be coming back to this. —Preceding unsigned comment added by 162.40.190.56 (talkcontribs) 13:43, 10 September 2005


Needs a disambiguation page.—Preceding unsigned comment added by 216.206.44.11 (talkcontribs) 15:58, 16 May 2007

Start a discussion about improving the Character large object page

Start a discussion