magento sorting varchar 字段排序问题

soring 字段为 varchar 字段。

$this->_productCollection = $layer->getProductCollection()
            ->setOrder('sorting','DESC');

$this->_productCollection->getSelect()->reset(Zend_Db_Select::ORDER);

$this->_productCollection->getSelect()->order('CAST(`sorting` AS SIGNED) DESC');