Exception when running update statement with utf8 encoding
Posted: Tue 28 Dec 2010 03:43
Below is the script generated by your data comparison sync.
FYI, the field content is thai language.
When executing, it generate the below error :
輸出位元組緩衝區太小，無法包含已編碼的資料，編碼方式 'Unicode (UTF-8)' 後援 'System.Text.EncoderReplacementFallback'。
參數名稱: bytes
As it is Chinese, I would try to translate it as follow :
The buffer for output bytes is too small. Cannot include the encoded data. Encoding : 'Unicode (UTF-8)'
Support: 'System.Text.EncoderReplacementFallback' Variable Name : bytes
If copy the update statement to be execute alone, the error is the same.
If copy the update statement to other mysql clients (tested : SQLyog, MySQL Front, MySQL Query Browser) to execuate, there is no error.
Thanks in advance for your help.
Code: Select all
-- Script was generated by Devart dbForge Studio for MySQL, Version 4.50.314.0
-- Script date 2010/12/28 11:26:18
-- Source server version: 5.1.49-community
-- Source connection string: User Id=root;Host=localhost;Port=3308;Ping Interval=240;Character Set=AUTO;
-- Target server version: 5.1.49-community
-- Target connection string: User Id=root;Host=localhost;Port=3307;Character Set=utf8;
-- Run this script against ebsapp_escape_new to synchronize it with ebsapp
-- Please backup your target database before running this script
SET NAMES 'utf8';
USE ebsapp_escape_new;
--
-- Disable foreign keys
--
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
--
-- Updating data of table langstr
--
UPDATE langstr SET tis = 'เอกสาร Refresh | อ่านข้ที่คุณเปิดเฟรชครั้งล่าสุด'
WHERE Str = 'ACT_DOCREFRESH_H';
--
-- Enable foreign keys
--
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
When executing, it generate the below error :
輸出位元組緩衝區太小，無法包含已編碼的資料，編碼方式 'Unicode (UTF-8)' 後援 'System.Text.EncoderReplacementFallback'。
參數名稱: bytes
As it is Chinese, I would try to translate it as follow :
The buffer for output bytes is too small. Cannot include the encoded data. Encoding : 'Unicode (UTF-8)'
Support: 'System.Text.EncoderReplacementFallback' Variable Name : bytes
If copy the update statement to be execute alone, the error is the same.
If copy the update statement to other mysql clients (tested : SQLyog, MySQL Front, MySQL Query Browser) to execuate, there is no error.
Thanks in advance for your help.