MySQL数据校验时需要注意的问题:mysql 4 和 mysql5对varchar的处理方式不同

| No Comments | No TrackBacks

由于校验是在mysql4和mysql5之间,校验生成同一sql语句在mysql4和mysql5之间成生的校验码都不一样,原因:

MySQL 5.0 and later all retain trailing spaces in "VARCHAR", while previous versions would remove them.

mysql4 and pre ver 在保存一个后面有空格的值到varchar时会把后面的空格去掉,mysql5 会保存

--EOF--

No TrackBacks

TrackBack URL: http://www.guduo.net/cgi-bin/mt/mt-tb.cgi/184

Leave a comment

Pages

May 2016

Sun Mon Tue Wed Thu Fri Sat
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 31        

About this Entry

This page contains a single entry by 谷多 published on April 14, 2009 12:14 AM.

MySQL 优化:让你的数据尽可能的小 was the previous entry in this blog.

MySQL api自动重连的问题 is the next entry in this blog.

Find recent content on the main index or look in the archives to find all content.