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 |
|
viccan1
Starting Member
6 Posts |
 Posted - 2009-07-03 : 03:48:02
|
| If I run this query through SQL Management studio:UPDATE [ver].[dbo].[TableName] SET [Tekst] = 'Northern Sámi: Áá Cc Ðd ?? Šš Tt Žž' WHERE [lang] = 'sme' AND [kode] = 'test'These letters ‘??’ are saved as ‘??’If I save this text through web application everything is Ok.Any ideas?p.s: Seems this forum has kind of same problem. These are the problems letters:http://www.google.com/search?hl=en&rls=com.microsoft%3Aen-US%3AIE-SearchBox&q=%C5%8A%C5%8B&aq=f&oq=&aqi=http://en.wikipedia.org/wiki/Sami_languages -> From Nothen sami the fourth one.Thanks |
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2009-07-03 : 03:56:50
|
| hiCan you fetch the data which u have saved. i hope its shows correct format. |
 |
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2009-07-03 : 04:03:39
|
| Hii believe its useful for you.....using the Unicode nchar, nvarchar, and nvarchar(max) data types is the best choice. Second, for the specifing collation of text in a particular column. 1,You can choose a collation and set the sort-order options during table design. 2,If you have not previously set a collation on the column, when you click the column, the dialog box lists <database default> for the Collation property of the column. To change the collation, click the ellipsis (...) button. This opens the Collation dialog box, where you select either a Windows collation or a SQL Server collation, and set sorting options. 3,You can also set column-level collations using Transact-SQL by adding a COLLATE clause to the column definition in the CREATE TABLE statement. I suggest you reading the 'Collations Specified at the Column Level' Part: http://msdn2.microsoft.com/zh-cn/library/bb330962.aspx |
|
|
|
viccan1
Starting Member
6 Posts |
Posted - 2009-07-03 : 04:13:44
|
| The type of the column is ‘Nvarchar’ and the collation is SQL_Latin1_General_CP1_CI_AS |
|
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2009-07-03 : 04:18:03
|
| http://support.microsoft.com/kb/322112 |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-07-03 : 04:18:07
|
quote:
Originally posted by rajdaksha
I suggest you reading the 'Collations Specified at the Column Level' Part: http://msdn2.microsoft.com/zh-cn/library/bb330962.aspx
rajdaksha, are you going translate that ? 
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2009-07-03 : 04:22:18
|
| sorry now i got the same problem will update...soon |
|
|
|
viccan1
Starting Member
6 Posts |
Posted - 2009-07-03 : 04:51:02
|
| Solution is:SET [Tekst] = N'Northern Sámi: Áá Cc Ðd ?? Šš Tt Žž'Is it possible to configure MS SQL studio in some way so I can run these queries without setting N ? |
|
|
|
|
|
|
|
|
Problem with Sami language text.