On Thu, Aug 11, 2005 at 13:50:45 -0700, Owen Jacobson <[EMAIL PROTECTED]> wrote: > Jeff Lu wrote: > > > Another question is can the encrypted column be of type "text" ? > > Can't see any reason why not, so long as the encrypted data is represented > as text.
There can't be any 0 bytes in the encrypted string or the string will be truncated. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match