Cause: java.sql.SQLException: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’

2020-09-13 | By Jinyang | No Comments | Filed in: 技术相关.

生产服务器的MySql默认是utf8_general_ci字符集,但是有部分表格的字段是utf8_unicode_ci字符集。 按此前的处理方法,转换下其中一个的字符集即可,参考语句: ALTER TABLE tablenameCHANGE COLUMN colname colnameVARCHAR(45) CHARACTER SET ‘utf8’ COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT ‘备注 但是这次的2个表 都已经有其他业务逻辑在使用,贸然调整的话 会引发其他业务的异常,于是用上了sql语句中的字符集转换方法 这样对原始存储不做改变 不影响既有业务: select * from table1 where table1....
【阅读全文】

Tags:

cloudflare的免费通用 SSL

2020-09-13 | By Jinyang | No Comments | Filed in: 技术相关.

本站之前用Let’s Encrypt的证书 但是证书要更新、证书在中国大陆存在访问干扰等原因导致想要更换到cloudflare的免费通用 SSL 。 忘记什么时候点击了 【禁用通用 SSL】 ,导致在边缘证书中一直没办法看到证书 ,困惑了好久,今天再次看这个页面的时候 发现页面底部有一个【启用通用SSL】的按钮 点击后 就有了边缘证书了。 边缘证书配合Cloudflare 签名的免费 TLS 证书,再也不用操心证书的事情了,因为边缘证书是自动签发自动更新的,源证书是15年有效期。
【阅读全文】

Tags:

Iilin.com

2020-09-02 | By Jinyang | No Comments | Filed in: Uncategorized.

BidAmountDatebrcalphakHigh Bid$1,251Sep 1, 2020 at 10:15 AMonemoreseeP$1,203Sep 1, 2020 at 10:15 AMonemoreseeP$1,201Sep 1, 2020 at 10:15 AMbrcalphak$1,151Sep 1, 2020 at 10:15 AMonemoresee$1,101Sep 1, 2020 at 7:35 AMbrcalphak$1,051Sep 1, 2020 at 7:10 AMonemoreseeP$1,001Sep 1, 2020 at 7:10 AMbrcalphak$1,000Sep 1, 2020 at 7:10 AMonemoreseeP$950Sep 1, 2020 at 7:09 AMbrcalphak$900Sep 1, 2020 at 7:09....
【阅读全文】

Shouke.com

2020-08-20 | By Jinyang | No Comments | Filed in: Uncategorized.

DatereasonreasonHigh Bid$6,816Aug 19, 2020 at 1:27 PMAlibackorders$6,766Aug 19, 2020 at 1:24 PMDefendOr6$6,716Aug 19, 2020 at 1:24 PMreasonreasonP$6,666Aug 19, 2020 at 1:23 PMDefendOr6$6,655Aug 19, 2020 at 1:23 PMreasonreasonP$6,605Aug 19, 2020 at 1:23 PMDefendOr6$6,555Aug 19, 2020 at 1:23 PMreasonreasonP$6,505Aug 19, 2020 at 1:23 PMDefendOr6$6,455Aug 19, 2020 at 1:23 PMreasonreasonP$6,405Aug 19, 2020&nb....
【阅读全文】

Rinei.com

2020-08-14 | By Jinyang | No Comments | Filed in: Uncategorized.

BidAmountDatelawyer0247High BidP$334Aug 13, 2020 at 12:18 PMjiuzhe$328Aug 13, 2020 at 12:18 PMlawyer0247$308Aug 13, 2020 at 12:13 PMAlibackordersP$288Aug 13, 2020 at 12:13 PMAlibackordersP$234Aug 13, 2020 at 12:13 PMlawyer0247$214Aug 13, 2020 at 12:13 PMAlibackorders$104Aug 13, 2020 at 8:34 AMFinderP$101Aug 13, 2020 at 8:34 AMFinderP$99Aug 13, 2020 at 8:33 AMAlibackorders$94Aug 13, 2020 at 8:33....
【阅读全文】

Kuidou.com

2020-08-02 | By Jinyang | No Comments | Filed in: Uncategorized.

