Inserting and Selecting Arabic text

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Inserting and Selecting Arabic text

Author

Topic

hasanali00
Posting Yak Master

207 Posts

Posted - 2006-05-25 : 06:18:50

Hi

For my next personal project, I want to be able to Insert arabic text in a database. Then I want to write an SQL query to search for arabic text within the tables.

I would be grateful if you could help me to understand the requirements for developing such database driven application.

I will be hosting the application on a Shared SQL Server, so I wont have much control over the database settings.

regards

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-05-26 : 04:01:04

rough idea...

you need to have a table for the set of arabic characters and search against that table

HTH

--------------------
keeping it simple...

hasanali00
Posting Yak Master

207 Posts

Posted - 2006-05-26 : 12:14:56

I am sure its not as simple as this. For instance, I inserted ' ãÍãÏ' into a column and then did the search:

SELECT *
FROM Test
WHERE (t LIKE 'ã%')

But this not return anything

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-05-27 : 00:58:30

well i tried it and i got the record, you have a space before ãÍãÏ
which is why your search failed

quote:
Originally posted by hasanali00

I am sure its not as simple as this. For instance, I inserted ' ãÍãÏ' into a column and then did the search:

SELECT *
FROM Test
WHERE (t LIKE 'ã%')

But this not return anything

--------------------
keeping it simple...

hasanali00
Posting Yak Master

207 Posts

Posted - 2006-05-27 : 08:20:19

I posted some arabic text in my last post. But I think it did not appear correctly on the webpage. Can you please see the image. My arabic text appears in this image
http://img136.imageshack.us/img136/2382/arabictext21yh.jpg

But on the webpage, it was changed to:
http://img136.imageshack.us/img136/6606/arabictext18hy.jpg

regrads

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2006-05-27 : 08:44:12

Arabic Text alignment is from left to right so make sure about wildcard character (%) should be at the opp side ..

If Debugging is the process of removing Bugs then i Guess programming should be process of Adding them.

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-05-27 : 12:03:17

there is still a space in that image

if you are able to save the character in a table then you can query it also...

or explore ascii, unicode to compare by int value instead of character

--------------------
keeping it simple...

cmdr_skywalker
Posting Yak Master

159 Posts

Posted - 2006-05-27 : 16:26:39

you should use a different collation set (144-146 for arabic) using unicode data type. See BOL (under collation-- international support) for more info.

May the Almighty God bless us all!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources