vendredi 22 juillet 2016

output with diacritics in Full-Text search

I have these in Table_1:

بود

بُود

How can I see بود and بُود in the output?

EDIT: SELECT * FROM Table_1 WHERE contains(*, '"بُود"', LANGUAGE 1025);

CREATE UNIQUE INDEX ui_ukJobCand ON Table_1(Family);
CREATE FULLTEXT CATALOG ft WITH ACCENT_SENSITIVITY=OFF AS DEFAULT;
CREATE FULLTEXT INDEX ON Table_1(Family LANGUAGE 1025)
KEY INDEX ui_ukJobCand WITH CHANGE_TRACKING AUTO, STOPLIST = SYSTEM;

Aucun commentaire:

Enregistrer un commentaire