LIGHTSWITCH connection to MYSQL, Chinese characters cannot be saved----workaround.

Use:dotconnect for MySQL () as a database connection provider, referencing the external MySQL data source in LIGHTSWITCH.

http://www.devart.com/dotconnect/mysql/also has postgre.

LS Project not used: Chinese, but using EN to produce? It was later modified. Just no further testing .

LIGHTSWITCH connection MYSQL, when the Chinese characters entered, the occurrence cannot be saved.

1) Check MYSQL database and table, field definition, are: UTF8;

2) Check the link string that connects to the external database, modify the connectionstring in Web. config, add; Charset=utf8.

Ok!

<add name= "ff595410-d766-47ae-80b7-5965895e723e" connectionstring= "User id=root; password=zeng950213; host=127.0.0.1;database=eccom; Persist Security info=true ; Charset=utf8"/>

====================

ADO Data Providers:third-party Providers

Http://msdn.microsoft.com/en-us/data/dd363565.aspx