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);
}

Types

Data SELECT data_type_code, data_type_name, entered, enterer, amended, amender FROM M00TM00X00

Error SELECT error_type_code, error_type_name, entered, enterer, amended, amender FROM M00TM01X00

Objects

Tables SELECT table_code, table_name, data_type_code, entered, enterer, amended, amender FROM M00TM02X00

Forms SELECT form_code, form_name, data_type_code, apps_type, base_flag, base_form, entered, enterer, amended, amender FROM M00TM03X00

Reports SELECT report_code, report_name, data_type_code, entered, enterer, amended, amender FROM M00TM04X00

Errors SELECT error_code, error_name, error_type_code, entered, enterer, amended, amender FROM M00TM05X00

Labels

Fields SELECT field_code, table_code, field_order, field_name, entered, enterer, amended, amender FROM M00TM06X00

Forms SELECT label_code, form_code, label_name, label_value, entered, enterer, amended, amender FROM M00TM07X00

Reports SELECT label_code, report_code, label_name, label_value, entered, enterer, amended, amender FROM M00TM08X00

Localizations

Languages SELECT lingo_code, iso_alpha2_lingo_code, iso_alpha3_lingo_code, lingo_name, entered, enterer, amended, amender FROM M00TL00X00

Countries SELECT state_code, iso_alpha2_state_code, iso_alpha3_state_code, longitude, latitude, altitude, state_name, entered, enterer, amended, amender FROM M00TL01X00

Currencies SELECT notes_code, iso_alpha3_notes_code, iso_alpha3_state_code, iso_numeric_code, official_flag, decimal_point, notes_symbol, crypto_flag, notes_name, entered, enterer, amended, amender FROM M00TL02X00

Translations

Tables SELECT translated_code, table_code, field_code, field_value, iso_alpha2_lingo_code, iso_alpha2_state_code, translated_value, entered, enterer, amended, amender FROM M00TL03X00

Forms SELECT translated_code, form_code, label_code, iso_alpha2_lingo_code, iso_alpha2_state_code, translated_value, entered, enterer, amended, amender FROM M00TL04X00

Reports SELECT translated_code, report_code, label_code, iso_alpha2_lingo_code, iso_alpha2_state_code, translated_value, entered, enterer, amended, amender FROM M00TL05X00

Reports SELECT translated_code, error_code, iso_alpha2_lingo_code, iso_alpha2_state_code, translated_value, entered, enterer, amended, amender FROM M00TL06X00

References

• Base64
• Base36
• Base32