IntranetFactory / migratordotnet

Automatically exported from code.google.com/p/migratordotnet
0 stars 0 forks source link

Database.Insert does not support Unicode characters (SQL Server) #163

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?

1. Create a migration script for a SQL Server DB.
2. In Up(), add a call to Database.Insert and include Unicode chars 
(non-western) in the values array.
3. Execute the migration.

What is the expected output? What do you see instead?

Expected:  Unicode chars will be properly inserted into the DB.

Actual:  Unicode chars are inserted as "?".

What version of the product are you using? On what operating system? With what 
.NET implementation/version?

0.9.0.28138; Windows Server 2008 R2; .NET 4.0

What database and version are you seeing this issue on?

Any SQL Server DB.

Please provide any additional information below.

Generated SQL should include an "N" prefix for chars/varchars.

Original issue reported on code.google.com by cw_sny...@hotmail.com on 10 Dec 2010 at 7:24