# Object of instance with "'''''''NULL'''''''" default value i

**URL:** <https://www.ruby-forum.com/t/object-of-instance-with-null-default-value-i/110047>\
**Category:** Rails\
**Created:** [July 22, 2007, 2:10am UTC](https://www.ruby-forum.com/t/object-of-instance-with-null-default-value-i/110047 "2007-07-22T02:10:27Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![StSSSSphane\_Wirtel](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/9fc348/32.png) [@StSSSSphane\_Wirtel](https://www.ruby-forum.com/u/StSSSSphane_Wirtel)\
**Post date:** [July 22, 2007, 2:10am UTC](https://www.ruby-forum.com/t/object-of-instance-with-null-default-value-i/110047/1 "2007-07-22T02:10:27Z")

</div>

Hi all,

I have a model with not null columns, but when I create a new instance  
of this model, i get a default value “’’’’’’’’’’‘NULL’’’’’’’’’’’’’’”  
in each column with the NN constraint.

How can I remove it, because it is not very user friendly in my  
views 🙂

Best regards,

Stephane W.

---

<div class="post-metadata">

**Author:** ![StSSSSphane\_Wirtel](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/9fc348/32.png) [@StSSSSphane\_Wirtel](https://www.ruby-forum.com/u/StSSSSphane_Wirtel)\
**Post date:** [July 22, 2007, 8:33pm UTC](https://www.ruby-forum.com/t/object-of-instance-with-null-default-value-i/110047/2 "2007-07-22T20:33:59Z")

</div>

On Jul 21, 8:09 pm, Stéphane Wirtel [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> I have a model with not null columns, but when I create a new instance  
> of this model, i get a default value “‘’‘’‘’‘’‘’‘NULL’‘’‘’‘’‘’‘’‘’'”  
> in each column with the NN constraint.

Which version of Rails are you using? Are you using sqlite3? I  
remember a bug with quoting when using sqlite3 that would continue  
putting extra quotes around strings.

> **[Using SQLite3 with Rails](https://rubyonrails.org/2007/1/29/using-sqlite3-with-rails)**
>
> If you are using SQLite3 with a Rails application, make sure you are using SQLite3 3.3.7 or earlier. Versions after 3.3.7 incompatibly changed the way in which default values are stored, making it so that current versions of Rails get into quoting...

Dan M.  
[http://www.dcmanges.com](http://www.dcmanges.com)