Collation data base

[raai]

I created one data base with collation equal to SQL_Latin1_General_CP1_CI_AS.
The server have installed SQL Server 2005.

I created a web application when i make a insert or update, the data saving wrong (p.e BLVD Ñ Í Ó DIAZ ORDAZ, must be BLVD Ñ Í Ó DIAZ ORDAZ)

The charset of web application is ISO 8859-1.

Please help me, thank's

 

[yelworcm]

You can always define the address field as nvarchar. nvarchar uses 2 bytes per character, but it gives you all of the unicode characters.

Alternatively, you can change the code page for the database, but that is a pretty painful way to go.