Saving encrypted data to a db field

[Hckygirloh]

I am currently trying to save encrypted data to a field in an Oracle 8i database table. I currently have the field set up as a datatype of VARCHAR2(500). The value that is being sent to the database with the SQL statement is not the value that is showing up in the data of the table. For example the encrypted value of my data that is sent in the SQL statment is "/ñœ‡Ã" , the value that is saved in teh database is "/ñ¿¿Ã" This is causing me problems when trying to decrypt and compare values stored in teh database. Do I need to specify a different datatype for the database field?

Thanks!!

:confused:

[vonarxma]

no, u have to change a database environment setting...
...set the correct character-set or language...
...hava a look at the manufacturer's manual...