all groups > sql server full text search > june 2006 >
You're in the

sql server full text search

group:

Problem with Punctuation under neutral LCID


Problem with Punctuation under neutral LCID Michael Schroeder
6/28/2006 6:49:02 AM
sql server full text search:
Hi out there,

could anyone explain?

System: WinServer 2003 German
SQL Server 2003

SQL query on fulltext field which contains revision no. e.g. 10.02.0512

After setting the LCID to neutral (0) by SQL statement I got better results
than querying unter LCID German (1031). But one problem left:

i)
Select Field9,* from test.issues where contains(Field9,'"10.04.1*"')
result: 10.04.1nnn
OK

ii)
Select Field9,* from test.issues where contains(Field9,'"10.04*"')
result: 10.04 but not 10.04.nnnn

hhmmhh?
Why I don't get e.g 10.04.nnn under neutral LCID


Thanks for help beforehand,
RE: Problem with Punctuation under neutral LCID Michael Schroeder
6/28/2006 6:52:03 AM
detected? ;-)
SQL Server is v2000

sorry for that
Michael

"Michael Schroeder" schrieb:

[quoted text, click to view]
AddThis Social Bookmark Button