Insert of special characters into db table fails

[kap]

Hello,

I like to insert a row into my table using dotconnect for MySQL entity framework.

The table contains to fields:

index column (int)
name column (varchar)

Here is my code:

Code: Select all

// insert new value
int NextID = pe.Categories.Select(c => c.CategoryIndex).Max() + 1;

ProductsModel.Category objCategory = new ProductsModel.Category() { CategoryIndex = NextID, CategoryName = category };

pe.AddToCategories(objCategory);
pe.SaveChanges();

The string in the category name is

"W/Ö Emulsion"

The result in the database table is

"W/"

Does anyone know why it cuts the string after the slash? I dont get it...

Thank you.

Best regards,

Philipp

[Shalex]

Try using the "Unicode=True;" option in the connection string.

If this doesn't help, please give us the following information:
1) the character set of your MySQL server
2) the version of your MySQL server
3) the build number (x.x.x) of your dotConnect for MySQL
4) the datatypes of the CategoryName property in SSDL and CSDL parts of your model

[kap]

Hi Shalex,

using "Unicode=True;" did the job!

Thank you very much.

Best regards,

Philipp