Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
 Posted - 2007-05-25 : 16:32:28
|
| That's right. My developers want full-text searching implemented on an encrypted XML datatype...on SQL Server Express, no less.Whether this can be done seems to boil down to four questions:1) Can the XML datatype be encrypted?2) Can the XML datatype be full-text indexed?3) Can encrypted data be full-text indexed?4) Can encrypted XML data be full-text indexed?So I'm diving into the documentation now, but if anybody out there already knows whether the answer to any of these questions is "No", please save me some time.Oh, and they also want to substitute potato nuggets for fries, and biggie-size the whole thing.e4 d5 xd5 Nf6 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-05-25 : 17:27:34
|
| 1. NoOnly nvarchar, char, varchar, binary, varbinary, or nchar can be encrypted with EncryptByKey functionplus EncryptByKey returns varbinary(8000) and you can easily exceed that with xml._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-05-25 : 17:31:16
|
| 2. yes, but not attributtes. you have new Create Full text index t-sql command3. no idea, but probably no4. no since xml can't be encrypted._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2007-05-25 : 19:03:11
|
| Thanks, Spirit!e4 d5 xd5 Nf6 |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-05-26 : 05:21:33
|
| Store the XML in files and write an ASAPI (sp?) driver to interface with full text indexing and thus deal with the unencryption on the way into Index Server? (For that matter an ASAPI driver could get its source from SQL database I suppose).But all the data IN the Index Server store is going to be UNencrypted - which might defeat the object??Kristen |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-05-26 : 09:35:40
|
| so bruce... what will you do?_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2007-05-27 : 19:55:53
|
| Sit down with them on Tuesday and say, "Tell me your requirements, and let ME handle the implementation."e4 d5 xd5 Nf6 |
|
|
|
|
|
|
|
|
Full-text search on encrypted XML datatype