<select id="upBasic" resultMap="ProductInfo">
select CONVERT (product_basic USING utf8) AS product_basic from t_product_info WHERE product_id = #{productId}
</select>
<!-- 转换商品简介为中文 -->
<select id="upIntroduce" resultMap="ProductInfo">
select CONVERT (product_introduce USING utf8) AS product_introduce from t_product_info WHERE product_id = #{productId}
</select>
<!-- 转换blob -->
<select id="upBlob" resultMap="ProductInfo">
select
product_id, product_name, product_order,
product_photo, product_dphoto, product_message,
product_type, product_state, product_publish,
product_pubtime,product_modify,product_modtime,
CONVERT (product_basic USING utf8) AS product_basic,
CONVERT (product_introduce USING utf8) AS product_introduce from t_product_info
</select>
blob转换为utf-8(sql语句)
最新推荐文章于 2022-07-21 11:09:04 发布