About kanjidic_access.mdb (2004/08/16) ------------------------- This Microsoft Access database file contains information from KANJIDIC version dated August 14 2004 Copyright (C) 2004 James William Breen. This version of KANJIDIC has been obtained from the file located at http://ftp.cc.monash.edu.au/pub/nihongo/kanjidic.zip The data contained in this database is subject to all copyright and license information described in the original KANJIDIC documentation. A HTML version of the KANJIDIC documentation can be found at http://ftp.cc.monash.edu.au/pub/nihongo/kanjidic_doc.html Version history KANJIDIC version 2004/08/14 2004/08/16 - Latest KANJIDIC version (2004/08/14) Changes found since previous version: - Kanji: Grade added for 2 entries - EnglishMeaning: 3 changed - KanjiReading: 2 added KANJIDIC version 2004/03/11 2004/03/17 - Latest KANJIDIC version (2004/03/11) Changes found since previous version: - KanjiIndex: IndexN - 1 removed IndexDO - 1 removed, 1 added IndexMN - 12 changed, 131 added IndexMP - 136 added - EnglishMeaning: 165 added, 111 removed - KanjiReading: 36 added, 7 removed KANJIDIC version 2003/09/01 2003/09/01 - Latest KANJIDIC version (2003/09/01) KANJIDIC version 2003/07/21 2003/07/23 - Latest KANJIDIC version (2003/07/21) Changes found since previous version: - Kanji: Frequency changed for 2549 entries Bushu changed for 2 entries ClassicalBushu removed for 2 entries SKIP changed for 1 entry - KanjiIndex: IndexIN field added for 284 entries - EnglishMeaning: 6 entries corrected, 36 added, 1 removed - KanjiReading: 1 entry corrected, 2 added - KoreanReading: 2 entries corrected, 3 removed KANJIDIC version 2002/02/06 2002/03/12 - Latest KANJIDIC version (2002/02/06) Changes found since previous version: - Kanji: Grade field has been added for 1 entry and changed for 2 - EnglishMeaning: 3 entries corrected, 8 added, 1 removed - KanjiReading: 2 entries added KANJIDIC version 2001/05/22 2002/01/29 (Rev 1) - Kanji field correction The field containing the kanji character seemed to be corrupted. This has been corrected by giving the field a size of 2 characters instead of 1 character. Perhaps Access considers 1 character as 1 byte and trashed the second byte. 2002/01/15 - First release This database file contains all the information from KANJIDIC except: - cross-reference codes (Xxxxxxx) - mis-classification codes (Zxxxxxx) - additional stroke counts (S) because: "If more than one, the first is considered the accepted count, while subsequent ones are common miscounts." The data from KANJIDIC was first imported into a SQL Server 7.0 database using ASP (Active Server Pages) scripts running on IIS on Windows 2000 Server. Extreme care was taken for the data to be imported without any losses or mistakes. Data from KANJIDIC has been separated in several tables in order to facilitate its access through SQL. All kanji has been indexed using the decimal value corresponding to the hexadecimal JIS value at positions 3 to 6 (bytes 4 to 7) present on each line of KANJIDIC. The JISDec field is present in every table and represents the kanji to which the information corresponds. These tables are: Kanji -- Main table containing all basic and unique (up to one for each kanji) kanji information. JISDec (integer) JIS decimal value (used to join with other tables) JISHex (text (4)) JIS hexadecimal value UnicodeDec (integer) Unicode decimal value UnicodeHex (text (4)) Unicode hexadecimal value (U) Kanji (text (1)) Kanji character itself Bushu (integer) Radical (bushu) number (B) ClassicalBushu (integer) Classical radical number (C) Frequency (integer) Frequency (F) Grade (integer) Jouyou grade level (G) StrokeCount (integer) Stroke count (S) (if several occurences were present, first only) SKIP (text (7)) SKIP pattern code (P) FourCorner (text (6)) "Four corner" code (Qnnnn.n) KanjiIndex -- Annex table containing index information to finding the kanji in dictionaries and books. There is exactly one entry in this table for each entry in the Kanji table. JISDec (integer) JIS decimal value (to join with other tables) IndexH (integer) New Japanese-English Character Dictionary (H) IndexN (integer) Modern Reader's Japanese-English Character Dictionary (N) IndexV (integer) The New Nelson Japanese-English Character Dictionary (V) IndexDR (integer) Father Joseph De Roo's 2001 Kanji (DRnnnn) IndexDK (integer) Jack Halpern's Kanji Learners Dictionary (DKnnnn) IndexDO (integer) P.G. O'Neill's Essential Kanji (DOnnnn) IndexI (text (9)) Spahn & Hadamitzky's The Kanji Dictionary (I) IndexIN (integer) Spahn & Hadamitzky's Kanji & Kana Book (INnnnn) IndexMN (text (7)) Morohashi index number (MNnnnnnnn) IndexMP (text (7)) Morohashi volume.page (MPnn.nnnn) IndexE (integer) A Guide To Remembering Japanese Characters (Ennnn) IndexK (integer) Gakken Kanji Dictionary (Knnnn) IndexL (integer) Remembering The Kanji (Lnnnn) IndexO (text (5)) Japanese Names (Onnnn) KanjiEnglishMeaning -- English meanings of each kanji. There can be any number of entries in this table for each entry in the Kanji table. EnglishMeaningID (integer) Sequential identifier JISDec (integer) JIS decimal value (to join with other tables) EnglishMeaning (text (255)) English meaning of the kanji KanjiReading -- Readings of each kanji. There can be any number of entries in this table for each entry in the Kanji table. ReadingID (integer) Sequential identifier JISDec (integer) JIS decimal value (to join with other tables) Kun (bit) 0 if not a "kun" reading Class (integer) Reading class (Tn) Reading (text (255)) Reading of the kanji (hiragana or katakana) KanjiKoreanReading -- Korean readings of each kanji. There can be any number of entries in this table for each entry in the Kanji table. KoreanReadingID (integer) Sequential identifier JISDec (integer) JIS decimal value (to join with other tables) KoreanReading (text (255)) Korean reading of the kanji KanjiPinyin -- "Pinyin" of each kanji. There can be any number of entries in this table for each entry in the Kanji table. PinyinID (integer) Sequential identifier JISDec (integer) JIS decimal value (to join with other tables) Pinyin (text (7)) Pinyin of the kanji Some Access queries have also been included as examples of how to retrieve data from several tables. KanjiWithIndex KanjiEnglishMeaningList KanjiReadingList KanjiKoreanReadingList KanjiPinyinList Hoping that this can help some developers to use the precious contents of KANJIDIC in their non-commercial Windows applications or Web projects. Best regards, Patrick Benny Computer programmer learning Japanese chipple@chipple.net 2002/01/15 (Updated 2004/08/16) (This text file and database file have been authored by Patrick Benny however all data contained in the database is subject to all copyright and license information described in the original KANJIDIC documentation. A HTML version of the KANJIDIC documentation can be found at http://ftp.cc.monash.edu.au/pub/nihongo/kanjidic_doc.html)