Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
issammansour
Yak Posting Veteran
51 Posts |
 Posted - 2007-04-27 : 05:33:13
|
| Hi,how to defined add a language to the language selection on the Full-text Specification in columns designed like "Arabic language".Regards |
|
|
maevr
Posting Yak Master
169 Posts |
Posted - 2007-04-27 : 07:21:11
|
| What do you mean, Collation? I do not understand your question? |
 |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2007-04-27 : 08:37:45
|
| You can set the collation to arabic for individual columns when creating a table or you can add this by altering the table. see books online to check for arabic setting. |
|
|
|
issammansour
Yak Posting Veteran
51 Posts |
Posted - 2007-04-27 : 11:53:36
|
| Message "What do you mean, Collation? I do not understand your question?"Let me explain what i mean:-I have a table with two fields, the Arabic description and a English description. I have a a full-text index on both field one for the English one and one for the Arabic one. When i issue my select statement on the English field i get the result the statement as follows:--- looking for account having a name called "cash"SELECT * FROM JBMERP.DBO.AMASTERWHERE CONTAINS(ACCTNAME,'"cas*"')the same select i run on the arabic field :-SELECT * FROM JBMERP.DBO.AMASTERWHERE CONTAINS(aACCTNAME,'"ÕäÏ*"')I Have no resultSo, I am trying to change the full-text index --> preperties ---> Columns ----> Languages for word Breaker to be arabic but No Arabic Selection ThereRegards |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-27 : 12:50:06
|
| Do you use unicode for arabic field? Full test indexing uses mssearch service, may need check code page in OS. |
|
|
|
|
|
|
Add Languages to sql