Re: How to encrypt Text and still be able to use full text search? 3rd Attempt ++

2007-10-27 Thread Jan Kirchhoff
mos schrieb: 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? Als

Re: How to encrypt Text and still be able to use full text search? 3rd Attempt ++

2007-10-26 Thread William Newton
From: Baron Schwartz <[EMAIL PROTECTED]> To: mos <[EMAIL PROTECTED]> Cc: mysql@lists.mysql.com Sent: Friday, October 26, 2007 3:54:11 PM Subject: Re: How to encrypt Text and still be able to use full text search? 3rd Attempt ++ > I also need to protect a couple dozen Float fields

Re: How to encrypt Text and still be able to use full text search? 3rd Attempt ++

2007-10-26 Thread Baron Schwartz
I also need to protect a couple dozen Float fields and thought I could obscure them a bit by adding an offset to them based on an encrypted id stored with each row. It is not going to be as good as encryption but will help to obfuscate the data. How much will obfuscation save you? Are you sav

Re: How to encrypt Text and still be able to use full text search? 3rd Attempt ++

2007-10-26 Thread mos
At 01:47 PM 10/26/2007, you wrote: On 10/26/07, Baron Schwartz <[EMAIL PROTECTED]> wrote: > > [EMAIL PROTECTED] wrote: > > mos wrote: > >> > >> The data is quite valuable because there is a lot of competition in > >> this particular marketplace and my competitors would like to get their > >> hand

Re: How to encrypt Text and still be able to use full text search? 3rd Attempt ++

2007-10-26 Thread mos
At 12:31 PM 10/26/2007, you wrote: [EMAIL PROTECTED] wrote: mos wrote: The data is quite valuable because there is a lot of competition in this particular marketplace and my competitors would like to get their hands on it. I've spent 5 years writing the software and generating the data. Le

Re: How to encrypt Text and still be able to use full text search? 3rd Attempt ++

2007-10-26 Thread Rob Wultsch
On 10/26/07, Baron Schwartz <[EMAIL PROTECTED]> wrote: > > [EMAIL PROTECTED] wrote: > > mos wrote: > >> > >> The data is quite valuable because there is a lot of competition in > >> this particular marketplace and my competitors would like to get their > >> hands on it. I've spent 5 years writing

Re: How to encrypt Text and still be able to use full text search? 3rd Attempt ++

2007-10-26 Thread Baron Schwartz
[EMAIL PROTECTED] wrote: mos wrote: The data is quite valuable because there is a lot of competition in this particular marketplace and my competitors would like to get their hands on it. I've spent 5 years writing the software and generating the data. Let's say for the sake of argument the

Re: How to encrypt Text and still be able to use full text search? 3rd Attempt ++

2007-10-26 Thread mysql
mos wrote: The data is quite valuable because there is a lot of competition in this particular marketplace and my competitors would like to get their hands on it. I've spent 5 years writing the software and generating the data. Let's say for the sake of argument the data is worth $1 million.

Re: How to encrypt Text and still be able to use full text search? 3rd Attempt ++

2007-10-26 Thread mos
Ian, At 09:36 AM 10/26/2007, you wrote: 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 encr

Re: How to encrypt Text and still be able to use full text search? 3rd Attempt ++

2007-10-26 Thread Ian
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 imple

How to encrypt Text and still be able to use full text search? 3rd Attempt ++

2007-10-26 Thread mos
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 lo