-
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
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|