Datebanban67High Bid$851Aug 1, 2020 at 1:14 PMjiuzhe$801Aug 1, 2020 at 1:14 PMbanban67$751Aug 1, 2020 at 1:13 PMjiuzhe$701Aug 1, 2020 at 1:12 PMbanban67$651Aug 1, 2020 at 1:11 PMjiuzheP$601Aug 1, 2020 at 1:11 PMbanban67$601Aug 1, 2020 at 1:11 PMjiuzhe$551Aug 1, 2020 at 1:09 PMbanban67$501Aug 1, 2020 at 1:08 PMjiuzheP$500Aug 1, 2020 at 1:08 PMjiuzhe$440Aug 1, 2020 at 1:08 PMbanban67$42....
【阅读全文】

SouDian.com

2020-07-22 | By Jinyang | No Comments | Filed in: Uncategorized.

DatereasonreasonHigh BidP$5,865Jul 21, 2020 at 1:01 PMAlibackorders$5,815Jul 21, 2020 at 1:01 PMreasonreason$5,765Jul 21, 2020 at 1:00 PMDefendOr6P$5,715Jul 21, 2020 at 1:00 PMDefendOr6P$5,705Jul 21, 2020 at 12:59 PMreasonreason$5,655Jul 21, 2020 at 12:59 PMDefendOr6$5,605Jul 21, 2020 at 12:58 PMreasonreasonP$5,555Jul 21, 2020 at 12:58 PMreasonreasonP$5,479Jul 21, 2020 at 12:58 PMDefendOr6$5,429Jul 21, 2....
【阅读全文】

Bid history for xuewei.com

2020-07-22 | By Jinyang | No Comments | Filed in: Uncategorized.

Starting Bid:$79.0021-Jul-2020 16:52 PDT Bidder Date Bid Amount Comment nj–nowbbb 21-Jul-2020 12:46 PDT $12,501.00 Bid Placed guoyu.com 21-Jul-2020 12:41 PDT $12,001.00 Bid Placed nj–nowbbb 21-Jul-2020 12:41 PDT $12,000.00 Bid Placed nj–nowbbb 21-Jul-2020 12:40 PDT $11,501.00 Bid Placed guoyu.com 21-Jul-2020 12:40 PDT $11,001.00 Bid Placed nj–nowbbb 21-Jul-2020 12:36 PDT $10,501.00 Bid Placed guoyu.com 21-Jul-2020 12:36 PDT $10,001.00 Bid Placed n....
【阅读全文】

Qnic.com

2020-07-06 | By Jinyang | No Comments | Filed in: Uncategorized.

BidAmountDateAlibackordersHigh BidP$658Jul 5, 2020 at 12:56 PMjiuzhe$608Jul 5, 2020 at 12:56 PMAlibackordersP$558Jul 5, 2020 at 12:53 PMnikhiljain$508Jul 5, 2020 at 12:53 PMAlibackordersP$488Jul 5, 2020 at 12:08 PMdomainers$468Jul 5, 2020 at 12:08 PMAlibackordersP$448Jul 5, 2020 at 12:08 PMdomainers$428Jul 5, 2020 at 12:08 PMAlibackorders$408Jul 5, 2020 at 11:33 AMDolphin$388Jul 4, 2020 at 10:0....
【阅读全文】

PangZhu.com

2020-07-06 | By Jinyang | No Comments | Filed in: Uncategorized.

DateDefendOr6High BidP$1,750Jul 5, 2020 at 12:56 PMjiuzhe$1,700Jul 5, 2020 at 12:56 PMDefendOr6P$1,650Jul 5, 2020 at 11:33 AMAlibackorders$1,600Jul 5, 2020 at 11:33 AMDefendOr6P$1,250Jul 5, 2020 at 11:09 AMAlibackorders$1,200Jul 5, 2020 at 11:09 AMDefendOr6P$1,150Jul 5, 2020 at 11:08 AMAlibackorders$1,100Jul 5, 2020 at 11:08 AMDefendOr6P$1,050Jul 5, 2020 at 11:07 AMnameword$1,000Jul 5, 2020 at ....
【阅读全文】