We will create a database ready for a production server.
(For learning and testing, please check out our "Create a Database«" article, which is not as in-depth and more suited for learning)
    Create a new Database named [Test]
  1. Right-click on [Databases]
  2. Choose [New Database]

    3. When Dialog opens.
  3. Database Name: [Test]
  4. [Database files]:

    5. 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 the default to your C:\ drive.
  5. Click on Options
    6. [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 to [nvarchar].
In your Classic ASP code, you will need to have the following. Take note of the ADO constants, [adLongVarWChar]
[VBScript Parameter]
CFFCS | CarrzSynEdit: | SQL Script 
sqlCode.Parameters.Append sqlCode.CreateParameter("@ColumnName", adLongVarWChar, adParamInput, 500, strCode)


For [ASP.NET], you will not have to add the above to your code.

You will then be able to insert words with characters like the following.
Dvořák Hall | Nürnberg Messezentrum Halle