• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 335
  • Last Modified:

words with accents in SQL database

hello,
I have an ASP page that insert filelds values to a SQL database.
If I want to insert a world with an accent (eg: perchè), in the DB I will find perchà.
What settings I have to use to solve this problem?
0
bluesman1975
Asked:
bluesman1975
1 Solution
 
ptjcbCommented:
It probably has to do with your collation.

In SQL 2005, in Management Studio, type

SELECT SERVERPROPERTY(N'Collation')

That should return your collation setting.
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now