| Author |
Topic |
|
Shameej
Starting Member
6 Posts |
 Posted - 2010-05-12 : 03:17:07
|
| Hi all,Is there any way for specify collation property only for tables/column without specify for database |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-05-12 : 03:27:18
|
Yes.In create statement you can use collation.In select statement you can use collate.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
Shameej
Starting Member
6 Posts |
Posted - 2010-05-12 : 07:58:20
|
| Hi webfred thanks for your post....I used like thisALTER TABLE tbNameALTER COLUMN TechnicalComments Text COLLATE Greek_CS_ASwithout specify collate for database..But i cannot insert the proper greek value into this column..I am looking for a solution for this |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-05-12 : 08:06:25
|
For datatype TEXT you should use VARCHAR(max) because TEXT will disappear in future versions.And in your case I think you should use NVARCHAR(max) so that the column can take unicode values.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
Shameej
Starting Member
6 Posts |
Posted - 2010-05-12 : 08:18:18
|
| Sorry..Whatever it is I cannot change the column type...any other way? |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-05-12 : 08:20:53
|
quote:
Originally posted by Shameej
Sorry..Whatever it is I cannot change the column type...any other way?
Why not?You where also able to change the collation.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
Shameej
Starting Member
6 Posts |
Posted - 2010-05-12 : 08:37:39
|
| no need of argue....i can't change the type... |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-05-12 : 08:55:04
|
I am sorry but as far as I know the only solution is to change the type to a unicode type.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
Shameej
Starting Member
6 Posts |
Posted - 2010-05-12 : 09:07:52
|
| actually the solution for your reply ..we can directly specifythe collation for column...please look at the example that i putearly in this topic...(But the DB should also specify collate)my problem is same ..but without collate for DB |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-05-12 : 09:13:24
|
To store greek values in that column the collation will not help.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
Shameej
Starting Member
6 Posts |
Posted - 2010-05-13 : 00:26:33
|
| it will work for greeg too..i worked it .....only thing is we need to set collation for columnand table along with DB |
|
|
|
|
collation only for table