search

apache / shardingsphere

Distributed SQL transaction & query engine for data sharding, scaling, encryption, and more - on any database.
Apache License 2.0
19.81k stars 6.7k forks source link

The database code is utf8, but after proxy is GBK, there is garbled code #5886

Closed psh882003 closed 4 years ago

psh882003 commented 4 years ago

Bug Report

For English only, other languages will not accept.

Before report a bug, make sure you have:

Please pay attention on issues you submitted, because we maybe need more details. If no response more than 7 days and we cannot reproduce it on current information, we will close it.

Please answer these questions before submitting your issue. Thanks!

Which version of ShardingSphere did you use?

sharding-proxy 4.1.0+ PG

Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?

ShardingSphere-Proxy+ PG

Expected behavior

PG中文返回不乱码

Actual behavior

stCd=1, sysId=project), BaseDDCT(id=1830541, dctKey=LndCtrSigntyCd_1, dctTpCd=LndCtrSigntyCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=����ͬǩ�𷽴���, dctVal=1, dctValNm=��, stCd=1, sysId=project), BaseDDCT(id=1829441, dctKey=DfltPcsgCd_1, dctTpCd=DfltPcsgCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=ΥԼ����ʽ, dctVal=1, dctValNm=����ί�д���, stCd=1, sysId=unknow), BaseDDCT(id=1828716, dctKey=CltplgCtrSigntyCd_1, dctTpCd=CltplgCtrSigntyCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=����Ѻ��ͬǩ�𷽴���, dctVal=1, dctValNm=��, stCd=1, sysId=project), BaseDDCT(id=1829164, dctKey=appLoan, dctTpCd=CreditReportingInquiryType, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=��������, dctVal=02, dctValNm=��������, stCd=1, sysId=InternetCredit), BaseDDCT(id=1828291, dctKey=BsnVrty_1, dctTpCd=BsnVrty, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=contElcEcdType, dctVal=01, dctValNm=����, stCd=1, sysId=archive), BaseDDCT(id=1827969, dctKey=Manual, dctTpCd=AmortizationWay, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�˹�����, dctVal=1, dctValNm=�˹�����, stCd=1, sysId=InternetCredit), BaseDDCT(id=1829972, dctKey=GdDocType_1, dctTpCd=GdDocType, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=��������, dctVal=1, dctValNm=�������, stCd=1, sysId=archive), BaseDDCT(id=1828287, dctKey=BsnRgonCd_1, dctTpCd=BsnRgonCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=ҵ���������, dctVal=1, dctValNm=����, stCd=1, sysId=project), BaseDDCT(id=1827966, dctKey=AdvanceSvcClCd_1, dctTpCd=AdvanceSvcClCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=���ʷ���������, dctVal=1, dctValNm=�Ա�˾����������ҵ��, stCd=1, sysId=project), BaseDDCT(id=1829078, dctKey=CoveredSituation_1, dctTpCd=CoveredSituation, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�������, dctVal=1, dctValNm=ȫ����, stCd=1, sysId=custmanag), BaseDDCT(id=1829450, dctKey=DfltTrgrCd_1, dctTpCd=DfltTrgrCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=ΥԼ����, dctVal=1, dctValNm=ΥԼ������ȡ���ô�ʩ, stCd=1, sysId=unknow), BaseDDCT(id=1830183, dctKey=HsptyOwnTpcd_1, dctTpCd=HsptyOwnTpcd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=����Ȩ�����ʹ���, dctVal=1, dctValNm=���з�, stCd=1, sysId=project), BaseDDCT(id=1830410, dctKey=LegalPersonType_1, dctTpCd=LegalPersonType, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�ͻ���������, dctVal=1, dctValNm=��ҵ����, stCd=1, sysId=custmanag), BaseDDCT(id=1829954, dctKey=Loan, dctTpCd=Funds, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=-�˻�����ʽ����, dctVal=Reduce, dctValNm=-�˻�����ʽ����, stCd=1, sysId=InternetCredit), BaseDDCT(id=1829438, dctKey=DerateInt, dctTpCd=DerateRule, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=������Ϣ, dctVal=1, dctValNm=������Ϣ, stCd=1, sysId=InternetCredit), BaseDDCT(id=1829962, dctKey=inCash, dctTpCd=FundsSource, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�ֽ𻹿�, dctVal=1, dctValNm=�ֽ𻹿�, stCd=1, sysId=InternetCredit), BaseDDCT(id=1829219, dctKey=CstRelRelCd_12, dctTpCd=CstRelRelCd, dctDsc=null, dctGrp=1, dctSeq=1, dctTpNm=�ͻ�������ϵ����, dctVal=12, dctValNm=����������, stCd=1, sysId=project), BaseDDCT(id=1829969, dctKey=GdDocLevel_1, dctTpCd=GdDocLevel, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=��������, dctVal=1, dctValNm=һ������, stCd=1, sysId=archive), BaseDDCT(id=1830267, dctKey=Indicator_0, dctTpCd=Indicator, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=ָʾ��, dctVal=0, dctValNm=��, stCd=1, sysId=system), BaseDDCT(id=1829532, dctKey=DsbrCD_36, dctTpCd=DsbrCD, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�ſ�����, dctVal=36, dctValNm=Ӧ���˿�Ǽ�, stCd=1, sysId=product), BaseDDCT(id=1829526, dctKey=DsbrCD_30, dctTpCd=DsbrCD, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�ſ�����, dctVal=30, dctValNm=������������ѯ������ͨ���󳬹�1���·ſ, stCd=1, sysId=product), BaseDDCT(id=1829946, dctKey=FtchdtModCd_1, dctTpCd=FtchdtModCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=ȡ����ʽ, dctVal=1, dctValNm=SQL��ѯ, stCd=1, sysId=system), BaseDDCT(id=1828241, dctKey=Borrower_1, dctTpCd=Borrower, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�����/������, dctVal=1, dctValNm=�����, stCd=1, sysId=custmanag), BaseDDCT(id=1829948, dctKey=FudMnpltCd_1, dctTpCd=FudMnpltCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�����������, dctVal=1, dctValNm=��˾������Ա��Ȩ֤��ͬ����˫����ͬ��, stCd=1, sysId=project), BaseDDCT(id=1830231, dctKey=IdxWarnCmptCd_01, dctTpCd=IdxWarnCmptCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=ָ��Ԥ���������, dctVal=01, dctValNm=�������, stCd=1, sysId=riskwarn), BaseDDCT(id=1830332, dctKey=IntrtPrcgCgyCd_1, dctTpCd=IntrtPrcgCgyCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=���ʶ���������, dctVal=1, dctValNm=��ͨ����Ҵ���, stCd=1, sysId=custmanag), BaseDDCT(id=1830546, dctKey=LndStcd_3, dctTpCd=LndStcd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�˺����ʹ���, dctVal=3, dctValNm=�ѻ���, stCd=1, sysId=account), BaseDDCT(id=1831031, dctKey=MoCd_1, dctTpCd=MoCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�·ݴ���, dctVal=1, dctValNm=1��, stCd=1, sysId=project), BaseDDCT(id=1831048, dctKey=OUT, dctTpCd=ModelDataParamType, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=���, dctVal=OUT, dctValNm=���, stCd=1, sysId=InternetCredit), BaseDDCT(id=1829934, dctKey=FourDepCustSizeLevelCode_1, dctTpCd=FourDepCustSizeLevelCode, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=��ҵ��ģ���IJ�ί��׼��, dctVal=1, dctValNm=����, stCd=1, sysId=custmanag), BaseDDCT(id=1828772, dctKey=ComTrckMPnt_1, dctTpCd=ComTrckMPnt, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=һ�����Ҫ��, dctVal=1, dctValNm=�ͻ�������ҵ״��, stCd=1, sysId=product), BaseDDCT(id=1829940, dctKey=FstpyUnfrzPcpCd_1, dctTpCd=FstpyUnfrzPcpCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�׸���ⶳ���뷽����, dctVal=1, dctValNm=������˫��, stCd=1, sysId=project), BaseDDCT(id=1828220, dctKey=MenuType_0, dctTpCd=BizSceneType, dctDsc=��������Ȩ�޿���, dctGrp=1, dctSeq=1, dctTpNm=ҵ�񳡾�����, dctVal=, dctValNm=, stCd=1, sysId=common), BaseDDCT(id=1828727, dctKey=CmtdCd_1, dctTpCd=CmtdCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�շѷ�ʽ����, dctVal=1, dctValNm=��˾Ԥ�մ���˰�ѣ����մ���, stCd=1, sysId=project), BaseDDCT(id=1830066, dctKey=EndOfMonth, dctTpCd=GranceRule, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=��������ĩ, dctVal=1, dctValNm=��������ĩ, stCd=1, sysId=InternetCredit), BaseDDCT(id=1830087, dctKey=GurtTpCd_1, dctTpCd=GurtTpCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=����������, dctVal=1, dctValNm=����, stCd=1, sysId=unknow), BaseDDCT(id=1830234, dctKey=IdxWithTrValOptRelCd_01, dctTpCd=IdxWithTrValOptRelCd, dctDsc=null, dctGrp=1, dctSeq=1, dctTpNm=ָ���뷧ֵ�����ϵ����, dctVal=01, dctValNm=����, stCd=1, sysId=riskwarn), BaseDDCT(id=1830142, dctKey=Passport, dctTpCd=HolderIdType, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=����, dctVal=1, dctValNm=����, stCd=1, sysId=InternetCredit), BaseDDCT(id=1830290, dctKey=IntClTmpntCd_1, dctTpCd=IntClTmpntCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=��Ϣ��ȡʱ�����, dctVal=1, dctValNm=��ǰ, stCd=1, sysId=project), BaseDDCT(id=1829911, dctKey=FnsStCd_0, dctTpCd=FnsStCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=����״̬, dctVal=0, dctValNm=δ��Ч, stCd=1, sysId=unknow), BaseDDCT(id=1829121, dctKey=CrdtPrsvCd_1, dctTpCd=CrdtPrsvCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=֤���������, dctVal=1, dctValNm=��, stCd=1, sysId=project), BaseDDCT(id=1829915, dctKey=FormAppSceneCd_PRJ01, dctTpCd=FormScene, dctDsc=��Ŀ, dctGrp=null, dctSeq=1, dctTpNm=��Ӧ�ó�������, dctVal=PRJ01, dctValNm=null, stCd=1, sysId=product), BaseDDCT(id=1830580, dctKey=gd, dctTpCd=LoanProductType, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�̶��ʽ����, dctVal=1, dctValNm=�̶��ʽ����, stCd=1, sysId=InternetCredit), BaseDDCT(id=1831009, dctKey=MenuType_0, dctTpCd=MenuType, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�˵�����, dctVal=view, dctValNm=ҳ��, stCd=1, sysId=system), BaseDDCT(id=1829116, dctKey=Cr_Wrnt_Mod_01, dctTpCd=Cr_Wrnt_Mod, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=���õ�����ʽ, dctVal=1, dctValNm=��֤, stCd=1, sysId=businessrating), BaseDDCT(id=1829196, dctKey=CrgToAsTpCd_1, dctTpCd=CrgToAsTpCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=���Ŷ������ʹ���, dctVal=1, dctValNm=��, stCd=1, sysId=project), BaseDDCT(id=1829872, dctKey=FncRptTpCd_1, dctTpCd=FncRptTpCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=���񱨱��������ʹ���, dctVal=1, dctValNm=�±�, stCd=1, sysId=custmanag), BaseDDCT(id=1829870, dctKey=FncRptClbrCd_1, dctTpCd=FncRptClbrCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=���񱨱�ھ�����, dctVal=1, dctValNm=��һ, stCd=1, sysId=custmanag), BaseDDCT(id=1829416, dctKey=Ddln_CtCd_036, dctTpCd=Ddln_CtCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�����������, dctVal=036, dctValNm=һ�����꣨����, stCd=1, sysId=unknow), BaseDDCT(id=1829906, dctKey=FndsRsPln_Tp_1, dctTpCd=FndsRsPln_Tp, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�ʽ��뷽������, dctVal=1, dctValNm=���н��, stCd=1, sysId=custmanag), BaseDDCT(id=1830550, dctKey=LndTpcd_1, dctTpCd=LndTpcd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=������ʹ���, dctVal=1, dctValNm=����, stCd=1, sysId=project), BaseDDCT(id=1828799, dctKey=Conditions_1, dctTpCd=Conditions, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�������������, dctVal=1, dctValNm=���������������ţ������ܻ��أ���׼�Ǽ�, stCd=1, sysId=custmanag), BaseDDCT(id=1829415, dctKey=Ddln_CtCd_012, dctTpCd=Ddln_CtCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�����������, dctVal=012, dctValNm=������ֻһ�꣨����, stCd=1, sysId=unknow), BaseDDCT(id=1829869, dctKey=FncModeCd_1, dctTpCd=FncModeCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=���ʷ�ʽ, dctVal=1, dctValNm=��, stCd=1, sysId=unknow), BaseDDCT(id=1829417, dctKey=Ddln_CtCd_060, dctTpCd=Ddln_CtCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�����������, dctVal=060, dctValNm=�������꣨����, stCd=1, sysId=unknow), BaseDDCT(id=1829418, dctKey=Ddln_CtCd_061, dctTpCd=Ddln_CtCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�����������, dctVal=061, dctValNm=��������, stCd=1, sysId=unknow), BaseDDCT(id=1829503, dctKey=DsbrCD_1, dctTpCd=DsbrCD, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�ſ�����, dctVal=1, dctValNm=�������ʸ���, stCd=1, sysId=product), BaseDDCT(id=1829864, dctKey=FncImtCd_0, dctTpCd=FncImtCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=���ʹ��ߴ���, dctVal=0, dctValNm=�ֽ�, stCd=1, sysId=unknow), BaseDDCT(id=1829867, dctKey=FncModCd_1, dctTpCd=FncModCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=���ʷ�ʽ����, dctVal=1, dctValNm=��ģʽ, stCd=1, sysId=unknow), BaseDDCT(id=1829909, dctKey=FnrptSetTblCl_01, dctTpCd=FnrptSetTblCl, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=���񱨱��ױ����, dctVal=01, dctValNm=��ҵ��, stCd=1, sysId=custmanag), BaseDDCT(id=1829855, dctKey=LimitMoney, dctTpCd=FlowType, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�޶����, dctVal=1, dctValNm=�޶����, stCd=1, sysId=InternetCredit), BaseDDCT(id=1827833, dctKey=RepaymentAccount, dctTpCd=AcctFunctionType, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�����˻�, dctVal=1, dctValNm=�����˻�, stCd=1, sysId=InternetCredit), BaseDDCT(id=1829506, dctKey=DsbrCD_12, dctTpCd=DsbrCD, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�ſ�����, dctVal=12, dctValNm=����Ԥ��Ѻ��������, stCd=1, sysId=product), BaseDDCT(id=1829522, dctKey=DsbrCD_27, dctTpCd=DsbrCD, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�ſ�����, dctVal=27, dctValNm=�׸������������, stCd=1, sysId=product), BaseDDCT(id=1829862, dctKey=FncCgyCd_1, dctTpCd=FncCgyCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�������, dctVal=1, dctValNm=����������, stCd=1, sysId=unknow), BaseDDCT(id=1830221, dctKey=IdxTpCd_01, dctTpCd=IdxTpCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=ָ�����ʹ���, dctVal=01, dctValNm=�Թ�, stCd=1, sysId=riskwarn), BaseDDCT(id=1830269, dctKey=IndustryCreditPolicy_1, dctTpCd=IndustryCreditPolicy, dctDsc=null, dctGrp=1, dctSeq=1, dctTpNm=��ҵ�Ŵ�����, dctVal=1, dctValNm=����֧��, stCd=1, sysId=common), BaseDDCT(id=1829944, dctKey=FtaSign_01, dctTpCd=FtaSign, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=��ó���ͻ���־, dctVal=1, dctValNm=���߱���ó��ҵ������, stCd=1, sysId=custmanag), BaseDDCT(id=1830063, dctKey=CalInt, dctTpCd=GranceIntRule, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=��Ϣ, dctVal=1, dctValNm=��Ϣ, stCd=1, sysId=InternetCredit), BaseDDCT(id=1830067, dctKey=GrntFormCd_1, dctTpCd=GrntFormCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=��֤��ʽ����, dctVal=1, dctValNm=һ�㱣֤, stCd=1, sysId=project), BaseDDCT(id=1829517, dctKey=DsbrCD_22, dctTpCd=DsbrCD, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�ſ�����, dctVal=22, dctValNm=����������裩, stCd=1, sysId=product), BaseDDCT(id=1830185, dctKey=IdAprvTblTpCd_01, dctTpCd=IdAprvTblTpCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�����������, dctVal=1, dctValNm=ֱ�ӷ���, stCd=1, sysId=postloanmgt), BaseDDCT(id=1829509, dctKey=DsbrCD_15, dctTpCd=DsbrCD, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�ſ�����, dctVal=15, dctValNm=���������������裩, stCd=1, sysId=product), BaseDDCT(id=1830216, dctKey=IdxOptTpCd_01, dctTpCd=IdxOptTpCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=ָ���������ʹ���, dctVal=01, dctValNm=��һ��ֵ, stCd=1, sysId=riskwarn), BaseDDCT(id=1830265, dctKey=IncmExpnSttnClCd_1, dctTpCd=IncmExpnSttnClCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=����֧������������, dctVal=1, dctValNm=��ͳ���ô�����֧�����, stCd=1, sysId=project), BaseDDCT(id=1830295, dctKey=IntPayMethCd_1, dctTpCd=IntPayMethCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=��Ϣ������, dctVal=1, dctValNm=��, stCd=1, sysId=project), BaseDDCT(id=1830340, dctKey=FR, dctTpCd=IsCheck, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=��ѡ, dctVal=1, dctValNm=��ѡ, stCd=1, sysId=InternetCredit), BaseDDCT(id=1829205, dctKey=CsRt_Modl_TpCd_1, dctTpCd=CsRt_Modl_TpCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=����ģ�����ʹ���, dctVal=1, dctValNm=��Ŀ������������, stCd=1, sysId=custmanag), BaseDDCT(id=1830582, dctKey=LoanPsnofsameoccuIntrbnkCd_1, dctTpCd=LoanPsnofsameoccuIntrbnkCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=����ͬ�п��д���, dctVal=1, dctValNm=ͬ��, stCd=1, sysId=project), BaseDDCT(id=1829854, dctKey=two, dctTpCd=FlowSignStepFlag, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�ڶ��λ�ǩ, dctVal=2, dctValNm=�ڶ��λ�ǩ, stCd=1, sysId=InternetCredit), BaseDDCT(id=1828177, dctKey=BaseAcptMtrl_1, dctTpCd=BaseAcptMtrl, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�����������, dctVal=1, dctValNm=Ӫҵִ�ո���, stCd=1, sysId=product), BaseDDCT(id=1829525, dctKey=DsbrCD_3, dctTpCd=DsbrCD, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�ſ�����, dctVal=3, dctValNm=������;��ʵ�����裩, stCd=1, sysId=product), BaseDDCT(id=1827829, dctKey=AcctCstSrcCd_1, dctTpCd=AcctCstSrcCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=����ͻ���Դ����, dctVal=1, dctValNm=����, stCd=1, sysId=account), BaseDDCT(id=1829859, dctKey=FltTpcd_0, dctTpCd=FltTpcd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�������ʹ���, dctVal=0, dctValNm=�ϸ�, stCd=1, sysId=account), BaseDDCT(id=1828174, dctKey=BargaDsbrCfrmmod_1, dctTpCd=BargaDsbrCfrmmod, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�����˷ſ�ȷ�Ϸ�ʽ, dctVal=1, dctValNm=����������, stCd=1, sysId=project), BaseDDCT(id=1829512, dctKey=DsbrCD_18, dctTpCd=DsbrCD, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�ſ�����, dctVal=18, dctValNm=�����ռ������һ������, stCd=1, sysId=product), BaseDDCT(id=1829846, dctKey=FlTpCd_1, dctTpCd=FlTpCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�ļ����ʹ���, dctVal=DtySurvyRpt, dctValNm=��ְ���鱨��, stCd=1, sysId=project), BaseDDCT(id=1829413, dctKey=Ddln_CtCd_003, dctTpCd=Ddln_CtCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�����������, dctVal=003, dctValNm=����������, stCd=1, sysId=unknow), BaseDDCT(id=1827940, dctKey=AddressType_2, dctTpCd=AddressType, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=��ַ����, dctVal=1, dctValNm=ע��, stCd=1, sysId=custmanag), BaseDDCT(id=1829409, dctKey=DdlnUncd_1, dctTpCd=DdlnUncd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=���޵�λ, dctVal=1, dctValNm=��, stCd=1, sysId=system), BaseDDCT(id=1829849, dctKey=onlyOneRefused, dctTpCd=FlowSignRule, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=һƱ�����, dctVal=2, dctValNm=һƱ�����, stCd=1, sysId=InternetCredit), BaseDDCT(id=1829836, dctKey=Approvaling, dctTpCd=FinancialSubjectStatus, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=������, dctVal=1, dctValNm=������, stCd=1, sysId=InternetCredit), BaseDDCT(id=1828172, dctKey=BaplModeCd_1, dctTpCd=BaplModeCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=ҵ������ģʽ, dctVal=1, dctValNm=�����ҵ������, stCd=1, sysId=project), BaseDDCT(id=1829840, dctKey=FivePrinciplesApprovalCode_01, dctTpCd=FivePrinciplesApprovalCode, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�������ԭ���׼, dctVal=1, dctValNm=�Ѿ����к�׼, stCd=1, sysId=custmanag), BaseDDCT(id=1828170, dctKey=BanksyndOrgFormCd_1, dctTpCd=BanksyndOrgFormCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=������֯��ʽ����, dctVal=1, dctValNm=�ڲ�����, stCd=1, sysId=project), BaseDDCT(id=1829414, dctKey=Ddln_CtCd_006, dctTpCd=Ddln_CtCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�����������, dctVal=006, dctValNm=���������£�����, stCd=1, sysId=unknow), BaseDDCT(id=1829229, dctKey=CstRelRelCd_5, dctTpCd=CstRelRelCd, dctDsc=null, dctGrp=0, dctSeq=1, dctTpNm=�ͻ�������ϵ����, dctVal=5, dctValNm=����, stCd=1, sysId=project), BaseDDCT(id=1829225, dctKey=CstRelRelCd_2, dctTpCd=CstRelRelCd, dctDsc=null, dctGrp=0, dctSeq=1, dctTpNm=�ͻ�������ϵ����, dctVal=2, dctValNm=��ż, stCd=1, sysId=project), BaseDDCT(id=1827836, dctKey=SavingAcc, dctTpCd=AcctType, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=���, dctVal=1, dctValNm=���, stCd=1, sysId=InternetCredit), BaseDDCT(id=1829844, dctKey=Fixed_1, dctTpCd=Fixed, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�̶���Ӫ��������, dctVal=1, dctValNm=���޻�����, stCd=1, sysId=custmanag), BaseDDCT(id=1828749, dctKey=FAILURE, dctTpCd=Code, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=ʧ��, dctVal=fail, dctValNm=ʧ��, stCd=1, sysId=InternetCredit), BaseDDCT(id=1828733, dctKey=CndParmReTpCd_1, dctTpCd=CndParmReTpCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=����������ϵ���ʹ���, dctVal=1, dctValNm=˳���ϵ, stCd=1, sysId=product), BaseDDCT(id=1828729, dctKey=CnclsnCd_1, dctTpCd=CnclsnCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=���񱨱�����Ϣ��������۴���, dctVal=1, dctValNm=�ޱ���, stCd=1, sysId=custmanag), BaseDDCT(id=1828628, dctKey=ClmTpcd_01, dctTpCd=ClmTpcd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=ծȨ���ʹ���, dctVal=01, dctValNm=ת��, stCd=1, sysId=account), BaseDDCT(id=1828672, dctKey=Clt_TpCd_01, dctTpCd=Clt_TpCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=����Ѻ����, dctVal=0, dctValNm=��Ѻ, stCd=1, sysId=common), BaseDDCT(id=1828608, dctKey=ChkTpCd_01, dctTpCd=ChkTpCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=������ʹ���, dctVal=01, dctValNm=��һ��Ŀ, stCd=1, sysId=postloanmgt), BaseDDCT(id=1827841, dctKey=AcgitmAccnoTpcd_01, dctTpCd=AcgitmAccnoTpcd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=��ƿ�Ŀ�˺����ʹ���, dctVal=01, dctValNm=���������˻�_01, stCd=1, sysId=account), BaseDDCT(id=1828610, dctKey=ChnlTpCd_1, dctTpCd=ChnlTpCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=Э����ʽ, dctVal=1, dctValNm=��˾�Ƽ�, stCd=1, sysId=project), BaseDDCT(id=1828633, dctKey=ClsMpbCd_1, dctTpCd=ClsMpbCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�ر��ֻ����д���, dctVal=1, dctValNm=��, stCd=1, sysId=project), BaseDDCT(id=1830156, dctKey=HsTpcd_10, dctTpCd=HsTpcd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�������ʹ���, dctVal=10, dctValNm=סլ, stCd=1, sysId=project), BaseDDCT(id=1829820, dctKey=SpouseIDType, dctTpCd=FileType, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=��ż���֤, dctVal=1, dctValNm=��ż���֤, stCd=1, sysId=InternetCredit), BaseDDCT(id=1828168, dctKey=BankDstrOfWrkCd_1, dctTpCd=BankDstrOfWrkCd, dctDsc=����, dctGrp=null, dctSeq=1, dctTpNm=���зֹ�����, dctVal=1, dctValNm=ǣͷ��, stCd=1, sysId=project), BaseDDCT(id=1827952, dctKey=byHand, dctTpCd=AdjustAccountRule, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�˹�����, dctVal=1, dctValNm=�˹�����, stCd=1, sysId=InternetCredit), BaseDDCT(id=1830218, dctKey=IdxRskGrdCd_01, dctTpCd=IdxRskGrdCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=ָ����յȼ�����, dctVal=01, dctValNm=1��, stCd=1, sysId=riskwarn), BaseDDCT(id=1829829, dctKey=LoanNormalRepayment, dctTpCd=FinancialBusinessType, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=������������, dctVal=1, dctValNm=������������, stCd=1, sysId=InternetCredit), BaseDDCT(id=1828797, dctKey=Recycle, dctTpCd=ComputeType, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=����ʱ����Ӷ��, dctVal=R, dctValNm=����ʱ����Ӷ��, stCd=1, sysId=InternetCredit), BaseDDCT(id=1829214, dctKey=CstHdovStCd_1, dctTpCd=CstHdovStCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�ͻ��ƽ�״̬����, dctVal=1, dctValNm=δ����, stCd=1, sysId=custmanag), BaseDDCT(id=1828221, dctKey=BlFctrn_1, dctTpCd=BlFctrn, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�������, dctVal=1, dctValNm=������, stCd=1, sysId=unknow), BaseDDCT(id=1827955, dctKey=PREPAYMENT, dctTpCd=AdjustTransaction, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=��ǰ����, dctVal=1, dctValNm=��ǰ����, stCd=1, sysId=InternetCredit), BaseDDCT(id=1828235, dctKey=BnkAccJrnlClCd_1, dctTpCd=BnkAccJrnlClCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�����˻���ˮ�������, dctVal=1, dctValNm=��ͳ���ô������˻���ˮ, stCd=1, sysId=project), BaseDDCT(id=015f4f99-5303-11ea-8612-000c2912c6c8, dctKey=WrntStcd_0, dctTpCd=WrntStcd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=����״̬����, dctVal=1, dctValNm=����, stCd=1, sysId=account), BaseDDCT(id=1828237, dctKey=BnkDsbrMtdcd_1, dctTpCd=BnkDsbrMtdcd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=���зſʽ����, dctVal=1, dctValNm=��˾�˻�, stCd=1, sysId=project), BaseDDCT(id=1829215, dctKey=CstMainType_1, dctTpCd=CstMainType, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�ͻ��������, dctVal=0, dctValNm=��ͨũ��, stCd=1, sysId=custmanag), BaseDDCT(id=1829533, dctKey=DsbrCD_37, dctTpCd=DsbrCD, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�ſ�����, dctVal=37, dctValNm=ҵ���ͬ�����������ı�ǩ��, stCd=1, sysId=product), BaseDDCT(id=1829527, dctKey=DsbrCD_31, dctTpCd=DsbrCD, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�ſ�����, dctVal=31, dctValNm=�ṩ�����׸���֧��ƾ֤, stCd=1, sysId=product), BaseDDCT(id=1828164, dctKey=BaldrcCd_0, dctTpCd=BaldrcCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�������, dctVal=0, dctValNm=��, stCd=1, sysId=account), BaseDDCT(id=1829529, dctKey=DsbrCD_33, dctTpCd=DsbrCD, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�ſ�����, dctVal=33, dctValNm=ί�й�֤��������, stCd=1, sysId=product), BaseDDCT(id=1828163, dctKey=INTEREST, dctTpCd=BalanceCompType, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=��Ϣ, dctVal=INTEREST, dctValNm=��Ϣ, stCd=1, sysId=InternetCredit), BaseDDCT(id=1828256, dctKey=BsnClcd_1, dctTpCd=BsnClcd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=ҵ��������, dctVal=1, dctValNm=��Ŀ�׶�, stCd=1, sysId=project), BaseDDCT(id=1827960, dctKey=ModeTwo, dctTpCd=AdjustWay, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=��һ��һ����, dctVal=1, dctValNm=��һ��һ����, stCd=1, sysId=InternetCredit), BaseDDCT(id=1827826, dctKey=ANA, dctTpCd=AccountingType, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=Ӧ��/��Ӧ��, dctVal=1, dctValNm=Ӧ��/��Ӧ��, stCd=1, sysId=InternetCredit), BaseDDCT(id=1829228, dctKey=CstRelRelCd_4, dctTpCd=CstRelRelCd, dctDsc=null, dctGrp=0, dctSeq=1, dctTpNm=�ͻ�������ϵ����, dctVal=4, dctValNm=�ֵܽ���, stCd=1, sysId=project), BaseDDCT(id=1830403, dctKey=LGDSrcCd_01, dctTpCd=LGDSrcCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=LGD��Դ����, dctVal=01, dctValNm=IRBϵͳծ������ģ��, stCd=1, sysId=businessrating), BaseDDCT(id=1828261, dctKey=BsnCtlgCd_1, dctTpCd=BsnCtlgCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=ҵ���������, dctVal=1, dctValNm=�Թ�, stCd=1, sysId=project), BaseDDCT(id=1830604, dctKey=LoanTpcd_1, dctTpCd=LoanTpcd, dctDsc=��Ŀ���ͬʹ����ͬ����Сд���֣�Ŀǰδ�ã���ʹ��ʱ�ٷ���, dctGrp=null, dctSeq=1, dctTpNm=�������ʹ���, dctVal=1, dctValNm=��ҵ���Ҵ���, stCd=1, sysId=project), BaseDDCT(id=1828273, dctKey=BsnHpnScnCd_PRJ101, dctTpCd=BsnHpnScnCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=ҵ������������, dctVal=PRJ101, dctValNm=��Ŀ����, stCd=1, sysId=product), BaseDDCT(id=1829437, dctKey=period, dctTpCd=DerateCalIntRule, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=���ڼ�Ϣ, dctVal=1, dctValNm=���ڼ�Ϣ, stCd=1, sysId=InternetCredit), BaseDDCT(id=1828619, dctKey=All, dctTpCd=CleanCutCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=һ������ǰ����, dctVal=1, dctValNm=һ������ǰ����, stCd=1, sysId=InternetCredit), BaseDDCT(id=1831023, dctKey=MnpltTpCd_1, dctTpCd=MnpltTpCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=��������, dctVal=1, dctValNm=����, stCd=1, sysId=workflow), BaseDDCT(id=1828807, dctKey=ConsCntlSttn_1, dctTpCd=ConsCntlSttn, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=���ڿ������, dctVal=1, dctValNm=��ǰ��ﵽ��ƹ���, stCd=1, sysId=custmanag), BaseDDCT(id=1831049, dctKey=Modl_TpCd_1, dctTpCd=Modl_TpCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=ģ�����ʹ���, dctVal=1, dctValNm=�̶��ʲ�������Ŀ����, stCd=1, sysId=businessrating), BaseDDCT(id=1829161, dctKey=credit_require, dctTpCd=CreditRefuseReason, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�ⲿ���Ų���, dctVal=N002, dctValNm=�ⲿ���Ų���, stCd=1, sysId=InternetCredit), BaseDDCT(id=1829791, dctKey=FctrnmodCd_1, dctTpCd=FctrnmodCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=��/˫����, dctVal=1, dctValNm=˫����, stCd=1, sysId=unknow), BaseDDCT(id=1828159, dctKey=CREDIT, dctTpCd=BalanceCompLoan, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=����, dctVal=2, dctValNm=����, stCd=1, sysId=InternetCredit), BaseDDCT(id=1828158, dctKey=otherBack, dctTpCd=BackListType, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�����ź�����, dctVal=1, dctValNm=�����ź�����, stCd=1, sysId=InternetCredit), BaseDDCT(id=1828289, dctKey=BsnTpCd_1, dctTpCd=BsnTpCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=ҵ�����ʹ���, dctVal=1, dctValNm=��Ŀ������ҵ��, stCd=1, sysId=project), BaseDDCT(id=1827825, dctKey=INACTIVE, dctTpCd=AccountTypeState, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=���, dctVal=1, dctValNm=���, stCd=1, sysId=InternetCredit), BaseDDCT(id=1829805, dctKey=handlingCharge, dctTpCd=FeeType, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=������, dctVal=1, dctValNm=������, stCd=1, sysId=InternetCredit), BaseDDCT(id=1828600, dctKey=Periodization, dctTpCd=ChargeWay, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�ֶ���ȡ, dctVal=1, dctValNm=�ֶ���ȡ, stCd=1, sysId=InternetCredit), BaseDDCT(id=1828624, dctKey=ClientCreditPolicy_1, dctTpCd=ClientCreditPolicy, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�ͻ��Ŵ�����, dctVal=1, dctValNm=����֧��, stCd=1, sysId=custmanag), BaseDDCT(id=1829362, dctKey=CustomerType_1, dctTpCd=CustomerType, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�ͻ�����, dctVal=04, dctValNm=��ҵ��, stCd=1, sysId=custmanag), BaseDDCT(id=1830209, dctKey=IdxCgyCd_01, dctTpCd=IdxCgyCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=ָ��������, dctVal=01, dctValNm=�������Ԥ��, stCd=1, sysId=riskwarn), BaseDDCT(id=1830344, dctKey=IvsCntlSttn_1, dctTpCd=IvsCntlSttn, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=Ͷ�ʿ������, dctVal=1, dctValNm=Ͷ�ʳ�֧10%(��)����, stCd=1, sysId=custmanag), BaseDDCT(id=1828301, dctKey=BtchPcsBsnScnCd_01, dctTpCd=BtchPcsBsnScnCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=������ҵ�񳡾�����, dctVal=01, dctValNm=��Ŀ�����Զ�����, stCd=1, sysId=projectclosing), BaseDDCT(id=1829783, dctKey=FctrnIntClMtdCd_1, dctTpCd=FctrnIntClMtdCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=������Ϣ��ȡ��ʽ����, dctVal=1, dctValNm=ͷϢ��ȡ, stCd=1, sysId=project), BaseDDCT(id=1828303, dctKey=BtchpcsEctRsltCd_01, dctTpCd=BtchpcsEctRsltCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=������ִ�н������, dctVal=01, dctValNm=�ɹ�, stCd=1, sysId=projectclosing), BaseDDCT(id=1829466, dctKey=reason, dctTpCd=DiscountClearingCycle, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=ÿ����, dctVal=1, dctValNm=ÿ����, stCd=1, sysId=InternetCredit), BaseDDCT(id=1829788, dctKey=FctrnRcrsMtdCd_1, dctTpCd=FctrnRcrsMtdCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=����׷����ʽ����, dctVal=1, dctValNm=��׷, stCd=1, sysId=project), BaseDDCT(id=1829778, dctKey=FcsSt_1, dctTpCd=FcsStCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�ͻ���ע״̬, dctVal=1, dctValNm=�ѹ�ע, stCd=1, sysId=custmanag), BaseDDCT(id=1829181, dctKey=isCust, dctTpCd=CreditRule, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�Ƿ�ͻ�����, dctVal=02, dctValNm=�Ƿ�ͻ�����, stCd=1, sysId=InternetCredit), BaseDDCT(id=1828598, dctKey=WebServiceChannel, dctTpCd=ChannelType, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�������, dctVal=2, dctValNm=�������, stCd=1, sysId=InternetCredit), BaseDDCT(id=1829781, dctKey=FctrnBsnTpCd_1, dctTpCd=FctrnBsnTpCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=����ҵ�����ʹ���, dctVal=1, dctValNm=������, stCd=1, sysId=project), BaseDDCT(id=1829395, dctKey=Date, dctTpCd=DataType, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=(Date)����, dctVal=Date, dctValNm=(Date)����, stCd=1, sysId=InternetCredit), BaseDDCT(id=1829500, dctKey=DsbrAfMnpltCd_1, dctTpCd=DsbrAfMnpltCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�ſ���������, dctVal=1, dctValNm=������ȡ�������֤ԭ��, stCd=1, sysId=project), BaseDDCT(id=1829468, dctKey=PartDiscount, dctTpCd=DiscountType, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=������Ϣ, dctVal=1, dctValNm=������Ϣ, stCd=1, sysId=InternetCredit), BaseDDCT(id=1829357, dctKey=CustomerScale_1, dctTpCd=CustomerScale, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�ͻ���ģ, dctVal=1, dctValNm=����, stCd=1, sysId=custmanag), BaseDDCT(id=1829513, dctKey=DsbrCD_19, dctTpCd=DsbrCD, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�ſ�����, dctVal=19, dctValNm=��������, stCd=1, sysId=product), BaseDDCT(id=1830282, dctKey=InfSrc_1, dctTpCd=InfSrc, dctDsc=null, dctGrp=1, dctSeq=1, dctTpNm=��Ϣ��Դ, dctVal=1, dctValNm=С΢ϵͳ, stCd=1, sysId=common), BaseDDCT(id=1830565, dctKey=EqualsLendingDay, dctTpCd=LoanDateStyle, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=ͬ�ſ���, dctVal=1, dctValNm=ͬ�ſ���, stCd=1, sysId=InternetCredit), BaseDDCT(id=1828811, dctKey=ConsortRelCd_1, dctTpCd=ConsortRelCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=���޹�ϵ����, dctVal=1, dctValNm=��, stCd=1, sysId=project), BaseDDCT(id=1827916, dctKey=businessId, dctTpCd=ActivitiVariables, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=ҵ��ID��������, dctVal=businessId, dctValNm=ҵ��ID��������, stCd=1, sysId=InternetCredit), BaseDDCT(id=1829353, dctKey=CustomerRiskTypeCd_01, dctTpCd=CustomerRiskTypeCd, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�ͻ���������, dctVal=1, dctValNm=һ�㹫˾��, stCd=1, sysId=custmanag), BaseDDCT(id=1828603, dctKey=Verification, dctTpCd=CheckStatus, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=���˲�, dctVal=1, dctValNm=���˲�, stCd=1, sysId=InternetCredit), BaseDDCT(id=1827821, dctKey=AccountStatus_101, dctTpCd=AccountStatus, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�˻�״̬, dctVal=101, dctValNm=����, stCd=1, sysId=custmanag), BaseDDCT(id=1829478, dctKey=DocModlTp_5, dctTpCd=DocModlTp, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�ĵ�ģ������, dctVal=5, dctValNm=��Ѻ��--ó����, stCd=1, sysId=product), BaseDDCT(id=1828769, dctKey=TemporarilyUnableRrepay, dctTpCd=CollectionResult, dctDsc=null, dctGrp=null, dctSeq=1, dctTpNm=�ݲ��ܻ���, dctVal=1, dctValNm=�ݲ��ܻ���, stCd=1, sysId=InternetCredit)] 17

