Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

non-UK/US character set

Status
Not open for further replies.
mp89

mp89

Programmer
Sep 17, 2004
35
GB
How do you change the setup of SQL Server to allow foreign characters such as ä, ö, å?


Cheers,

Mike
 
Sort by date Sort by votes
Select a different collation type when creating the database, table, column or when installing to make it the default and server wide.

Denny

--Anything is possible. All it takes is a little research. (Me)

[noevil]
 
Upvote 0 Downvote
or if one character set will not contain all the special characters you need, then use unicode datatypes such as nvarchar, nchar and ntext.

Questions about posting. See faq183-874
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
649
Mike Lewis
Mike Lewis
bmacbmac
  • Locked
  • Question
Help with RegEx to find non alphanumeric characters
Replies
1
Views
1K
ggriffit
ggriffit
Cpreston
  • Locked
  • Question
Last date per userid 1
Replies
3
Views
306
Andrzejek
Andrzejek
jimoo
  • Locked
  • Question
How to set variable to field in current row
Replies
2
Views
1K
Chris Miller
Chris Miller
Auguy
  • Locked
  • Question
Using UDF In Select, Bad Idea? 2
Replies
3
Views
379
Auguy
Auguy

Part and Inventory Search

Sponsor

Back
Top