encryption/decryption sql2k

I am planning to use XP_CRYPT for encrypting and decrypting cc#'s, passwords etc., at database level. Any suggestions or experiences on this. More info about this product at
http://www.activecrypt.com/faq.htm

I always use RC4 encryption. this is a good one. no need to install anything.


http://www.databasejournal.com/img/RC4_enhanced.sql

Looks very nice. Thanks for the info.
A quick question. What's the RC4 key length used in this algorighm?

We have been using it since a year. No problems so far. Support replies promptly.

hello,
when i try to run:

Code:

---

select dbo.fn_string_helper('this is a test', 'xxx')

---

i got a null result.
can u help me?

Where did you get the function? What does the function do?

--Works for me

--Query
select dbo.fn_string_helper('this is a test', 'xxx')
--result
ދνF$ßwÏÍSëÖ_

-Query
select dbo.fn_string_helper(dbo.fn_string_helper('this is a test', 'xxx'),'xxx')

--result


this is a test

hmmm... that's wired.
i ran RC4_enhanced.sql above in one of my database and the function is created successfully.

however, when i test run the 1st query:
select dbo.fn_string_helper('this is a test', 'xxx')

i got:
(No column name)
NULL

did u try in another database or another server?

what is the collation on the database that you created this proc.

ya, i tried another database (in the same instance).

the collation is:
query:
sp_helpsort

result:
Chinese-Taiwan-Stroke, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive

your reply so fast, MAK :D

Yep. It is a collation issue.

I created a database in taiwan-stroke like below. it didnt work.

use master
go
create database testcollate collate
Chinese_Taiwan_Stroke_CS_AS
go
use testcollate
go
--created function
select dbo.fn_string_helper('this is a test', 'xxx')

--result

Nothing

Mak, do you know of anything something similar on oracle...

Ravinder - there are database encryption vendors that support multiple platforms such as MS SQL, Oracle, and DB2. Check out www.ingrian.com