Skip to content

non utf8 characters(?) lost during cloning #4

Description

@lathonez

Source:

select activityObjs from client where pool = 'globalballooningaustralia';
[{"name":"Mandarin","val":"zh_cn","visibility":"all","cssClass":"zhcn","termsAndConditions":"<p>风险承担及免责声明</p><p>我明白澳大利亚环球热气球公司会尽最大努力,以保证我们 的飞行处于安全当中,并且热气球公司没有责任承担疾病,个人 伤害,相机等其他个人物品的丢失或损坏,公民逮捕或者参与飞 行过程中造成的死亡。<br>环球热气球公司提醒您,任何自愿参与的高空运动或有风险的环 境,包括热气球在内,都存在一定的危险。我作为一个潜在的热 气球乘客/船员必须愿意承担风险。<br>因此,我签名,承认此热气球飞行存在潜在危险,并承担我的人 身安全损失或财产损失的所有风险和责任。我乘坐热气球的公司 ,其受雇人、代理人或雇员,不承担热气球乘坐过程中的风险和 责任。</p><p>我,在此签名表示,已详细阅读及理解上文中的内容,并且愿意 承担我个人的风险</p><p>签名:</p><p>日期:</p>","finalGuestStatus":"Active"}]

Clone:

CloneRow.py -f prod local client pool globalballooningaustralia
2016-06-22 15:35:31 Reading configuration..
2016-06-22 15:35:31 The following columns will be ignored: id createdAt updatedAt lastGuest lastLogin 
2016-06-22 15:35:31 attempting to connect to prod..
2016-06-22 15:35:33 getting prod row..
2016-06-22 15:35:33 getting local row..
2016-06-22 15:35:33 checking encoding..
2016-06-22 15:35:33 source encoding utf8:utf8_general_ci
2016-06-22 15:35:33 target encoding utf8:utf8_general_ci
2016-06-22 15:35:33 finding deltas..
2016-06-22 15:35:33 
2016-06-22 15:35:33 |--------------------------------|Data Changes|--------------------------------|
2016-06-22 15:35:33   The following columns will be updated on local
2016-06-22 15:35:33     -activityObjs 
2016-06-22 15:35:33 |------------------------------------------------------------------------------|
2016-06-22 15:35:33 
2016-06-22 15:35:33 backing up target row..
2016-06-22 15:35:33 backup file can be found at /tmp/client-pool-globalballooningaustralia-1466573731768.backup on local
2016-06-22 15:35:33 dumping update sql to disk..
2016-06-22 15:35:33 update sql is available for inspection at /tmp/client-pool-globalballooningaustralia-1466573731768.sql on this machine
2016-06-22 15:35:33 Row has been cloned successfully..
2016-06-22 15:35:33 Not prompting to restore from backup as you're felling lucky today
2016-06-22 15:35:33 
2016-06-22 15:35:33 operation completed successfully, have a fantastic day
2016-06-22 15:35:33 housekeeping..

Target:

select activityObjs from client where pool = 'globalballooningaustralia';
[{"name":"Mandarin","val":"zh_cn","visibility":"all","cssClass":"zhcn","termsAndConditions":"<p>?????????</p><p>?????????????????????????? ???????????????????????????? ???????????????????????????? ??????????<br>???????????????????????????? ???????????????????????????? ????/???????????<br>???????????????????????????? ???????????????????????????? ???????????????????????????? ???</p><p>???????????????????????????? ????????</p><p>???</p><p>???</p>","finalGuestStatus":"Active"}]

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions