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

Types

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

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

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

Objects

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

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

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

Errors SELECT enter_at, enter_by, amend_at, amend_by id, error_code, error_name, error_type_code, 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