生产服务器的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.userid = CONVERT (table2.openid USING utf8) COLLATE utf8_general_ci 最好的当然是在业务规划设计时就明确确定好使用utf8_unicode_ci。
Tags: SQL
本站之前用Let’s Encrypt的证书 但是证书要更新、证书在中国大陆存在访问干扰等原因导致想要更换到cloudflare的免费通用 SSL 。 忘记什么时候点击了 【禁用通用 SSL】 ，导致在边缘证书中一直没办法看到证书 ，困惑了好久，今天再次看这个页面的时候 发现页面底部有一个【启用通用SSL】的按钮 点击后 就有了边缘证书了。 边缘证书配合Cloudflare 签名的免费 TLS 证书，再也不用操心证书的事情了，因为边缘证书是自动签发自动更新的，源证书是15年有效期。
Tags: SSL
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 AMonemoresee$850Sep 1, 2020 at 4:21 AMMarkKaplanP$800Sep 1, 2020 at 4:21 AMMarkKaplanP$750Sep 1, 2020 at 4:20 AMonemoresee$700Sep 1, 2020 at 4:20 AMMarkKaplanP$650Sep 1, 2020 at 4:20 AMonemoresee$600Sep 1, 2020 at 4:20 AMMarkKaplanP$550Sep 1, 2020 at 4:20 AMonemoresee$500Sep 1, 2020 at 4:20 […]
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 at 1:23 PMAlibackorders$6,355Aug 19, 2020 at 1:23 PMreasonreasonP$6,305Aug 19, 2020 at 1:22 PMAlibackorders$6,255Aug 19, 2020 at 1:22 PMreasonreasonP$6,205Aug 19, 2020 at 1:22 PMDefendOr6$6,155Aug 19, 2020 at 1:22 PMreasonreasonP$6,105Aug 19, 2020 at 1:21 PMDefendOr6$6,055Aug 19, 2020 at 1:21 PMreasonreasonP$6,005Aug 19, 2020 at 1:21 […]
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 AMFinderP$89Aug 13, 2020 at 8:33 AMAlibackorders$84Aug 13, 2020 at 8:33 AMFinder$79Aug 11, 2020 at 6:45 PMbosskk$74Aug 11, 2020 at 10:52 AMyuthegreat$69Aug 11, 2020 at 10:43 AMluxtea$64Aug 10, 2020 at 1:06 PM100001$59Aug 7, 2020 at 5:01 AMAlibackorders$59Aug 7, 2020 at 8:34 […]
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$420Aug 1, 2020 at 1:05 PMjiuzheP$400Aug 1, 2020 at 1:00 PMAlibackorders$400Aug 1, 2020 at 1:00 PMjiuzhe$380Aug 1, 2020 at 12:59 PMAlibackorders$360Aug 1, 2020 at 12:58 PMjiuzhe$340Aug 1, 2020 at 12:57 PMAlibackorders$320Aug 1, 2020 at 12:57 […]
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, 2020 at 12:58 PMreasonreasonP$5,151Jul 21, 2020 at 12:57 PMAlibackorders$5,101Jul 21, 2020 at 12:57 PMreasonreasonP$5,051Jul 21, 2020 at 12:56 PMDefendOr6$5,001Jul 21, 2020 at 12:56 PMreasonreasonP$4,765Jul 21, 2020 at 12:56 PMDefendOr6$4,715Jul 21, 2020 at 12:56 PMreasonreasonP$4,622Jul 21, 2020 at 12:55 PMDefendOr6$4,572Jul 21, 2020 at 12:55 […]
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 […]
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:06 PMlawyer0247P$371Jul 4, 2020 at 10:06 PMlawyer0247$271Jul 4, 2020 at 8:30 PMdomainersP$251Jul 4, 2020 at 8:30 PMdomainers$195Jul 4, 2020 at 2:19 PMcasky77P$185Jul 4, 2020 at 2:19 PMcasky77P$171Jul 4, 2020 at 12:47 PMPhishing$161Jul 4, 2020 at 12:47 PMcasky77P$151Jul 4, 2020 at 12:46 […]
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 11:07 AMDefendOr6P$950Jul 5, 2020 at 11:07 AMwhatareyoudoing$900Jul 5, 2020 at 11:07 AMDefendOr6P$850Jul 5, 2020 at 8:17 AMnameword$800Jul 5, 2020 at 8:17 AMDefendOr6P$750Jul 5, 2020 at 8:13 AMnameword$700Jul 5, 2020 at 8:13 AMDefendOr6P$650Jul 5, 2020 at 8:09 AMnameword$600Jul 5, 2020 at 8:09 […]
