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 |
|
Devonet
Starting Member
1 Post |
 Posted - 2005-05-27 : 06:08:21
|
| Hi,I have problem with sql server collation,database collation is Latin, and I want select datas in my .net web application in turkish encoding, how can I achieve that?is it possible?my localization setting is Turkish.Thanks in advance. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-05-27 : 09:04:36
|
have you looked at the convert function?why can't you do this at presentation layer?Go with the flow & have fun! Else fight the flow  |
 |
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2005-05-27 : 10:04:59
|
| For data held in char, varchar and text columns, the collation of the column will affect the characters that SQL Server thinks you are storing in it. This is not the case for nchar, nvarchar or ntext, where the character set is the Unicode UCS (probably only Unicode version 2, though).Consequently, if you want to store Turkish characters such as "latin small letter G with breve" (U+011F) or "latin capital letter I with dot above" (U+0130), then you have two alternatives. You can use a nchar, nvarchar or ntext type column. Alternatively, use a char, varchar or text column with a collation setting that uses a Turkish-capable character set (in practice, it will use Codepage 1254, which is ISO8859-9 plus some characters in the 128-159 codepoints). So that's one of these collations:SQL_Latin1_General_Cp1254_CS_ASSQL_Latin1_General_Cp1254_CI_ASTurkish_BINTurkish_CI_AITurkish_CI_ASTurkish_CS_AITurkish_CS_AS |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-05-27 : 17:13:07
|
| Also note that SQL 2000 lets you set the collation on a column by column basis. SQL 7 set the collation only at the database level.---------------------------EmeraldCityDomains.com |
|
|
|
|
|
|
|
|
Collation || Characterset