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 |
|
CSK
Constraint Violating Yak Guru
489 Posts |
 Posted - 2008-10-31 : 08:45:55
|
| Gurus,My database collation is default case insensitive.I want display the characters in Arabic_CI_AS. I meant the select statement should return the records in Arabic_CI_AS.I cant change into the database. Is it possible to do through Query..?Please Help me to solve this issueThanks-- Krishna |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2008-10-31 : 10:09:31
|
| This is from Books On Line under CONVERT FunctionSELECT CAST('abc' AS varchar(5)) COLLATE French_CS_ASJim |
 |
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2008-10-31 : 10:11:07
|
| Thanks for your reply, But I am not getting the arabic output. It is in English. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-31 : 10:45:56
|
| what is the database's default collation? will it support arabic characters? |
|
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2008-10-31 : 10:48:43
|
| The default collation I meant by SQL_Latin1_General_CP1_CI_AS. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-31 : 10:55:15
|
| is the field unicode? i.e nvarchar,ntext... |
|
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2008-10-31 : 11:39:46
|
| It is varchar |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-31 : 11:44:21
|
| make it unicode to store arabic characters. |
|
|
|
|
|
|
Collation Help