Re: nvarchar max
- From: Simon Sabin <SimonSabin@xxxxxxxxxxxxxxx>
- Date: Wed, 1 Nov 2006 21:44:40 +0000 (UTC)
Hello Hilary,
True and I can't see why anyone would need to use (max) for the search term. I just came across it so thought I would post.
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
Hi Simon
Point taken, but the way I read the post it is asking about column
data types as opposed to parameter:
Its hard to say what his/her intention was.Are you able to use a column of data type nvarchar max in freetext
searching.
This posting is my own and doesn't necessarily represent
RelevantNoise's positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Simon Sabin" <SimonSabin@xxxxxxxxxxxxxxx> wrote in message
news:62959f1a29e108c8ca8ec48c0bbe@xxxxxxxxxxxxxxxxxxxxxxx
Hello Hilary,
Put you can't use it as the search value. This isn't allowed.
declare @v varchar(max)
set @v = '..sfsdfsdfsdfdsf'
select * from containstable (table,column,@v)
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
Yes, SQL FTS supports char, nchar, varchar, nvarchar, varchar(max),
nvarchar(max), image, varbinary and xml.
From:
http://msdn2.microsoft.com/en-us/library/ms187317.aspx
Is the name of the column or columns included in the full-text
index. Only columns of type char, varchar, nchar, nvarchar, text,
ntext, image, xml, and varbinary can be indexed for full-text
search.
This posting is my own and doesn't necessarily represent
RelevantNoise's positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Nat Johnson" <NatJohnson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message
news:B920CD3A-8B84-4BE8-8CD2-D7304540810A@xxxxxxxxxxxxxxxx
Are you able to use a column of data type nvarchar max in freetext
searching.
sorry probably a basic one.
.
- Prev by Date: Re: FTS query performance on SQL 2005
- Next by Date: Re: Conditional full-text indexing possible in 2000?
- Previous by thread: Re: FTS query performance on SQL 2005
- Next by thread: Re: Sending NULL value to parameter of Stored Procedure
- Index(es):
Relevant Pages
|
Loading
