Create a new Database named, [Test]
1. Right-click on [Databases]
2. Choose [New Database]
When Dialog opens.
3. Database Name: [Test]
4. [Database files]:
The Path for each will be crucial during your database production on a live server.
[ROWS Data]: F:\SQLData
[Log]: G:\SQLLog
However, if you are working with a basic setup machine, this will be set as defaulted to your C:\ drive.

5. Click on Options
[Collation]: (Selecting the appropriate term will allow certain character types to keep their appearance in your database.
There is a long list, so choose the right one for your needs.) Recovery Model: (Choose either Full or Simple - For testing purposes, it is best to choose Simple, for Production, choose Full)
6. Choose [OK]

When dealing with accented characters, choose
1. [collation] = sql_latin1_general_cp1_ci_as
2. [Data Type] = For all the Columns you need to accept accented characters. Set their character set as [nvarchar].

In your Classic ASP code, you will need to have the following. Take note of the ADO constants, [adLongVarWChar]
sqlCode.Parameters.Append sqlCode.CreateParameter("@ColumnName", adLongVarWChar, adParamInput, 500, strCode)
For [ASP.NET] you will not have to add the above to your code.