please its urgent is there any way to enable

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 Administration (2000)

please its urgent is there any way to enable

Author

Topic

asifbhura
Posting Yak Master

165 Posts

Posted - 2005-02-28 : 03:57:23

Hi everyone

I have two databases one is bayan and other is clearance. both databases havesame table,view and records.it contains both arabic and english records.

In clearance database when i try to fetch records as namw of arabic it is working but when i try with bayan databases.it runs but it doesnt display any records,

is there anything like that to enable languages in sql server.

query i am trying is like :
select * from customers where cust_name_araib='here somearabic text'

there is no problem with english in both databases.

Please reply soon

thanx in advance.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-02-28 : 04:04:12

what collation does the arabic database use?

Go with the flow & have fun! Else fight the flow

asifbhura
Posting Yak Master

165 Posts

Posted - 2005-02-28 : 09:21:40

hi everyone

in both database i am getting as below

No Column Name
NULL

waiting for reply

Please help me out

Thanx and regards,

asifbhura
Posting Yak Master

165 Posts

Posted - 2005-02-28 : 09:25:03

hi evryone

in both database i am getting as below

in Clearance
i am getting
Arabic_CI_AS

and in Bayan
I am getting
SQL_latin1_General_CP1_CI_AS
Please help me out

waiting for reply.

Thanx in advance

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources