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 |
|
ashrefcp
Starting Member
7 Posts |
 Posted - 2008-01-20 : 06:52:51
|
| dear all,i would like to create a new database with the following collation name.Characterset: cp1256SortOrder: nocaseI will need a string to be used in the create database command/ alter database command.Any help on this will be highly appreciated.Regards,/ash |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-20 : 20:14:17
|
| Use Arabic collation which uses the Arabic character set (code page 1256). |
 |
|
|
ashrefcp
Starting Member
7 Posts |
Posted - 2008-01-20 : 23:42:09
|
Can anybody provide the actual collation string to be used like "Latin1_General_CI_A", as I am new to this.OR which system table would have the list of collations to pick?Regards,/ashquote:
Originally posted by rmiao
Use Arabic collation which uses the Arabic character set (code page 1256).
|
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-21 : 01:00:06
|
| Arabic_CI_AS |
|
|
|
ashrefcp
Starting Member
7 Posts |
Posted - 2008-01-23 : 01:14:53
|
source server configuration: cp1256, nocase (SQL Server 6.5 on NT)destination server configuration: cp1256, nocase (SQL Server 2005 on windows 2003)I am still facing problem in bcp out and bcp in. The -V65 is tried out. The problem seems to me is that the bcp out from Win-MT at DOS prompt is turning the bcp out file into its own charset format, probably using some preset feature like auto convert for chars.How to workaround this and get my arabic data in proper way into SQL2005.Any help is highly appreciated.Regds,/ashquote:
Originally posted by rmiao
Arabic_CI_AS
|
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-23 : 22:49:51
|
| See your other post for the issue. |
|
|
|
|
|
|
what is the collation name for cp1256 nocase