Full Text Search - Neutral Language - Can't figure out why

• Andre Guerreiro

  SSCertifiable

  Points: 7319

  More actions

  February 11, 2014 at 5:48 am

  #1687866

  Sorry, guys. That doesn't explain my problem well.

  I made an example which is exactly what's happening.

  I appreciate any help since we have an SLA deadline with our customer and I don't know what else to do.

  CREATE TABLE dbo.fts_test

  (

  id INT PRIMARY KEY IDENTITY,

  textField VARCHAR(MAX)

  );

  INSERT INTO dbo.fts_test VALUES ('1.2.3.4');

  INSERT INTO dbo.fts_test VALUES ('RECLAMAÇÃO -1ª VARA CÍVEL DO FORO REGIONAL XII - NOSSA SENHORA DO Ó - DEMORA NO DESARQUIVAMENTO DO PROCESSO 0015814-80.2009.8.26.0020 - PROCEDIMENTO ORDINÁRIO - PARTES: MARIA LIGIA CARNEIRO ALVES E TELEMAR.');

  ALTER TABLE dbo.fts_test

  ADD CONSTRAINT uk_fts_test UNIQUE (id);

  CREATE FULLTEXT CATALOG ftscat_test;

  CREATE FULLTEXT INDEX ON dbo.fts_test (textField LANGUAGE 0)

  KEY INDEX uk_fts_test ON ftscat_test

  WITH CHANGE_TRACKING AUTO;

  -- value is shown correctly

  SELECT *

  FROM dbo.fts_test

  WHERE CONTAINS(textField, '"0015814-80.2009.8.26.0020"', LANGUAGE 1033);

  -- nothing is returned

  SELECT *

  FROM dbo.fts_test

  WHERE CONTAINS(textField, '"0015814-80.2009.8.26.0020"', LANGUAGE 0);

  Best regards,

  Andre Guerreiro Neto

  Database Analyst
  http://www.softplan.com.br
  MCITPx1/MCTSx2/MCSE/MCSA