To increase the security of a web-based MSSQL table, I applied an encryption algorithm to a Name field. This process was carried out on the client machine which is the original source of the data (ASCII field).

Once the encrypted data was transferred to the host and decrypted (using the same key of course), it just returned garbage. I know the functions that encrypt and decrypt are solid, as they are already used in our Windows app.

I have partly discovered the problem. In examining the encrypted string as generated on the client, it is showing as a different set of characters than in the web based SQL table (ASCII field). I figure we have some kind of codepage type problem, or character set problem between the two machines. How can I check these settings? (or is there something else wrong perhaps?)

Regards, Phil