From: Robert Klemme <shortcutter@...>
Date: 2007-10-22T22:22:34+09:00
Subject: Re: I have nothing to do with ORA-01756!

2007/10/22, lzcarl@gmail.com <lzcarl@gmail.com>:
> 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