Chinese characters not encoding correctly when deploying project

xacLincoln

Hi, thanks for the hard work. 
After building a readyroll project in vs 2017 (Readyroll version 1.17.18158.17), the generated database sql scripts contain wrongly encoded Chinese characters . The original migration script file is ok. The deployment failed because of the wrong  encodings.
I've been stuck by this in a few days. Is there any workaround?

Sergio R

I suspect this is due to a bug in ReadyRoll that we are currently investigating.

If that's the case, you should be able to workaround this by doing the following:

1. Right-click the Pre-Deployment folder and select Add... Script. 
2. From the template dialog, select Script (Not in Build) and prefix the filename with the next migration number (e.g. 0100_myscript.sql)
3. Move the script to the desired migration sub-folder
4. Open the script for editing and click Insert Metadata
5. Add script content and build

If this doesn't resolve our issue, and you have ReadyRoll Pro and valid support, please contact us at
https://productsupport.red-gate.com/hc/en-us