Comments (7)
i fix that by change line 107 in row_event.py
str = unicode(str, column.character_set_name, 'ignore')
from python-mysql-replication.
Hi,
Can you provide SQL commands in order to replicate this our test suite?
Thanks a lot
Le vendredi 3 mai 2013 à 17:15, 软件工程师李飛 a écrit :
i fix that by change line 107 in row_event.py
str = unicode(str, column.character_set_name, 'ignore')—
Reply to this email directly or view it on GitHub (#17 (comment)).
from python-mysql-replication.
(Pdb) str
\xe7\x8f\xad\xe7\x89
from python-mysql-replication.
the text was cut off.
the origin text in db is:
<DIV><DIV>西班牙游客数小幅增长 欲大力开拓亚洲市场><p>中新网4月22日电 据西班牙欧浪网报道,2013年一季度,得益于3月份圣周的推动,西班牙外国游客人数增长了2%,弥补了1、2月份外国游客人数有所减少的情况。</p><p>工业能源和旅游部部长JoséManuel Soria表示,今年前两个月,西班牙外国游客人数呈现下降趋势,但3月份以来得益于圣周的推动,单月外国游客人数同比增长了7个百分点。</p><p>Soria认为,今年夏天西班牙的外国游客人数预计还会有明显增长,去年与5770万游客选择来到西班牙旅游。</p><p>在夏季到来之前,预订率一直在增长,因此我们可以相信今年西班牙旅游业的发展形势良好,Soria表示,旅游业为西班牙国内生产总值贡献良多,从业人员也占到了总数的11.8%。</p><p>Soria表示,要维持西班牙旅游业的良好发展态势,多样化旅游服务种类是关键,并且要开发亚洲等旅客输出大国。</p><p>她表示,亚洲正处在经济繁华时期,因此人们的出国旅游能力越来越强。在这方面,她强调,要打造西班牙的旅游品牌,并且向全世界推广出去。</p><p>Soria表示,现在亚洲游客对于西班牙来说是必不可少的,本土的企业必须与这些地区加强联系,除了吸引游客到西班牙旅游以外,也要利用国家基础建设工程与拉丁美洲市场增进联系。</p><p>因此,最新北海旅游价格她认为,有必要对于亚洲市场旅游签证的发放放宽限制,采取更为灵活的方法,增加和优化在亚洲国家的咨询团队。</p><p>Soria呼吁,西班牙企业应该加强在亚洲市场的高科技服务,让人们可以通过网络预订来西班牙的行程和获得更多旅游目的地的信息。</p><p>可以肯定的是,越来越多的亚洲游客对西班牙充满了阳光和沙滩的旅程有兴趣,西班牙的文化,饮食和城市气息也对亚洲游客充满吸引力。</p><p>此外,亚洲游客也中意来到西班牙购物。目前来西班牙旅游的亚洲团队大概占20%,且有不断上升的趋势。</p><p>群众旅游网:http://www.qunzo.com四川省**旅行社</p><p><strong>旅游咨询电话:</strong></p><p>四川旅游咨询电话:028-85554651</p><p>国内旅游咨询电话:028-85583210</p><p>出境旅游咨询电话:028-85581646</p></DIV></DIV>
but length of the text in event is 2115, so "此外,亚洲游客也中意来到西班牙购物。" is cut off to be "此外,亚洲游客也中意来到西班\xe7\x89", \xe7\x89 is the first two bit of "牙".
from python-mysql-replication.
Ok i think i perhaps understand the root cause.
In our unicode support perhaps we are not reading enough characters (a confusion between characters and bytes).
from python-mysql-replication.
Can you provide to us the CREATE TABLE statement use for create this table?
A very interressant issue.
from python-mysql-replication.
Closed because can't reproduce
from python-mysql-replication.
Related Issues (20)
- Change read.me file Url link HOT 3
- Add Example for MySQL to Kafka events
- Fix missing charset setting in base.py HOT 1
- module distutils deprecated change to packaging
- auto_position 如何使用
- How to use auto_position ? HOT 4
- [readme] mysql-server-settings part has a deprecated variable HOT 3
- A wrong warning message is logged for every event from ignored table HOT 3
- need json feature
- New Feature: asyncio support for BinLogStreamReader HOT 11
- Discrepancy in parsing results for the same event before and after adding a new field HOT 4
- Decode Exception due to Inaccurate Length from self.query_length Leading to Byte Sequence Truncation HOT 3
- upgrade and improve perfermance HOT 12
- logging statement in `BinLogStreamReader.fetchone` is using logging.WARN instead logging.log HOT 1
- Assertion Error HOT 14
- I can't retrieve the updated or written field names; all I get are things like UNKNOWN_COL0. HOT 15
- Bug in f-string formatting HOT 4
- __checksum_enabled : TypeError: unhashable type: 'slice' HOT 7
- BinLogStreamReader is not resuming from last position (log_file, log_pos not working). HOT 1
- Lint error
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from python-mysql-replication.