轻量级开源简单队列服务 HTTPSQS 1.3 版本发布
每天，纵贯京城
2010-7-6 18:42 | by
同事下午遇到一问题，MySQL 和 Memcached 对于同一个key，不能对应起来。最终原因是：PHP将key写入MySQL数据库之前，没有经过trim()过滤首尾空格（关键是尾部空格），结果：
1、MySQL的varchar、char类型字段，SELECT .... WHERE 查询时忽略字段的尾部空格。例如varchar类型字段uidcode中，存储的含有尾部空格的内容“rewinx ”，通过以下三种方式均可查询到：
在MySQL手册第“11.4.1. CHAR和VARCHAR类型”节中写道（http://dev.mysql.com/doc/refman/5.1/zh/column-types.html#char）：请注意所有MySQL校对规则属于PADSPACE类。这说明在MySQL中的所有CHAR和VARCHAR值比较时不需要考虑任何尾部空格。请注意所有MySQL版本均如此，并且它不受SQL服务器模式的影响。
2、PHP 的 Memcache 扩展，则在set、get时，自动将key中的空格，转换成了半角下划线“_”。当然，直接通过 Memcached 协议来读取，key值“rewinx ”就要写成“rewinx_”了。
示例：testmc.php
1、MySQL的varchar、char类型字段，SELECT .... WHERE 查询时忽略字段的尾部空格。例如varchar类型字段uidcode中，存储的含有尾部空格的内容“rewinx ”，通过以下三种方式均可查询到：
在MySQL手册第“11.4.1. CHAR和VARCHAR类型”节中写道（http://dev.mysql.com/doc/refman/5.1/zh/column-types.html#char）：请注意所有MySQL校对规则属于PADSPACE类。这说明在MySQL中的所有CHAR和VARCHAR值比较时不需要考虑任何尾部空格。请注意所有MySQL版本均如此，并且它不受SQL服务器模式的影响。
2、PHP 的 Memcache 扩展，则在set、get时，自动将key中的空格，转换成了半角下划线“_”。当然，直接通过 Memcached 协议来读取，key值“rewinx ”就要写成“rewinx_”了。
示例：testmc.php
sdd 
2026-8-16 17:10
Fine Posting, We're an important believer around writing commentary for web pages so that you can allow the site freelancers realise that they’ve increased a little something valuable so that you can the ether! slot depo 5k Preserve the fantastic succeed, Document look at small number of reports using this ınternet site and additionally I presume the cyberspace web page is normally substantial unique there are found groups about terrific knowledge. slot depo 5k dana Preserve the fantastic succeed, Document look at small number of reports using this ınternet site and additionally I presume the cyberspace web page is normally substantial unique there are found groups about terrific knowledge. slot depo 5k dana
sdd
2026-8-16 17:10
Wonderful article, their quite a neat web site that you've below, carry on the excellent operate, are going to be rear. situs slot dana Wonderful article, their quite a neat web site that you've below, carry on the excellent operate, are going to be rear. slot deposit 5000 dana
dgsdg
2026-8-18 17:00
It is and so wonderful in addition to resourceful. I just now appreciate this colorings in addition to the person who obtains the item from the send will likely be happy. 성인 피시
dgsdg
2026-8-18 17:36
You will be permitted to posting companies, yet not one-way links, except in cases where they can be permitted plus for issue. 성인 피시
分页： 11/11 
6 7 8 9 10 11 
6 7 8 9 10 11
