Is there an encryption method for a column with an int data type?

Question

The scenario is that I want to encrypt financial numbers in a column with an int data type in a sql server table. This is a great application, so it’s difficult to change the table column data type from int to any other data type.

I am using sql server 2005 and asp.net c #.

Is there a two-way encryption method for a column with an int data type?

Is it possible to use a custom function in SQL Server 2005 or perhaps a C # method?

Answer 1

, . , , SQL Server , ?

. , ( , ).

, (, , ), ( ) .

Answer 2

XOR?

:)

, ...

Answer 3

, .Net.

"" #

, base-64 .

Answer 4

, injective, int int "" .

​​, 65536 f(i) = a[i]. "" int, b[i] = x | a[x] = i.

, , . =)

: !

Answer 5

, , .