Question: We accept the accented characters such as `Ḿấxiḿứś` from a html form, when using hibernate saves it into the database the string becomes `??xi???`

Then I did a SQL update, trying to write the accented words directly into the database, the same result happened.

The desired behavior is to set into the dabase as what it is.

I am using Microsoft SQL Server 2008. 

I have tried to google it, someone said I need to change the database collation to `SQL_Latin1_General_CP1_CI_AI`. But I can't find this options from the dropdown.

Answer: 
```
ALTER TABLE table_name ALTER COLUMN coloumn_name NVARCHAR(40) null

```

if you are using hibernate that's all you need.

I have attempted to change the table collation but it didn't work, maybe
you have to backup your data, create a fresh database with the new collation 
then pop back the data.

my database setting the collation is AS (accent sensitive), please make sure
yours has the same setting
```
ALTER TABLE "tablename"

Alter COLUMN "columnname" nvarchar(64) COLLATE SQL_Latin1_General_CP1_CI_AS

```