Michael Doran Home Page
Contact | Site Map | Search  
  Home > Archives > Coded Character Sets > URDU > About > Database Tables
  Menu

URDU

Unicode Relational Database Utility
- beta -
  Character Map Charts

Database Tables

+------------------------------------------------------------------------+
| iso8859_1                                                              |
+------------------------------------------------------------------------+
| latin_code*    | char(2)        | Latin-1 8-bit code in hex            |
| ucs_code       | char(4)	  | UCS/Unicode 16-bit code in hex       |
+------------------------------------------------------------------------+

+------------------------------------------------------------------------+
| marc                                                                   |
+------------------------------------------------------------------------+
| id*            | int(11)        | auto-incrementing key                |
| marc_code      | varchar(10)    | MARC 8-bit code in hex               |
| ucs_code       | char(4)	  | UCS/Unicode 16-bit code in hex       |
| char_name      | varchar(128)   | control function character name      |
+------------------------------------------------------------------------+

+------------------------------------------------------------------------+
| marc_8_arabic_basic                                                    |
+------------------------------------------------------------------------+
| id*            | int(11)        | auto-incrementing key                |
| code           | char(2)        | MARC 8-bit code in hex               |
| ucs_code       | char(4)	  | UCS/Unicode 16-bit code in hex       |
| char_name      | varchar(128)   | character name                       |
+------------------------------------------------------------------------+

+------------------------------------------------------------------------+
| marc_8_arabic_ext                                                      |
+------------------------------------------------------------------------+
| id*            | int(11)        | auto-incrementing key                |
| code           | char(2)        | MARC 8-bit code in hex               |
| ucs_code       | char(4)	  | UCS/Unicode 16-bit code in hex       |
| char_name      | varchar(128)   | character name                       |
+------------------------------------------------------------------------+

+------------------------------------------------------------------------+
| marc_8_controls                                                        |
+------------------------------------------------------------------------+
| id*            | int(11)        | auto-incrementing key                |
| code           | char(2)        | MARC 8-bit code in hex               |
| ucs_code       | char(4)	  | UCS/Unicode 16-bit code in hex       |
| char_name      | varchar(128)   | character name                       |
+------------------------------------------------------------------------+

+------------------------------------------------------------------------+
| marc_8_cyrillic_basic                                                  |
+------------------------------------------------------------------------+
| id*            | int(11)        | auto-incrementing key                |
| code           | char(2)        | MARC 8-bit code in hex               |
| ucs_code       | char(4)	  | UCS/Unicode 16-bit code in hex       |
| char_name      | varchar(128)   | character name                       |
+------------------------------------------------------------------------+

+------------------------------------------------------------------------+
| marc_8_cyrillic_ext                                                    |
+------------------------------------------------------------------------+
| id*            | int(11)        | auto-incrementing key                |
| code           | char(2)        | MARC 8-bit code in hex               |
| ucs_code       | char(4)	  | UCS/Unicode 16-bit code in hex       |
| char_name      | varchar(128)   | character name                       |
+------------------------------------------------------------------------+

+------------------------------------------------------------------------+
| marc_8_greek_basic                                                     |
+------------------------------------------------------------------------+
| id*            | int(11)        | auto-incrementing key                |
| code           | char(2)        | MARC 8-bit code in hex               |
| ucs_code       | char(4)	  | UCS/Unicode 16-bit code in hex       |
| char_name      | varchar(128)   | character name                       |
+------------------------------------------------------------------------+

+------------------------------------------------------------------------+
| marc_8_hebrew_basic                                                    |
+------------------------------------------------------------------------+
| id*            | int(11)        | auto-incrementing key                |
| code           | char(2)        | MARC 8-bit code in hex               |
| ucs_code       | char(4)	  | UCS/Unicode 16-bit code in hex       |
| char_name      | varchar(128)   | character name                       |
+------------------------------------------------------------------------+

+------------------------------------------------------------------------+
| marc_8_latin_basic                                                     |
+------------------------------------------------------------------------+
| id*            | int(11)        | auto-incrementing key                |
| code           | char(2)        | MARC 8-bit code in hex               |
| ucs_code       | char(4)	  | UCS/Unicode 16-bit code in hex       |
| char_name      | varchar(128)   | character name                       |
+------------------------------------------------------------------------+

+------------------------------------------------------------------------+
| marc_8_latin_ext                                                       |
+------------------------------------------------------------------------+
| id*            | int(11)        | auto-incrementing key                |
| code           | char(2)        | MARC 8-bit code in hex               |
| ucs_code       | char(4)	  | UCS/Unicode 16-bit code in hex       |
| char_name      | varchar(128)   | character name                       |
+------------------------------------------------------------------------+

+------------------------------------------------------------------------+
| sgml                                                                   |
+------------------------------------------------------------------------+
| id*            | int(11)        | auto-incrementing key                |
| char_name      | varchar(9)     | SGML character entity name           |
| entity_set     | varchar(11)    | SGML public entity set               |
| ucs_code       | char(4)        | Unicode 2.0 16-bit code in hex       |
+------------------------------------------------------------------------+

+------------------------------------------------------------------------+
| marc_tables                                                            |
+------------------------------------------------------------------------+
| id*            | int(11)        | auto-incrementing key                |
| number         | varchar(3)     | MARC-8 code table number             |
| name           | varchar(64)    | MARC-8 code table name               |
| norm_name      | varchar(64)    | Normalized MARC-8 code table name    |
+------------------------------------------------------------------------+

+------------------------------------------------------------------------+
| marc2unicode                                                           |
+------------------------------------------------------------------------+
| id*            | int(11)        | auto-incrementing key                |
| table_number   | varchar(3)     | MARC-8 code table number             |
| marc_code      | varchar(6)     | MARC-8 code point in hex             |
| ucs_code       | char(4)        | Unicode 16-bit code in hex           |
| utf8_code      | varchar(6)     | Unicode UTF8 code in hex             |
| marc_name      | varchar(64)    | MARC-8 name                          |
| note           | varchar(64)    | Note                                 |
| alt_ucs_code   | varchar(4)     | Alternate Unicode 16-bit code in hex |
| alt_utf8_code  | varchar(6)     | Alternate Unicode UTF8 code in hex   |
+------------------------------------------------------------------------+

+------------------------------------------------------------------------+
| unicode                                                                |
+------------------------------------------------------------------------+
| ucs_code*      | varchar(6)     | Code point in hex                    |
| char_name      | varchar(128)   | Character name                       |
| gen_cat        | char(2)        | General category                     |
| combo_class    | varchar(3)     | Canonical combining classes          |
| bidirect_cat   | varchar(3)     | Bidirectional category               |
| decomp_map     | varchar(128)   | Character decomposition mapping      |
| dec_digit_val  | varchar(1)     | Decimal digit value                  |
| digit_val      | varchar(1)     | Digit value                          |
| num_val        | varchar(5)     | Numeric value                        |
| mirrored       | char(1)        | Mirrored                             |
| one_zero_name  | varchar(64)    | Unicode 1.0 name                     |
| ucs_comment    | varchar(64)    | 10646 comment field                  |
| ucase_map      | varchar(5)     | Uppercase mapping                    |
| lcase_map      | varchar(5)     | Lowercase mapping                    |
| tcase_map      | varchar(5)     | Titlecase mapping                    |
+------------------------------------------------------------------------+

* primary key