Data which includes foregin characters
-
I've got data in English but that contains Some French characters too. for example Actual data The Coleg Sir Gâr Sabhal Mòr Ostaig Château du Rosey Areté Ecole La Découverte Colegio Gran Bretaña St Thérèse of Lisieux RC Primary School Search input would be: The Coleg Sir Gar (â replaced by a (English)) In data, anywhere there could bey a foregin character and that could be any foreign character How can I included these records in my Search results Using SQL or T-SQL. I am using SQL server 2005 standard. any help will bhe appreciated.
Naveed Kamboh Complexity kills, Write easy code for your self. Punjabi stuff
-
I've got data in English but that contains Some French characters too. for example Actual data The Coleg Sir Gâr Sabhal Mòr Ostaig Château du Rosey Areté Ecole La Découverte Colegio Gran Bretaña St Thérèse of Lisieux RC Primary School Search input would be: The Coleg Sir Gar (â replaced by a (English)) In data, anywhere there could bey a foregin character and that could be any foreign character How can I included these records in my Search results Using SQL or T-SQL. I am using SQL server 2005 standard. any help will bhe appreciated.
Naveed Kamboh Complexity kills, Write easy code for your self. Punjabi stuff
-
You need to define your columns as nvarchar, then they will accept these characters.
Bob Ashfield Consultants Ltd
You didn't get my question I gugess. I have already that data in varchar there 10,000+ records which containt these foreign characters. When we search using english chracters they do not come in the search. So what would be the solution to show them in the search while using english characters as someone will type Foregin chracters.
Naveed Kamboh Complexity kills, Write easy code for your self. Punjabi stuff
-
I've got data in English but that contains Some French characters too. for example Actual data The Coleg Sir Gâr Sabhal Mòr Ostaig Château du Rosey Areté Ecole La Découverte Colegio Gran Bretaña St Thérèse of Lisieux RC Primary School Search input would be: The Coleg Sir Gar (â replaced by a (English)) In data, anywhere there could bey a foregin character and that could be any foreign character How can I included these records in my Search results Using SQL or T-SQL. I am using SQL server 2005 standard. any help will bhe appreciated.
Naveed Kamboh Complexity kills, Write easy code for your self. Punjabi stuff
-
You didn't get my question I gugess. I have already that data in varchar there 10,000+ records which containt these foreign characters. When we search using english chracters they do not come in the search. So what would be the solution to show them in the search while using english characters as someone will type Foregin chracters.
Naveed Kamboh Complexity kills, Write easy code for your self. Punjabi stuff
Naveed Kamboh wrote:
I have already that data in varchar there 10,000+ records which containt these foreign characters. When we search using english chracters they do not come in the search.
In which case I think you are out of luck. If you think about it logically the characters are not the same, the ascii values of the characters differ so the strings differ.
Bob Ashfield Consultants Ltd
-
try to use
SOUNDEX. More info about SOUNDEX.[^]
I Love T-SQL "Don't torture yourself,let the life to do it for you."
SoundEx doesn't work. I've tried that
Naveed Kamboh Complexity kills, Write easy code for your self. Punjabi stuff
-
SoundEx doesn't work. I've tried that
Naveed Kamboh Complexity kills, Write easy code for your self. Punjabi stuff
I found solution here http://www.sqlservercentral.com/Forums/Topic498678-338-1.aspx?Update=1[^]
Naveed Kamboh Complexity kills, Write easy code for your self. Punjabi stuff
-
I found solution here http://www.sqlservercentral.com/Forums/Topic498678-338-1.aspx?Update=1[^]
Naveed Kamboh Complexity kills, Write easy code for your self. Punjabi stuff
-
I've got data in English but that contains Some French characters too. for example Actual data The Coleg Sir Gâr Sabhal Mòr Ostaig Château du Rosey Areté Ecole La Découverte Colegio Gran Bretaña St Thérèse of Lisieux RC Primary School Search input would be: The Coleg Sir Gar (â replaced by a (English)) In data, anywhere there could bey a foregin character and that could be any foreign character How can I included these records in my Search results Using SQL or T-SQL. I am using SQL server 2005 standard. any help will bhe appreciated.
Naveed Kamboh Complexity kills, Write easy code for your self. Punjabi stuff
Hi Naveed, In case of multilingual, we shud follow nvarchar always...after that you can search everything using N'%" + SearcText + "%' .... so that it will be easy to find out the desired result.
-
Hi Naveed, In case of multilingual, we shud follow nvarchar always...after that you can search everything using N'%" + SearcText + "%' .... so that it will be easy to find out the desired result.
Can you please give me any example what do you mean I tried following query select organisationname from organisation where organisationname like N'%Arete%' It is not returning me in results "Areté" My actual stored procduer runs with following where clause @WhereClause = N'((OrganisationName COLLATE SQL_Latin1_General_CP1_CI_AI ) LIKE '%arete%' and its giving me results which wanted.
Naveed Kamboh Complexity kills, Write easy code for your self. Punjabi stuff