Results 1 to 13 of 13

Thread: encryption/decryption sql2k

  1. #1
    Join Date
    Feb 2003
    Posts
    34

    Question 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

  2. #2
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    I always use RC4 encryption. this is a good one. no need to install anything.


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

  3. #3
    Join Date
    Feb 2003
    Posts
    34
    Looks very nice. Thanks for the info.
    A quick question. What's the RC4 key length used in this algorighm?

  4. #4
    Join Date
    Sep 2003
    Posts
    3
    We have been using it since a year. No problems so far. Support replies promptly.

  5. #5
    Join Date
    Aug 2003
    Posts
    6
    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?

  6. #6
    Join Date
    Sep 2002
    Posts
    5,938
    Where did you get the function? What does the function do?

  7. #7
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    --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

  8. #8
    Join Date
    Aug 2003
    Posts
    6
    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

  9. #9
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    did u try in another database or another server?

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

  10. #10
    Join Date
    Aug 2003
    Posts
    6
    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

  11. #11
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    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

  12. #12
    Join Date
    Feb 2003
    Posts
    34
    Mak, do you know of anything something similar on oracle...

  13. #13
    Join Date
    Aug 2005
    Posts
    1
    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
  •