Chinese characters not encoding correctly when deploying project

xacLincolnxacLincoln Posts: 1 New member
edited June 14, 2018 6:01AM in ReadyRoll
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?

Tagged:

Answers

  • Sergio RSergio R Posts: 575 Rose Gold 5
    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
    Sergio
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools
Sign In or Register to comment.