Locale

static char *base36enc(long unsigned int value) {
    char base36[36] = "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ";
    /* log(2**64) / log(36) = 12.38 => max 13 char + '\0' */
    char buffer[14];
    unsigned int offset = sizeof(buffer);

    buffer[--offset] = '\0';
    do {
        buffer[--offset] = base36[value % 36];
    } while (value /= 36);

    return strdup(&buffer[offset]); // warning: this must be free-d by the user
}

static long unsigned int base36dec(const char *text) {
    return strtoul(text, NULL, 36);
}

---

Index	Binary	Char		Index	Binary	Char		Index	Binary	Char		Index	Binary	Char
0	000000	A		16	010000	Q		32	100000	g		48	110000	w
1	000001	B		17	010001	R		33	100001	h		49	110001	x
2	000010	C		18	010010	S		34	100010	i		50	110010	y
3	000011	D		19	010011	T		35	100011	j		51	110011	z
4	000100	E		20	010100	U		36	100100	k		52	110100	0
5	000101	F		21	010101	V		37	100101	l		53	110101	1
6	000110	G		22	010110	W		38	100110	m		54	110110	2
7	000111	H		23	010111	X		39	100111	n		55	110111	3
8	001000	I		24	011000	Y		40	101000	o		56	111000	4
9	001001	J		25	011001	Z		41	101001	p		57	111001	5
10	001010	K		26	011010	a		42	101010	q		58	111010	6
11	001011	L		27	011011	b		43	101011	r		59	111011	7
12	001100	M		28	011100	c		44	101100	s		60	111100	8
13	001101	N		29	011101	d		45	101101	t		61	111101	9
14	001110	O		30	011110	e		46	101110	u		62	111110	+
15	001111	P		31	011111	f		47	101111	v		63	111111	/

Types

Data SELECT id, data_type_code, data_type_name, enter_at, enter_by, amend_at, amend_by FROM M00TM00X00

Error SELECT id, error_type_code, error_type_name, enter_at, enter_by, amend_at, amend_by FROM M00TM01X00

Mime SELECT id, mime_type_code, mime_type_name, enter_at, enter_by, amend_at, amend_by FROM M00TM##X00

Objects

Tables SELECT id, table_code, table_name, data_type_code, enter_at, enter_by, amend_at, amend_by FROM M00TM02X00

Forms SELECT id, form_code, form_name, data_type_code, apps_type, base_flag, base_form, enter_at, enter_by, amend_at, amend_by FROM M00TM03X00

Reports SELECT id, report_code, report_name, data_type_code, enter_at, enter_by, amend_at, amend_by FROM M00TM04X00

Errors SELECT id, error_code, error_name, error_type_code, enter_at, enter_by, amend_at, amend_by FROM M00TM05X00

Labels

Fields SELECT id, field_code, table_code, field_order, field_name, enter_at, enter_by, amend_at, amend_by FROM M00TM06X00

Forms SELECT id, label_code, form_code, label_name, label_value, enter_at, enter_by, amend_at, amend_by FROM M00TM07X00

Reports SELECT id, label_code, report_code, label_name, label_value, enter_at, enter_by, amend_at, amend_by FROM M00TM08X00

Localizations

Languages SELECT id, lingo_code, iso_alpha2_lingo_code, iso_alpha3_lingo_code, lingo_name, enter_at, enter_by, amend_at, amend_by FROM M00TL00X00

Countries SELECT id, country_code, iso_alpha2_country_code, iso_alpha3_country_code, longitude, latitude, altitude, country_name, enter_at, enter_by, amend_at, amend_by FROM M00TL01X00

Currencies SELECT id, notes_code, iso_alpha3_notes_code, iso_alpha3_state_code, iso_numeric_code, official_flag, decimal_point, notes_symbol, crypto_flag, notes_name, enter_at, enter_by, amend_at, amend_by FROM M00TL02X00

Translations

Tables SELECT id, translated_code, table_code, field_code, field_value, iso_alpha2_lingo_code, iso_alpha2_state_code, translated_value, enter_at, enter_by, amend_at, amend_by FROM M00TL03X00

Forms SELECT id, translated_code, form_code, label_code, iso_alpha2_lingo_code, iso_alpha2_state_code, translated_value, enter_at, enter_by, amend_at, amend_by FROM M00TL04X00

Reports SELECT id, translated_code, report_code, label_code, iso_alpha2_lingo_code, iso_alpha2_state_code, translated_value, enter_at, enter_by, amend_at, amend_by FROM M00TL05X00

Errors SELECT id, translated_code, error_code, iso_alpha2_lingo_code, iso_alpha2_state_code, translated_value, enter_at, enter_by, amend_at, amend_by FROM M00TL06X00

References

• Prepositions of Time - at, in, on
• JPA Inheritance
• Base64
• Base36
• Base32
• DBUnit