[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

comp.lang.ruby

Problem stored values in Oracle

Mario Ruiz

10/15/2008 4:50:00 PM

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.
--
Posted via http://www.ruby-....
5 Answers

Mario Ruiz

10/17/2008 4:10:00 PM

0

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.
--
Posted via http://www.ruby-....

Robert Klemme

10/20/2008 7:25:00 AM

0

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


--
remember.guy do |as, often| as.you_can - without end

Mario Ruiz

10/20/2008 9:52:00 AM

0

How can I check the encoding, encode and decode?

Thanks.
--
Posted via http://www.ruby-....

Robert Klemme

10/20/2008 10:52:00 AM

0

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/server.102/b14200/sql_elements001....

http://download.oracle.com/docs/cd/B19306_01/server.102/b14225/ch2charset.ht...

Cheers

robert

--
remember.guy do |as, often| as.you_can - without end

Mario Ruiz

10/20/2008 10:56:00 AM

0

Thanks a lot.
--
Posted via http://www.ruby-....