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 |
|
raveekumarg
Starting Member
36 Posts |
 Posted - 2008-10-10 : 05:04:03
|
| hi i have the below setting in my sql 7.0 settings...========================================================Unicode data sorting ---------------------- Locale ID = 1033 case insensitive, kana type insensitive, width insensitive Sort Order Description ------------------------------------------------------------------------------------------------------------------------------------ Character Set = 1, iso_1 ISO 8859-1 (Latin-1) - Western European 8-bit character set.Sort Order = 52, nocase_iso Case-insensitive dictionary sort order for use with several We stern-European languages including English, French, and German . Uses the ISO 8859-1 character set.====================================================================i am going to migrate my database to sql 2k, while installation what type of character set or option i need to give...if wrongly installed how to change the existing one in sql 2ksettings in my sql 2k ======================Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for non-Unicode Dataexpecting ur feedback soon |
|
|
raveekumarg
Starting Member
36 Posts |
Posted - 2008-10-13 : 05:06:27
|
| i don't know why no one intrested to reply on the same. TOUGH GUYS PL REPLYravi |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-10-13 : 05:15:58
|
[code]SELECT 'ALTER TABLE ' + sysobjects.name + ' ' + 'ALTER COLUMN ' + syscolumns.name + ' ' + systypes.name + '(' + cast(syscolumns.length as varchar) + ') ' + 'COLLATE ' + syscolumns.collation + ' ' + case when syscolumns.isnullable = 1 then 'NULL' else 'NOT NULL' end sql from syscolumns inner join sysobjects on sysobjects.id = syscolumns.id inner join systypes on systypes.xtype = syscolumns.xtype where syscolumns.collation is not null and sysobjects.xtype = 'U'[/code]
E 12°55'05.63"N 56°04'39.26" |
|
|
|
raveekumarg
Starting Member
36 Posts |
|
|
|
|
|
|
|
sort order