Why is my full text search not working in SQL Server?
<p>Table columns:</p>

<p><a href="https://i.stack.imgur.com/VV6bo.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/VV6bo.png" alt="enter image description here"></a></p>

<p>Table data:</p>

<p><a href="https://i.stack.imgur.com/hhBx9.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hhBx9.png" alt="enter image description here"></a></p>

<p>Full text index definition:</p>

<pre><code>CREATE UNIQUE INDEX IDX_FULLTEXT_WorkOrder ON WorkOrder(ID);
CREATE FULLTEXT INDEX ON WorkOrder (Description)
KEY INDEX IDX_FULLTEXT_WorkOrder
ON full_text_catalog;
</code></pre>

<p>Query:</p>

<pre><code>SELECT *
FROM [dbo].[WorkOrder]
WHERE CONTAINS([Description],  '"Priorité 8"')
</code></pre>

<p>Incorrect result: The 9 (all) rows of my table, instead of the single one corresponding to my query.</p>

<p>Also why is that query (notice the * character):</p>

<pre><code>SELECT *
FROM [dbo].[WorkOrder]
WHERE CONTAINS([Description],  '"Priorité 8*"')
</code></pre>

<p>not returning any result at all (0)?</p>