Reason analyze (If you can)

kimmking commented 4 years ago

how to reproduce your case?

psh882003 commented 4 years ago

ShardingSphere-Proxy

psh882003 commented 4 years ago
cherrylzhao commented 4 years ago

could not reproduced in my local environment

sharding_db=> \encoding
UTF8
sharding_db=> insert into t_order(user_id,status) values(100,'初始化');
INSERT 0 1
sharding_db=> select * from t_order;
      order_id      | status | user_id
--------------------+--------+---------
 475008260601020417 | 初始化 |     100
(1 rows)

configuration is official default like this

schemaName: sharding_db

dataSources:
  ds_0:
    url: jdbc:postgresql://127.0.0.1:5432/demo_ds_0?serverTimezone=UTC&useSSL=false
    username: postgres
    password: postgres
    connectionTimeoutMilliseconds: 30000
    idleTimeoutMilliseconds: 60000
    maxLifetimeMilliseconds: 1800000
    maxPoolSize: 50
  ds_1:
    url: jdbc:postgresql://127.0.0.1:5432/demo_ds_1?serverTimezone=UTC&useSSL=false
    username: postgres
    password: postgres
    connectionTimeoutMilliseconds: 30000
    idleTimeoutMilliseconds: 60000
    maxLifetimeMilliseconds: 1800000
    maxPoolSize: 50

shardingRule:
  tables:
    t_order:
      actualDataNodes: ds_${0..1}.t_order_${0..1}
      tableStrategy:
        inline:
          shardingColumn: order_id
          algorithmExpression: t_order_${order_id % 2}
      keyGenerator:
        type: SNOWFLAKE
        column: order_id
    t_order_item:
      actualDataNodes: ds_${0..1}.t_order_item_${0..1}
      tableStrategy:
        inline:
          shardingColumn: order_id
          algorithmExpression: t_order_item_${order_id % 2}
      keyGenerator:
        type: SNOWFLAKE
        column: order_item_id
  bindingTables:
    - t_order,t_order_item
  defaultDatabaseStrategy:
    inline:
      shardingColumn: user_id
      algorithmExpression: ds_${user_id % 2}
  defaultTableStrategy:
    none:
terrymanu commented 4 years ago

Closed because of no response anymore