Skip to content

Commit 858717a

Browse files
authored
Unclear large string types can't be used
The description of the data type does not explicitly call out nvarchar(max) or varchar(max) which don't work.
1 parent 34be3e3 commit 858717a

1 file changed

Lines changed: 1 addition & 1 deletion

File tree

docs/t-sql/queries/freetext-transact-sql.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -70,7 +70,7 @@ FREETEXT ( { column_name | (column_list) | * }
7070

7171
Use of WEIGHT, FORMSOF, wildcards, NEAR and other syntax is not allowed. *freetext_string* is wordbroken, stemmed, and passed through the thesaurus.
7272

73-
*freetext_string* is **nvarchar**. An implicit conversion occurs when another character data type is used as input. In the following example, the `@SearchWord` variable, which is defined as `varchar(30)`, causes an implicit conversion in the `FREETEXT` predicate.
73+
*freetext_string* is **nvarchar**. An implicit conversion occurs when another character data type is used as input. Large string data types nvarchar(max) and varchar(max) cannot be used. In the following example, the `@SearchWord` variable, which is defined as `varchar(30)`, causes an implicit conversion in the `FREETEXT` predicate.
7474

7575
```
7676

0 commit comments

Comments
 (0)