words with accents in SQL database

Posted on 2007-10-10
Last Modified: 2013-11-16
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?
Question by:bluesman1975
    1 Comment
    LVL 27

    Accepted Solution

    It probably has to do with your collation.

    In SQL 2005, in Management Studio, type


    That should return your collation setting.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Suggested Solutions

    This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now