On 26 Oct 2007 at 9:17, mos wrote:

> I posted this message twice in the past 3 days, and it never gets on the 
> mailing list. Why?
> Here it is again:
> 
> I have a Text field that contains paragraph text and for security reasons I 
> need to have it encrypted. If I do this, how can I still implement full 
> text search on it?
> Also, I have a lot of Float columns that need to be protected but the user 
> has to use comparison operators like ">" and "<" on them. Any recommendations?

Hi,

This is quite a difficult one, and as usual in the field of security depends on 
how valuable 
the data is and how difficult you want it to be for an attacker to obtain it.

If you let us know what type of data this is and how well it has to be 
protected, maybe we 
can help more. "security reasons" is a bit vague, but I can understand that you 
don't want 
to give too much away.

I can say one thing though, in order for the data to be indexed by MySQL , it 
has to be in 
an unencrypted form somewhere in the database. There is no way I know to get 
around 
this, but I hope someone can correct me :)

Regards

Ian
-- 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to