|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Encrypt data in a column
Hi,
I have a table which stores a user name and password. I want the data in the password column to be encrypted. In mysql I can do something like: insert into users (username,password) values('john',md5('doe')); Does Firebird have something like this? Thanks in advance, Peter |
|
#2
|
||||
|
||||
|
Yes, it's available through UDF (see rFunc )
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias) |
|
#3
|
|||
|
|||
|
Thanks! Peter
|
|
#4
|
|||
|
|||
|
is there any tutorials on how to install this library!??
if so... any links!?? i;m trying to add the rfunc library through IB Expert.... how should i do this!?? thank you! |
|
#5
|
||||
|
||||
|
Quote:
To install it you must run the script that adds the the rfunc library ... look for .sql files in the pack. Good luck, Silver |
![]() |
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Encrypt data in a column |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|