[FZH] ibus-table update to 1.8.1

[Ding Yi Chen]

BTW, I have updated and pushed  ibus-table-chinese-1.8.1  to bodhi.


----- Original Message -----
> Mike FABIAN <maiku.fabian於gmail.com> さんはかきました:
> 
> > Felix Yan <felixonmars於gmail.com> さんはかきました:
> >
> >> On Thursday, June 05, 2014 12:17:45 Mike FABIAN wrote:
> >>> As the database format has been changed, the ibus-table-chinese*
> >>> packages have to be updated as well. ibus-table-chinese* packages which
> >>> have been build against old versions of ibus-table will not work due to
> >>> the change in the database format.
> >>
> >> Hi, I've tested with ibus-table-chinese* 1.4.6 built against ibus-table
> >> 1.7.0,
> >> which still seems to work with 1.8.1 even without a rebuild. Is this
> >> normal,
> >> or am I missing something?
> >
> > This is normal, ibus-table-1.7.0 already had the new database format.
> 
> You can check what database format you have by doing:
> 
> sqlite3 /usr/share/ibus-table/tables/wubi-jidian86.db
> sqlite> select * from phrases;
> ...
> 136829|zzzy|ㄦ|392|0
> sqlite>
> 
> This is the new database format, first column is some integer rowid, 2nd
> column is the input sequence (“zzzy”), 3rd column is the phrase for that
> input sequence “ㄦ”, 4th column is the system frequency (392) and the 5th
> column is the user frequency (always 0 if this is a system database).
> 
> The old database format looks like this:
> 
> sqlite3 /usr/share/ibus-table/tables/wubi-jidian86.db.orig
> sqlite> select * from phrases;
> ...
> 136829|4|1|26|26|26|25|3|ㄦ|392|0
> sqlite>
> 
> The first column is again the integer rowid, the 2nd column is the
> length of the input sequence (4), the 3rd column is the length of the
> phrase (1), the next 4 columns are integer codes for the input sequence
> “zzzy”, the 8th column is a bitfield indicating whether this phrase is
> simplified or traditional Chinese (3 means it is both), the 9th row is
> the phrase (ㄦ) and then again system frequency and user frequency.
> 
> The new database does not need the bitfield for traditional and
> simplified Chinese anymore because it calculates this at runtime, not at
> build time of the database. The separate columns with integer codes for
> the input sequence have been merged into one row for the input sequence
> as a string. And columns for the length of the input sequence and the
> phrase are not needed as these can be easily calculated at runtime.
> 
> --
> Mike FABIAN <mfabian於redhat.com>
> ☏ Office: +49-69-365051027, internal 8875027
> 睡眠不足はいい仕事の敵だ。
> --
> Fedora中文郵件列表：https://admin.fedoraproject.org/mailman/listinfo/chinese
> 

-- 
Ding-Yi Chen
Software Engineer
Internationalization Group
DID: +61 7 3514 8239
Email: dchen於redhat.com

Red Hat, Asia-Pacific Pty Ltd
Level 1, 193 North Quay
Brisbane 4000
Office: +61 7 3514 8100
Fax: +61 7 3514 8199
Website: www.redhat.com

Red Hat, Inc.
Facebook: Red Hat APAC | Red Hat Japan | Red Hat Korea | JBoss APAC
Twitter: Red Hat APAC | Red Hat ANZ
LinkedIn: Red Hat APAC | JBoss APAC