Magento Doesn't Store Full Countries Name on the Database It relies on a localization mechanism to display country names based on the locale or store view Using Zend Locale Can be found on this path ./vendor/magento/zendframework1/library/Zend/Locale/Data/ In order to get full country name through SQL you will need to create a table that includes the country code and country name manually