Programming & Development / April 11, 2025

How to Represent All Countries in Java and SQL with ISO 3166-1 Alpha-2 Codes

countries list Java enum countries ISO 3166-1 alpha-2 country code SQL country codes enum Spring Boot enum address validation country ISO code list global country codes world countries enum

🌍 Java Enum: Countries with ISO Alpha-2 Codes

Here is a Java enum representing all officially recognized countries using their ISO 3166-1 alpha-2 codes:

Sample of top 10 countries; full enum available on request or file export.
java

public enum Country {
    AFGHANISTAN("AF"),
    ALBANIA("AL"),
    ALGERIA("DZ"),
    ANDORRA("AD"),
    ANGOLA("AO"),
    ARGENTINA("AR"),
    ARMENIA("AM"),
    AUSTRALIA("AU"),
    AUSTRIA("AT"),
    AZERBAIJAN("AZ");
    // ... up to ZIMBABWE ("ZW");

    private final String code;

    Country(String code) {
        this.code = code;
    }

    public String getCode() {
        return code;
    }
}

🗃️ SQL Version: Countries Table with ISO Alpha-2 Codes

sql

CREATE TABLE countries (
    id SERIAL PRIMARY KEY,
    name VARCHAR(64) NOT NULL,
    code CHAR(2) NOT NULL UNIQUE
);

Sample Insert Statements:

sql

INSERT INTO countries (name, code) VALUES
('Afghanistan', 'AF'),
('Albania', 'AL'),
('Algeria', 'DZ'),
('Andorra', 'AD'),
('Angola', 'AO'),
('Argentina', 'AR'),
('Armenia', 'AM'),
('Australia', 'AU'),
('Austria', 'AT'),
('Azerbaijan', 'AZ');
-- ... full list available

✅ Summary

Using a structured enum and SQL dataset for all countries (based on ISO 3166-1) ensures consistency, international compatibility, and ease of integration for global apps.


Comments

No comments yet

Add a new Comment

NUHMAN.COM

Information Technology website for Programming & Development, Web Design & UX/UI, Startups & Innovation, Gadgets & Consumer Tech, Cloud Computing & Enterprise Tech, Cybersecurity, Artificial Intelligence (AI) & Machine Learning (ML), Gaming Technology, Mobile Development, Tech News & Trends, Open Source & Linux, Data Science & Analytics

Categories

Tags

©{" "} Nuhmans.com . All Rights Reserved. Designed by{" "} HTML Codex