Question

我有一个VARCHAR(4)栏,接收来自超过4个特性的投入的数据。然而,这是不错的,而且我自然地(或我这样认为)让我的我的我的后勤部停止其性质。

奇怪的是,当我对数据库浏览结果进行观察之后,在PHP(Using the PDO的驾驶员)中,整条插座正在显示,而不仅仅是4个特性。

如果我对我的SQL CLI进行“选举调查”,它只恢复4个特性。即使在我做我的假设时,只有4个特性显示。

任何可能造成这种奇怪的不一致的想法?

Note that these characters are all numbers.

Edit:根据要求,这里有某种代谢法,代表了储蓄/债务法:

查封:

$data = array(
      name_first4        => $fields[ num ],   
     // name_first4 is the column name with VARCHAR(4)
);
$where = $this->getTable()->getAdapter()->quoteInto( id = ? , $id);
$this->getTable()->update($data,$where);

Fetching, using Zend_Db_Table:

$row = $this->getTable()->fetchRow(
    $this->getTable()->select()->where( id=? ,$data)
);

Answer 1

如果你重新这样做:

Create or load an object $o.
Assign 12345 to the property/column in question.
Save $o and let MySQL truncate the value to 1234 .
Access the property/column in $o and get 12345 back.

然后,你再次看到让你的数据库无声地 man击你的数据的问题之一。

The save succeeds, your object has no idea that MySQL has truncated the data so it keeps the 12345 around rather than reloading that column from the database, and you have inconsistent data on your hands.

如果你依靠我的SQL默地篡夺你的数据,你可能不得不这样做:

Create/load your object.
Updated the properties.
Save the object.
Throw away your local reference to the object.
Load it fresh from the database to make sure you get the real values.

d 我建议对您的物体进行严格鉴定,以避免在MySQL内部出现无声的拖网。转载于strict ,这也将避免这一问题,但随后,你需要审查和加紧处理和验证你的所有错误和数据(这确实是一种坏事)。

友情链接