Quering filestream data

Question

Post reply

Quering filestream data

Roust_m

SSCoach

Points: 17410
More actions
May 1, 2012 at 9:29 pm

#392165

Hi,
Decided to check out the filestreaming feature. Created a copy of the current table replacing [Descripton] [nvarchar](max) column with [Descripton] [varbinary](max) FILESTREAM. However when I do a select for this column from both tables I get something like:
"Hello world..." for the old column and
"0x4A00650072006F006D00650020006A006F0069006E00730020005..." for the new one.
If I decide to full text this column, how this would work with varbinary data type?
Thanks.

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 738663 More actions · Answer 1

How did you convert it over? just an insert?

This looks like binary data. Maybe a cast( as nvarchar)?

Roust_m SSCoach Points: 17410 More actions · Answer 2

I used an insert putting convert(varbinary(max), Description) for the column.

Steve Jones - SSC Editor SSC Guru Points: 738663 More actions · Answer 3

If you converted it over to a varbinary, you need to convert it back.

DECLARE @c VARCHAR(20), @b VARBINARY(max), @d VARCHAR(20)

SET @c = 'Test'

SELECT @b = CONVERT(VARBINARY(MAX), @c)

SELECT @d = CONVERT(VARCHAR(20), @b)

SELECT @c, @b, @d

Roust_m SSCoach Points: 17410 More actions · Answer 4

Yep, but how does it help with Full text indexing?

Steve Jones - SSC Editor SSC Guru Points: 738663 More actions · Answer 5

How does what help?

If this is just text data, is there a reason you can't just index the text data? If it's in Filestream, I know you can full text index data with an iFilter in a Filestream column. Not sure about 2008.