Create an NVARCHAR column in MySQL using code first?

Question

So, unlike SQL Server, in MySQL, the following property creates a column of type LONGTEXT:

public string Name { get; set; }

I want to have an NVARCHAR(255) column instead, so I tried the following:

//[DataType("NVARCHAR"), StringLength(255)]     // creates a varchar(255) column.
[DataType("NVARCHAR"), MaxLength(255)]          // creates a varchar(255) column.
public string Name { get; set; }

I also tried the following with Fluent API:

modelBuilder.Entity<MyEntity>()
    .Property(p => p.Name)
    .HasColumnType("NVARCHAR")
    .HasMaxLength(255);             // still creates a varchar(255) column.

..and:

modelBuilder.Entity<MyEntity>()
    .Property(p => p.Name)
    .HasColumnType("NVARCHAR(255)");

Which causes an InvalidOperationException with the following message:

The store type 'NVARCHAR(255)' could not be found in the MySql provider manifest

Is there something I'm doing wrong? What is the correct way to create an nvarchar column using code-first?

You're right, turns out it was just an alias in MySQL Workbench which maps to varchar with `utf8` collation. — 41686d6564 stands w. Palestine, Apr 11 '18 at 14:32

score 3 · Accepted Answer · answered Apr 11 '18 at 14:31

3

MySql does not have NVARCHAR type. For alternative solutions consult: mysql equivalent data types

answered Apr 11 '18 at 14:31

meta4

788
1
10
24

2

Thanks, I've been misled somehow by the `NVARCHAR` alias in MySQL Workbench. – 41686d6564 stands w. Palestine Apr 11 '18 at 14:43

Create an NVARCHAR column in MySQL using code first?

1 Answers1