Oracle Equivalent of MySQL's TEXT type Oracle Equivalent of MySQL's TEXT type oracle oracle

Oracle Equivalent of MySQL's TEXT type


php oracle text types

Oracle has BLOB, CLOB and NCLOB for storing binary, character and unicode character data types. You can also specify the LOB storage area which allows a DBA to fine tune the storage if necessary (i.e. putting the LOB data on separate disks)

This page gives a bit more info:http://www.dba-oracle.com/t_blob.htm

php oracle text types

I think you probably want the CLOB datatype.

php oracle text types

Oracle SQL has a limit of 4000 characters for a VARCHAR2 column (Oracle PL/SQL has a higher limit of 32,767 characters). As stated by the others, CLOB is suitable for storing large quantities of text.

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last