# I have nothing to do with ORA-01756!

**URL:** <https://www.ruby-forum.com/t/i-have-nothing-to-do-with-ora-01756/117926>\
**Category:** Ruby\
**Created:** [October 22, 2007, 3:16pm UTC](https://www.ruby-forum.com/t/i-have-nothing-to-do-with-ora-01756/117926 "2007-10-22T15:16:02Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![unknown](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/u/4bbf92/32.png) [@unknown](https://www.ruby-forum.com/u/unknown)\
**Post date:** [October 22, 2007, 3:16pm UTC](https://www.ruby-forum.com/t/i-have-nothing-to-do-with-ora-01756/117926/1 "2007-10-22T15:16:02Z")

</div>

I have create a oracle 9i (9.2) database and set its characterset to  
UTF8. After I create a table named man, together with controllers and  
scaffold with ruby, I log on to the page “New Man” and input 3 chinese  
characters and commit. But the server prompt me that, an ORA-01756 has  
happened. Strangely, if I input 4 chinese or 3 chinese characters  
ended up with an English character, it runs well.

Is there anyone met this strange problem? I am looking forward  
pressingly to the reply.

Thank you in advance.

---

<div class="post-metadata">

**Author:** ![unknown](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/u/4bbf92/32.png) [@unknown](https://www.ruby-forum.com/u/unknown)\
**Post date:** [October 22, 2007, 3:23pm UTC](https://www.ruby-forum.com/t/i-have-nothing-to-do-with-ora-01756/117926/2 "2007-10-22T15:23:03Z")

</div>

2007/10/22, removed\_email\_address@domain.invalid [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid):

> I have create a oracle 9i (9.2) database and set its characterset to  
> UTF8. After I create a table named man, together with controllers and  
> scaffold with ruby, I log on to the page “New Man” and input 3 chinese  
> characters and commit. But the server prompt me that, an ORA-01756 has  
> happened. Strangely, if I input 4 chinese or 3 chinese characters  
> ended up with an English character, it runs well.
> 
> Is there anyone met this strange problem? I am looking forward  
> pressingly to the reply.

Just a wild guess since I have zero Rails experience: I see these  
potential sources of your problem:

- the DB connectivity layer does not properly deal with non ASCII text
- Rails does not properly deal with non ASCII text

For example, it could be that no bind variables are used.

Kind regards

robert

---

<div class="post-metadata">

**Author:** ![unknown](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/u/4bbf92/32.png) [@unknown](https://www.ruby-forum.com/u/unknown)\
**Post date:** [October 22, 2007, 3:28pm UTC](https://www.ruby-forum.com/t/i-have-nothing-to-do-with-ora-01756/117926/3 "2007-10-22T15:28:56Z")

</div>

On 10/22/07, removed\_email\_address@domain.invalid [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> Thank you in advance.  
> You are receiving a string termination error, usually due to a missing  
> end quote ’ . You need to find out what the real query is that your  
> scaffold is sending to the database, then you can troubleshoot. A  
> missing end quote can happen for a number of reasons.

Most likely, like Robert suggested, your scaffold and Oracle are not  
playing well together.

Todd