Ask a Question related to Coldfusion Database Access, Design and Development.
-
pdrich #1
Oracle CLOB Truncation > 64K
We have an update and insert query for a large text field (Oracle CLOB). When
we run the query on long text, it truncates the excess. Specifically, I can
enter 63,820 characters, and not a single character more. The CLOB permits a
4GB storage per field, so that is not the problem. Driver is jdbc:oracle:thin
Is this a driver limitation? Any workarounds?
pdrich Guest
-
#39103 [Opn]: Oracle CLOB Charset Incorrect
ID: 39103 User updated by: jhtpeter at gmail dot com Reported By: jhtpeter at gmail dot com Status: Open Bug Type: ... -
Updating Oracle Clob field
I am having some trouble updating an oracle db that has a clob field, this is the part of the query that is getting the form data: <cfqueryparam... -
Oracle CLOB Columns Failing With ColdFusion 7
I am using ColdFusion 7 Enterprise, updater 1 with DataDirect version 3.4 drivers and Oracle 8i. ColdFusion 7 is returning no data for CLOB... -
Oracle CLOB Update in CF
We have a form with two textareas. The action page updates two Oracle clob fields with the content from the textareas. If at least one of the... -
Oracle CLOB using DBI
Does someone have a working code sample of Perl/DBI returning a CLOB column from Oracle. Here is what I came up with, I counld not get ORA_CLOB... -
paross1 #2 Re: Oracle CLOB Truncation > 64K
Have you checked the advanced settings of your data source in ColdFusion
Administrator? Specifically, if the CLOB (Enable long text retrieval) option is
not selected, then your CLOB is limited in size to the value specified in the
Long Text Buffer (chr) option, which has a default value of 64k.
Phil
paross1 Guest
-
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
