Forum: Ruby Problem stored values in Oracle

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
97334b75c93574ed3e514f33849f0953?d=identicon&s=25 Mario Ruiz (tcblues)
on 2008-10-15 18:49
If I enter in my website the value éI9Áq'ÜnPt•    the last character is
replaced on the database by ¿

The problem is I have to test automatically that the content on the
database is the same that the content it was entered on the webpage and
I don't want to do something easy like replace characters.

Any idea how to solve it in a good way?

Thank you.
97334b75c93574ed3e514f33849f0953?d=identicon&s=25 Mario Ruiz (tcblues)
on 2008-10-17 18:10
I found the problem.
The language of the client and the server were different so I had to
change the value on the client side in regedit.

thank you.
E0d864d9677f3c1482a20152b7cac0e2?d=identicon&s=25 Robert Klemme (Guest)
on 2008-10-20 09:26
(Received via mailing list)
2008/10/17 Mario Ruiz <mario@betware.com>:
> I found the problem.
> The language of the client and the server were different so I had to
> change the value on the client side in regedit.

It's probably also a good idea to check character encoding of the
database and / or column because that affects how comparisons are done
and what characters you can store inside.

Kind regards

robert
97334b75c93574ed3e514f33849f0953?d=identicon&s=25 Mario Ruiz (tcblues)
on 2008-10-20 11:52
How can I check the encoding, encode and decode?

Thanks.
E0d864d9677f3c1482a20152b7cac0e2?d=identicon&s=25 Robert Klemme (Guest)
on 2008-10-20 12:54
(Received via mailing list)
2008/10/20 Mario Ruiz <mario@betware.com>:
> How can I check the encoding, encode and decode?

If the column type is NVARCHAR2 it's Unicode.  For more info, please
check Oracle's docs:

http://download.oracle.com/docs/cd/B19306_01/serve...

http://download.oracle.com/docs/cd/B19306_01/serve...

Cheers

robert
97334b75c93574ed3e514f33849f0953?d=identicon&s=25 Mario Ruiz (tcblues)
on 2008-10-20 12:57
Thanks a lot.
This topic is locked and can not be replied to.