About full text query in SQL

Question

I have an nvarchar column that contains English and Japanese text. I want to do a full text search in this column. When setting up full-text search, we need to specify the language option for interrupting a word (for example, using an English job breaker or a Japanese word breaker). I wonder in this case, in what language should I nominate? I'm not sure if someone working in Japanese works in English.

I am using SQL Server 2008 Enterprise.

thanks in advance George

Answer 1

-breaker, ( ).

,

• ( @Tony)
• ; xml , , .
• ( )

.

. - CONTAINS , , :

SELECT Name, Color FROM Production.Product
WHERE CONTAINS((Name, Color), 'Red');

, CASE/IF, . TSQL DATALENGTH(), , .