# Text\_area empty\_clob()

**URL:** <https://www.ruby-forum.com/t/text-area-empty-clob/115685>\
**Category:** Rails\
**Created:** [September 27, 2007, 5:24pm UTC](https://www.ruby-forum.com/t/text-area-empty-clob/115685 "2007-09-27T17:24:25Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![destiney](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/f07891/32.png) [@destiney](https://www.ruby-forum.com/u/destiney)\
**Post date:** [September 27, 2007, 5:24pm UTC](https://www.ruby-forum.com/t/text-area-empty-clob/115685/1 "2007-09-27T17:24:25Z")

</div>

Anyone know why my text\_area field is being prefilled with  
“empty\_clob()” instead of simply being empty like I would  
expect? I’m using Oracle 10g so I suspect it’s coming from  
the oci8 driver somehow?

Here’s the code:

\<% form\_for :user do |f| -%\>  
\<%= f.text\_area :notes, :rows =\> 2, :cols =\> 32 %\>  
\<% end -%\>

It should be just an empty text area ready for data to be  
input.

In my migration I’m making the field a text field:

t.column :notes, :text

I tried adding :default =\> ‘’ but that didn’t help.

The model for this is still empty at this point.

Thanks,

–  
Greg D.  
Cyberfusion Consulting  
[http://cyberfusionconsulting.com/](http://cyberfusionconsulting.com/)

---

<div class="post-metadata">

**Author:** ![destiney](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/f07891/32.png) [@destiney](https://www.ruby-forum.com/u/destiney)\
**Post date:** [September 27, 2007, 10:46pm UTC](https://www.ruby-forum.com/t/text-area-empty-clob/115685/2 "2007-09-27T22:46:10Z")

</div>

On Thu, 27 Sep 2007, Greg D. wrote:

> In my migration I’m making the field a text field:
> 
> t.column :notes, :text

I figured this out, sort of.

Instead of :text I’m using :string, :limit 4000.

–  
Greg D.  
Cyberfusion Consulting  
[http://cyberfusionconsulting.com/](http://cyberfusionconsulting.com/)

---

<div class="post-metadata">

**Author:** ![destiney](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/f07891/32.png) [@destiney](https://www.ruby-forum.com/u/destiney)\
**Post date:** [September 29, 2007, 3:10am UTC](https://www.ruby-forum.com/t/text-area-empty-clob/115685/3 "2007-09-29T03:10:34Z")

</div>

Anybody have an actual solution instead of a work around? Thanks!

On Sep 27, 12:34 pm, Greg D. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)