Where Can I Find Arabic Word Breaker For SQL2005?
Jan 7, 2008Hi
Where can i find arabic word breaker for SQL2005? i need to to use fulltext to search in my database.
Hi
Where can i find arabic word breaker for SQL2005? i need to to use fulltext to search in my database.
Hi
Does anyone know if you can specify certain characters to tokenise the search text(other than space and punctuation).
for example, id like to use `:` as a delimiter, word1:word2:word3 etc
Thanks in advance
Hello,
I am using the SSIS import/export wizard to import an Access table into a sql server 2005 database. The table has fields in Arabic (name, last name, etc.) and non-Arabic fields (gender, phone number, category, etc.).
The destination table has nvarchar columns.
After the import, I can see the Arabic characters in the destination table, but they appear in inverse order (from left to right). In Access (or Excel), Arabic fields appear as they should (from right to left) and non-Arabic fields are OK as well (from left to right).
If I do a simple copy-and-paste of a "correct" Arabic text into the table, the result is still wrong (inversed letters)...
Please help, I can't see what else to do.
Thank you.
Hi,
I am trying to use the SQL "Contains" method and full text indexing for some search functionality in an application.
I understand that full text indexes will break data using certain word breakers which are dependent on which language the index is created with. However, I cannot seem to find a list of the what the actual word breakers are. I cannot find these online or in Books Online ... please can you let me know where I can find out more about this?
Many Thanks
Hi,
I have the fields like this.
Session1 Session2 Session3 Session4----------------------------------------------------------------------------------------- SQL Server-Part1 SQL Server-Part2 ASP.Net CSS
C# SQL Server-Part3 ASP.Net Javascript
I have set the Full-Text to all the columns. For searching i wrote the below query
SELECT * FROM <TABLE NAME> WHERE CONTAINS(*,'"SQL Server-Part1"')
My Result expectation is: The First Record should come. But the result of the query bring the two records. It see the "SQL Server" string also. I need to find the exact word. How to do it? Please answer me as soon as possible. Ganesh.
I am required to find or check that a specific word exists in string or not.
Suppose I have to find the word 'st' than I need the result true if and only if the following occurrences are there.
1. 'St is valid;' -> true
2. 'DOB is valid;ST is invalid;' -> true
3. 'DOB is valid; ST is invalid;' -> true
4. 'DOB is valid;invalid ST;' -> true
5. 'DOB is valid; invalid ST;' -> true
6. 'DOB is valid; invalid STate;' -> false
Means the exact ST should be search. It is not free text search.
T-SQL is needed to be used in select statement with case using PATINDEX, RegEx or any suitable t-sql command.
i have report with parameter and he can have a null in parameter ther is null word can i change it to another word like all or any thing else
View 4 Replies View Relatedhi!
I'm just wondering does anyone know how to create an sql command that can search word by word?
what i mean is like I have a product with name 'harry potter broom'.
I want an sql command where if i type only 'harry broom' this 'harry potter broom' product will show up.
Does anyone have any idea?
Here's my sql comand: (I'm using asp.net vb script do develop this system)
-------------------------------------------------------------------------
query = "select distinct * from product where " & _
"(pname like '%" & keyword & "%' or " & _
"pdesc like '%" & keyword & "%' ) and " & _
"(price >= " & price1 & " and price <= " & price2 & _
") and status <> 'out of stock' order by price asc"
-------------------------------------------------------------------------
Thank you.
How can I enable using Arabic in an SQL DB?
View 2 Replies View RelatedDoes SQLServer support the Arabic language (characters, sorting, etc.)? If so what needs to be done to make this happen? Kind of a broad question but any push in the right direction would be appreciated.
View 2 Replies View RelatedI am creating application using ASP when I am trying toRetrieve an Arabic characters from the server it is appeared as a garbage.
Knowing that the Arabic characters are displayed within the query analyser as spouse to be.
I am working with Windows 2000, IE5.0, and ADO2.0.
Any one can help ???
how to enter arabic numerals in sql server 2005 fields?
like ١٢٣٤٥٦٧٨
hi
i try to restore a bak file from another sql2005 server to my sql2005 server, but it show the error message as below :
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
ADDITIONAL INFORMATION:
Cannot open backup device 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackupackup.bak'. Operating system error 5(error not found).
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3201)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=3201&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
pls some one can help me ???
thanks
chaus
am having a problem in searching the database which contains arabic and hebrew text, while the english search works just fine, the arabic and hebrew always return no match. the data is stored and utf-8 the website is at www.allforpeace.org .
is their a way to encode the text or what ever ...!! i need help
How do you setup your database to allow storing languages such as Arabic?
View 10 Replies View RelatedHi,
Whether Hijiri (Arabic) date will accept by sql server??
What I mean is, In my table the datatype for date field is datetime. But I need to enter some Hijiri (Arabic calender) dates
like 01/11/1429 10:10:00 PM.
But its not accepting...Showing error datetime field overflow.
Is there anyway to add this?
Wiht regards
Shaji
Hi yeah.
I am doing a project which retrieves data from a AS/400 machine.
The code page of the machine is 420.
I used "OLE DBIBM DB2 UDB for iSeries IBMDASQL OLE DB Provider" to connect from SQL Server.
The problem is, all the arabic characters coming from this machine becomes unreadable, becoming some machine code text.
What could be the problem and how can I solve this?
Thank you.
Can you open/use a database created in SQL2005 in SQL2005 Express?
Thanks for the help!
Max
Is the word "Name" a reserved word in SQL? look at line 10 of my stored procedure. When I use the word "Name"it is highlited in blue by SQL Server?
Note I only list part of the stored proc
1 CREATE PROCEDURE [dbo].[GetXMLPeopleNames] 23 (4 @Status nvarchar(3)5)6 AS7 SELECT8 PersonId,9 PersonDescription,10 Name,11 UpdateDate,12 UpdateAppUser13 FROM14 Customer WHERE Customer.PersonDescription=@Status15 ORDER BY
I am having a problem in a VB.NET application, i have a form that the user fills to store data in the database, the problem is that when i enter Arabic string, it gets stored in the database as question marks '??????'
The database field type is nvarchar, anybody went across this problem?
Hi i use sql server 2000 and i found problem in my database that is
when i write arabic language and closing my table and open it again i found all my data like question mark.
what can i do to save my data with arabic language.
note i use windows 2000 server.
Dear all ..
i have a serious problem & all ur comments will be appreciated..
i have bought an ASP .NET publishing tool which i receieved an sql script with it to execute on either Ms sql server or MSDE .
i executed it on MSDE as i don't have Ms sql server on my windows dedicated server .
I wanted the tool for publishing (Arabic Language)content for a highly traffic soccer website..
After executing the sql script i tested the tool but i found arabic characters are not saved when i add articles .. they were saved as question marks (??).
so i re-executed the sql script on a new db after modifying every code containg (varchar) to (nvarchar) to support unicode & thus arabic.
it worked & i succeeded in saving arabic articles
BUT >>>>>>>>>>>>>
i found that only short arabic articles r saved fine while any article that reaches around (1 microsoft word page) is not saved well with arabic characters but saved as question marks ( ??? ) .. !!
=======
so i checked the db tables using ASP.NET Enterprise manager & i found that
the field of article has (ntext) & infront of it number 16 ..
it seems that the (ntext) has a limit to wt it can save ..
so i believe there's a way which i don't know to make the (ntext) accepts long articles entry .
========
Here's the code in the original sql script i received with the tool & i hope u can guide me in details to any modification to do so that the ntext limit is raise to save any long arabic article.
========
code :
CREATE TABLE [dbo].[xlaANMarticles] (
[articleid] [int] IDENTITY (1, 1) NOT NULL ,
[posted] [nvarchar] (50) NOT NULL ,
[lastupdate] [nvarchar] (50) NOT NULL ,
[headline] [nvarchar] (350) NOT NULL ,
[headlinedate] [nvarchar] (255) NOT NULL ,
[startdate] [nvarchar] (50) NOT NULL ,
[enddate] [nvarchar] (50) NOT NULL ,
[source] [nvarchar] (255) NOT NULL ,
[summary] [nvarchar] (3000) NOT NULL ,
[articleurl] [nvarchar] (1000) NOT NULL ,
[article] [ntext] NOT NULL ,
[status] [tinyint] NOT NULL ,
[autoformat] [nvarchar] (50) NOT NULL ,
[publisherid] [int] NOT NULL ,
[clicks] [int] NOT NULL ,
[editor] [int] NOT NULL ,
[relatedid] [nvarchar] (2000) NOT NULL ,
[isfeatured] [nvarchar] (10) NULL ,
[keywords] [nvarchar] (255) NULL ,
[description] [nvarchar] (255) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
i highlighted the specific column for the article field with red color ..
i tried making it (nvarchar) but the sql manager i use saud it can't be done coz. there has to be a field for TEXTIMAGE coz. it's set to be (on) in the code.
waiting for ur help plz. ... i am desperate .. :confused:
Hi,
I am trying to insert some arabic characters into one of the tables but after I insert it, it get stored as ?????. What should I do? I have SQL Sever Managment Studio Express running on Windows XP. I appreciate any suggestions!!
Thanks
Hi Team Members,
I am planning to develop application using VB.NET and MS SQL Server Express.
Complete application (Forms and Reports) will be in Arabic,
1. Can I use SQL Server Express for this senario
2. Can I perform search in Arabic (Numeric and Text)
3. Can I take back up of Database
4. Just to make sure, can I have Stored Procedures, Views and security features in SQL Server Express
Regards,
Mustaq
I just upgraded my SQL 2000 server to SQL2005. I forked out all that money, and now it takes 4~5 seconds for a webpage to load. You can see for yourself. It's pathetic. When I ran SQL2000, i was getting instant results on any webpage. I can't find any tool to optimize the tables or databases. And when I used caused SQL Server to use 100% cpu and 500+MB of ram. I can't have this.Can anyone give me some tips as to why SQL 2005 is so slow?
View 3 Replies View RelatedHi
We have Sql2005 x64 bit standard edition server installed in windows 2003 64 bit editio server,
currently due to buisness requirements we need to have sql2005 x64 bit enterprise edition, please let me know how do i do the upgrade or change.
is it possible to retain all our custom settings in the standard edition after changing to enterprise edition.
This has to be done for our production and very critical, please help
Thanks
Samuel I
Hi,
How to insert or store arabic data into a table in sql server 2005, also i want to retrieve it as arabic format.But now it insert (?????) like this.Please help me to find a solution.
Regards
Sabna S
HI, i work on Sql Developer Edition when i select for any Company name in arabic it does not get any data ,why? although my data are inserted by arabic language,please help me asap,thank youand my code like this use todayselect CatID from dbo.tbl_Categories where CatName like '%اتصالات%'
View 11 Replies View RelatedHi
I am developing an application where i want to store the different language (i.e. chines,Arabic,urdu etc) character in database (SQL Server). so when i store arabic characters in SQL server , it stores the (???????).
datatype of field is nvarchar.
is anybody know about the problem and solution.
Regards
Mubahsar Ghazi
Hello there, I'm trying to use the full text search feature in SQL server 2000, when I search in arabic language I got a message telling that I'm searching for an ignored word the errore message I receive is:
--------------------
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]A clause of the query contained only ignored words.
--------------------
I have tried to configure the SQL server settings, I added the following code in the functions:
--------------------------
exec sp_configure 'show advanced options', '1'
reconfigure
exec sp_configure 'default full-text language', '0'
reconfigure
exec sp_configure
reconfigure with override
--------------------------
But this didn't solve the Arabic language problem!
Please Advice
Regards
Jone
I want to insert arabic characters in my sql server db. I need create table and insert syntax to insert arabic characters.
Can anyone help me???
Hi,
I want to store arabic values and dates in sql server database.
I am using visual basic 2005 with sql server 2005. I entered the the arabic values through visual basic forms. But when i open the database table, i see the values in english format.
I change my regional settings of the operating system is arabic (platform vista).
Can you give how to see arabic values.
Thanks.
Regards
Kashif Chotu
Hi
How can I check whether an nchar column contains Arabic character set? The only allowed values that can go into this column are English and Arabic.
Thanks,
Salman Shehbaz.