VGCollect Forum

VGCollect Site Stuff => Video Game Database Discussion => Topic started by: tripredacus on February 07, 2016, 02:41:30 pm

Title: Release Country TLD Master List
Post by: tripredacus on February 07, 2016, 02:41:30 pm
TLD cheat sheet.
Region codes:
[EU] Europe
[NA] North America

Country codes:
[AE] United Arab Emirates
[AR] Argentina
[AT] Austria
[AU] Australia
[BA] Bosnia
[BE] Belgium
[BG] Bulgaria
[BR] Brazil
[CA] Canada
[CH] Switzerland
[CN] China
[CZ] Czech Republic
[DE] Germany
[DK] Denmark
[EE] Estonia
[EG] Egypt
[ES] Spain
[FI] Finland
[FR] France
[GR] Greece
[HK] Hong Kong
[HU] Hungary
[ID] Indonesia
[IE] Ireland
[IL] Israel
[IN] India
[IT] Italy
[JP] Japan
[KR] South Korea
[KZ] Kazakhstan
[LT] Lithuania
[MX] Mexico
[MY] Malaysia
[NL] Netherlands
[NO] Norway
[PH] Philippines
[PL] Poland
[PT] Portugal
[QA] Qatar
[RS] Serbia
[RU] Russia
[SA] Saudi Arabia
[SE] Sweden
[SG] Singapore
[SK] Slovakia
[TH] Thailand
[TR] Turkey
[TW] Taiwan
[UA] Ukraine
[UK] England/Great Britain/United Kingdom
[US] United States
[ZA] South Africa

Never use a TLD in an item title where the item is in a category that has the same TLD in its name.
Examples:
- don't have ITEM NAME [EU] in CATEGORY [EU]
- don't have ITEM NAME [US] in CATEGORY [NA]
Title: Re: Release Country TLD Master List
Post by: fazerco on February 07, 2016, 02:53:44 pm
TLD cheat sheet.

[AS] General Asian/Hong Kong release
[AT] Austria
[AU] Australia
[BR ] Brazil (remove space)
[CA] Canada
[CN] China
[DE] Germany
[EU] Europe
[ES] Spain
[FI] Finland
[FR] France
[GR] Greece
[JP] Japan
[NL] Danmark/Netherlands
[NO] Norway
[PL] Poland
[PT] Portugal
[RU] Russia
[SE] Sweden
[UK] England/Great Britain/United Kingdom

Never use a TLD in an item title where the item is in a category that has the same TLD in its name. For example, don't have ITEM NAME [EU] in CATEGORY [EU].
[NL] Danmark/Netherlands?? Its only Netherlands. DK is danmark
Title: Re: Release Country TLD Master List
Post by: tripredacus on March 10, 2016, 12:51:58 pm
Added Benelux [BV]
 (for additions into [EU] categories)
Title: Re: Release Country TLD Master List
Post by: ignition365 on March 10, 2016, 01:09:32 pm
[US] and [NA]
Title: Re: Release Country TLD Master List
Post by: tripredacus on March 10, 2016, 01:30:14 pm
Currently, items in [NA] category are implied to be US releases. The only games where you add a country code on a title is Canada.
Title: Re: Release Country TLD Master List
Post by: ignition365 on March 10, 2016, 01:49:49 pm
Currently, items in [NA] category are implied to be US releases. The only games where you add a country code on a title is Canada.
You don't have either listed in your list.

Also, Neo Geo and Vectrex have [US] instead of [NA] with no [CA] counterpart.
Title: Re: Release Country TLD Master List
Post by: mastafafik on March 10, 2016, 02:21:10 pm
What about multiple regions for example France and Netherlands? As it should be written [FR][NL] or [FR/NL]. I prefer second option [AA/BB] as it is easier to read.
Title: Re: Release Country TLD Master List
Post by: tripredacus on March 10, 2016, 06:40:07 pm
What about multiple regions for example France and Netherlands? As it should be written [FR][NL] or [FR/NL]. I prefer second option [AA/BB] as it is easier to read.

We don't seem to have a rule for that. I think we've been each doing the different method, I use [FR][NL]. I am the opposite, I think the one I do is easier to read.

@ctracy87, Vectrex [US] and the 3 Neo Geo categories are not in agreement with the rest of the categories. They probably should be changed to [NA] to match.
Title: Re: Release Country TLD Master List
Post by: fazerco on March 11, 2016, 01:22:29 pm
What about multiple regions for example France and Netherlands? As it should be written [FR][NL] or [FR/NL]. I prefer second option [AA/BB] as it is easier to read.

We don't seem to have a rule for that. I think we've been each doing the different method, I use [FR][NL]. I am the opposite, I think the one I do is easier to read.

@ctracy87, Vectrex [US] and the 3 Neo Geo categories are not in agreement with the rest of the categories. They probably should be changed to [NA] to match.

You could use [BE] for the [FR][NL]. In Belgium they speak both languages, French, Dutch and some German  ;D.
Title: Re: Release Country TLD Master List
Post by: tripredacus on March 11, 2016, 01:51:10 pm
Added

[CZ] Czech Republic
[SK] Slovakia
for use in [EU] categories

What about multiple regions for example France and Netherlands? As it should be written [FR][NL] or [FR/NL]. I prefer second option [AA/BB] as it is easier to read.

We don't seem to have a rule for that. I think we've been each doing the different method, I use [FR][NL]. I am the opposite, I think the one I do is easier to read.

@ctracy87, Vectrex [US] and the 3 Neo Geo categories are not in agreement with the rest of the categories. They probably should be changed to [NA] to match.

You could use [BE] for the [FR][NL]. In Belgium they speak both languages, French, Dutch and some German  ;D.

In cases where games get labelled [FR][NL] it is due to flags or countries on the box. So this is a regional release for the appropriate languages, but it doesn't mean that it is a Belgian game.
Title: Re: Release Country TLD Master List
Post by: fazerco on March 12, 2016, 05:16:12 am
It was a joke, but it worked better if you where European.

I don't think Belgium has a release to its country because of the different languages spoken there. So they get releases from France, Holland, and Germany.
Title: Re: Release Country TLD Master List
Post by: telly on March 23, 2016, 10:32:13 am
Add [KO] for Korea I'm guessing
Title: Re: Release Country TLD Master List
Post by: tripredacus on March 23, 2016, 12:02:04 pm
Add [KO] for Korea I'm guessing

It is [KR] for South Korea. I will update the first post.
Title: Re: Release Country TLD Master List
Post by: telly on March 23, 2016, 01:20:27 pm
Add [KO] for Korea I'm guessing

It is [KR] for South Korea. I will update the first post.

I dunno, the listing on GameFaqs for South Korean games have it as [KO] They could be wrong though, I have no idea personally.

http://www.gamefaqs.com/ps2/913941-metal-gear-solid-2-sons-of-liberty/images/162774

http://www.gamefaqs.com/ps2/914828-metal-gear-solid-3-snake-eater/images/1179158
Title: Re: Release Country TLD Master List
Post by: tripredacus on March 23, 2016, 07:16:41 pm
Add [KO] for Korea I'm guessing

It is [KR] for South Korea. I will update the first post.

I dunno, the listing on GameFaqs for South Korean games have it as [KO] They could be wrong though, I have no idea personally.

http://www.gamefaqs.com/ps2/913941-metal-gear-solid-2-sons-of-liberty/images/162774

http://www.gamefaqs.com/ps2/914828-metal-gear-solid-3-snake-eater/images/1179158

Well KR is legit the TLD for Republic of Korea (South Korea) besides, we already use [KR] for Korean releases for some games, like this PS2 category:
http://vgcollect.com/browse/ps2kr

KO is the TLD of Kosovo from OpenNIC/New Nations but has no actual designation in the "official" ccTLD list.

Further reading if interested:
https://en.wikipedia.org/wiki/List_of_Internet_top-level_domains#Country_code_top-level_domains
https://en.wikipedia.org/wiki/OpenNIC#Peering
Title: Re: Release Country TLD Master List
Post by: telly on March 24, 2016, 09:14:21 pm
Hmm, that is interesting!

Now, I'm wondering why Korea has it's own category because the games are NTSC/J. Shouldn't they be put in the JP category with the region coding next to it like the Canadian / European games? Or does it not matter that much?
Title: Re: Release Country TLD Master List
Post by: tripredacus on March 25, 2016, 10:17:29 am
They don't speak Korean in Japan. :)
Title: Re: Release Country TLD Master List
Post by: telly on March 25, 2016, 12:12:46 pm
Touché ;)
Title: Re: Release Country TLD Master List
Post by: telly on April 22, 2016, 09:58:34 pm
Found a game with a listing for [SA] Not sure if it's Saudi Arabia or South America or South Africa or what: I couldn't figure out if it should be added or not, but wanted to mention it here though.

http://www.gamefaqs.com/genesis/563224-mortal-kombat-ii/images/1456033
Title: Re: Release Country TLD Master List
Post by: fazerco on April 23, 2016, 04:46:35 am
Found a game with a listing for [SA] Not sure if it's Saudi Arabia or South America or South Africa or what: I couldn't figure out if it should be added or not, but wanted to mention it here though.

http://www.gamefaqs.com/genesis/563224-mortal-kombat-ii/images/1456033

The language on the box is for South America, and it looks like Brasil.
Title: Re: Release Country TLD Master List
Post by: tripredacus on April 23, 2016, 08:52:02 am
Found a game with a listing for [SA] Not sure if it's Saudi Arabia or South America or South Africa or what: I couldn't figure out if it should be added or not, but wanted to mention it here though.

http://www.gamefaqs.com/genesis/563224-mortal-kombat-ii/images/1456033

The language on the box is for South America, and it looks like Brasil.

Yes that is a Brazil release.
Title: Re: Release Country TLD Master List
Post by: tripredacus on May 16, 2016, 11:44:11 am
Added Turkey [TR ] <--- remove space
Title: Re: Release Country TLD Master List
Post by: telly on July 08, 2016, 07:27:30 am
I see we need [HK] for Hong Kong, there's an NES [HK] category in the database.

EDIT: Though I see that you put Hong Kong merged with the general Asian release of AS. Should the NES category be changed then?

Also, in the browse section it has PC [Asia]; it should probably be [AS]
Title: Re: Release Country TLD Master List
Post by: tripredacus on July 08, 2016, 10:06:27 am
I see we need [HK] for Hong Kong, there's an NES [HK] category in the database.

EDIT: Though I see that you put Hong Kong merged with the general Asian release of AS. Should the NES category be changed then?

Also, in the browse section it has PC [Asia]; it should probably be [AS]

What is the history of those HK released NES games? Were they meant for sale only in Hong Kong? Hong Kong is the typical distribution point for [AS] released games. I believe it was only fairly recently did we know that HK releases of things were meant for general sale in SE Asia. Also, don't forget that Hong Kong was different back in the 80s, they were a part of the UK until 1997.
Title: Re: Release Country TLD Master List
Post by: telly on July 08, 2016, 12:29:44 pm
I could find very little information about Asian-released NES games, but the boxes and cartridges do say "Asian Version." this would indicate to me that it's meant for the general Asian market, and not strictly for Hong Kong. Hong Kong may be the distribution point like you mentioned. In addition, the back of the Kung Fu cart and the manual for Hogan's Alley have both English and Chinese on it.

The question is, is that enough information to make these games actually general Asian releases, and not for only Hong Kong? Here's what I'm thinking:

Either way, since the TLD code sheet we have currently merges HK into AS, then the category should be renamed Nintendo Entertainment System [AS]. If somehow, we were able to find separate releases for only Hong Kong in specific, those games would have [HK] within the AS category.

If I find more information I will update what I think. Mastafafik, you have these games in your collection, do you have any insight into this?

Here are the two games in that category
Kung Fu: http://vgcollect.com/item/63261
Hogan's Alley: http://vgcollect.com/item/90468
Title: Re: Release Country TLD Master List
Post by: telly on July 08, 2016, 12:59:08 pm
Making a different post for an separate topic

I see we have a console with the category code [CH]. That should be added to the master list as well.
Title: Re: Release Country TLD Master List
Post by: tripredacus on July 08, 2016, 07:14:15 pm
[CH] Switzerland has been added.

I would be in favor of having NES [HK] changed to NES [AS].
Title: Re: Release Country TLD Master List
Post by: telly on August 05, 2016, 11:41:33 am
Should we add [IT] for Italy to the list?
Title: Re: Release Country TLD Master List
Post by: tripredacus on August 05, 2016, 06:31:55 pm
Weird, I thought it was there already. Added it.
Title: Re: Release Country TLD Master List
Post by: tripredacus on November 29, 2016, 11:45:07 am
Added [IL] Israel.
Games from Israel should be put into [AS] or Asia categories if one is present.
Title: Re: Release Country TLD Master List
Post by: aexuz on June 03, 2017, 03:20:37 am
Hello, which is the right section to suggest games that are not listed in the data base?
Title: Re: Release Country TLD Master List
Post by: tripredacus on June 05, 2017, 11:56:49 am
You can add missing games yourself. If you need help, you can make a new thread in this section.
Title: Re: Release Country TLD Master List
Post by: metshael on April 09, 2018, 10:57:55 am
I was wondering if instead of the TLD we could use the regional item number to differentiate variant on some case, i know we already use them on the older Nintendo released games (GB/NES/SNES) but would it be accepted on a more recent games (in this case it's a PS1 game) ?

Here is the game that makes me wondering that :

https://vgcollect.com/item/142343

The Acclaimed Range edition for Bust-a-Move 2 (and 4 that i also own) are exactly the same in all the European release (the same front cover and the same exact back cover translated in six different language) except for two things: the barcode and the regional item number just on top of it (BKL20066.78-FAH for that version). Instead of the [FR][NL] i put on that item i would like to ask if the suffix [FAH] could be accepted ?

If someone want to compare them here is a link to the back cover for the ENG (https://i.ebayimg.com/images/g/T4kAAOSwHcpaq9bC/s-l1600.jpg) and the FAH (https://i.imgur.com/Q7wmmLY.jpg) variants.
Title: Re: Release Country TLD Master List
Post by: tripredacus on April 09, 2018, 11:24:52 am
We have this issue with the Nintendo games that will put the Nintendo Country Code in the title, but these are entries made unknowingly or before we put up this thread with the list. Ideally, we would not have the country in the title at all, and have some other way to display this information.

So no, for now it should be [FR][NL]... The only case where that item number would be used is if there was 2 releases to avoid a name collision. For example this happens with Nintendo games in Germany, where you end up with two entries like so:

Game Name (NOE) [DE]
Game Name (NOE-1) [DE]

So no, stick with using TLD on the title for everything... as I have typed in other posts, let's try to keep it simple with some of these things, so we don't need to keep a complicated list of do's and don'ts for certain things.
Title: Re: Release Country TLD Master List
Post by: metshael on April 09, 2018, 11:38:35 am
And that's why i wanted to ask before edit anything  ;), that game bothered me for a while (wondering if i should put a [FAH] suffix directly or not...  ::)). Thanks for the quick answer Tripedacus.
Title: Re: Release Country TLD Master List
Post by: damantisshrimp on July 05, 2018, 04:53:14 pm
Hello!

I just started filling my Game Boy collection and so far so good :)
I have a lot of DMG-xxx-FAH titles, but most of the time, the item number doesn't match.

I see the fomat DMG-xxx-UKV, DMG-P-xxx (I guess for PAL), and duplicate entries with the TLD in the tile.
What is the best way to enter variants? Duplicate entries seems a bit overkill because almost all the fields are the same.

For now I update the item number if it's empty, otherwise I make a small note.
Title: Re: Release Country TLD Master List
Post by: tripredacus on July 06, 2018, 10:17:22 am
FAH is for France/Netherlands [FR][NL]. UKV is for England [UK].

Be aware that entries with no TLD are presumed to be the version that is in English language packaging, so before we would allow an FAH cart to be associated with a non-TLD item, we would need confirmation that no UKV cart exists. Consider entries with no TLD to be English or UK releases. That is why some of your edits were rejected.

There is no region encoding on Game Boy games, so none of them are PAL.

Also item numbers for items are not for the number on the cart, but the number on the box. Put the number from the cart into the description field.
Title: Re: Release Country TLD Master List
Post by: fazerco on July 06, 2018, 12:51:33 pm
Small edit, FAH is France, Belgium, Netherlands (Holland).
Title: Re: Release Country TLD Master List
Post by: tripredacus on July 06, 2018, 01:16:57 pm
Small edit, FAH is France, Belgium, Netherlands (Holland).

Right sorry, we usually put [FR][NL] on FAH. FRA is France.
Here's this list for some more help.
http://www.nanaky.eu/NintendoTriangles.html
Title: Re: Release Country TLD Master List
Post by: kam1kaz3nl77 on September 19, 2018, 06:07:39 pm
Well as a fellow Dutchy (as Fazerco), the whole FAH thing is a little confusing even for me :P

Sometimes it's France, Belgium, Netherlands & Luxembourg <- this last sneaky devil comes in :p

Benelux [BLX] ?? -> sometimes you see that at PC [EU] versions
Title: Re: Release Country TLD Master List
Post by: tripredacus on September 20, 2018, 10:41:08 am
Beneleux has no TLD because it isn't a country, it is a region.

FAH on Nintendo games should just be [FR][NL] as per the Nintendo color triangles list.
Title: Re: Release Country TLD Master List
Post by: leonefamily on March 27, 2019, 08:19:19 pm
What should I do with a "latin north american" release? I have a couple of PS3 games that are trilingual (english + french + spanish) and the game number has a "L" (probably for "Latin") at the end. (example: BLUS-30218L).

There isn't even a mexico TLD so sould I just use [ES]? And do I also have to include [US] or should we omit it since those trilingual versions probably never came out in the usa?

Edit: Also, I have acessories and console boxes that are canadian versions. Should I add [CA] just like I do with canadian games or should we ignore TLDs for accesories/consoles?
Title: Re: Release Country TLD Master List
Post by: tripredacus on March 28, 2019, 09:49:24 am
[ES] is Spain
[MX] is Mexico

If you want to know what TLD a country uses, that is not in this list, just type it into a search engine.

For example, type into google:
mexico tld

it will say .mx. So then for us it is [MX].

Trilingual packaging is common in the US. If you need help to verify the origin of something, feel free to ask.
Title: Re: Release Country TLD Master List
Post by: leonefamily on March 28, 2019, 02:14:48 pm
Thanks. So how should I write it then? "Game Title [CA] [MX] [US]"? or maybe just "Game Title [CA] [MX]"? or any other order?

Edit: Also, I have acessories and console boxes that are canadian versions. Should I add [CA] just like I do with canadian games or should we ignore TLDs for accesories/consoles?
Title: Re: Release Country TLD Master List
Post by: tripredacus on March 29, 2019, 09:51:00 am
As before, TLD is only needed to prevent a duplicate name, or two items having the same name but are different actual things. If the item does not have a duplicate name in an [NA] category, you just put into the description where it was released.

No item should have [CA][MS][US] in the title in [NA] category. Post what it is that you found and we can figure out what it should be called.
Title: Re: Release Country TLD Master List
Post by: leonefamily on March 29, 2019, 10:28:52 am
Alright, I'll just add [Latin] for now, then I'll post all of those games here when it's done and you admins will just have to edit the item names.
Title: Re: Release Country TLD Master List
Post by: tripredacus on March 29, 2019, 12:03:58 pm
Alright, I'll just add [Latin] for now, then I'll post all of those games here when it's done and you admins will just have to edit the item names.

[Latin] is invalid, use [MX] instead.
Title: Re: Release Country TLD Master List
Post by: leonefamily on March 29, 2019, 06:59:01 pm
I meant (Latin). It's really just a placeholder, because anyway those games have a L at the end of the item number, I suppose it means Latin. I disagree with using [MX] for those games, because they are trilingual, and were sold everywhere in north america as you said yourself. Or of you prefer I could just post pictures of those games here in this discussion so we can discuss about what name we give to those versions before I create the database.
Title: Re: Release Country TLD Master List
Post by: kam1kaz3nl77 on March 30, 2019, 10:13:33 am
I've put this game https://vgcollect.com/item/160304 in the Nintendo Switch [CN] category and technically it's a Taiwanese/Hong Kong release. Please check if i did it right with the TLD's ? (just have put a general [AS] behind it
Title: Re: Release Country TLD Master List
Post by: tripredacus on April 01, 2019, 11:00:12 am
I meant (Latin). It's really just a placeholder, because anyway those games have a L at the end of the item number, I suppose it means Latin. I disagree with using [MX] for those games, because they are trilingual, and were sold everywhere in north america as you said yourself. Or of you prefer I could just post pictures of those games here in this discussion so we can discuss about what name we give to those versions before I create the database.

Create a thread and put the pictures into, asking how to name them.
Title: Re: Release Country TLD Master List
Post by: tripredacus on April 01, 2019, 11:02:16 am
I've put this game https://vgcollect.com/item/160304 in the Nintendo Switch [CN] category and technically it's a Taiwanese/Hong Kong release. Please check if i did it right with the TLD's ? (just have put a general [AS] behind it

We should not be using [AS] to represent Asia, because .as is American Samoa!

If it is Taiwan, you can use [TW]
but the art on the entry needs to be fixed. Put the actual back as the back, and we can remove or put the actual cart picture. In the description, what you have is fine already, but you can put the barcode and item numbers from the "under-back" into there. Same as you would do for any game that has a slipcover.
Title: Re: Release Country TLD Master List
Post by: theodw on June 12, 2019, 03:18:35 pm
Create a thread and put the pictures into, asking how to name them.

Related to this question:
I have a bunch of PS3 and PS4 games bought in Chile, with Latin American Spanish packaging and Latin American Spanish dubs, and they're not only available in Mexico. Shouldn't the category be something like [LATAM] or [ES-419] (based on the IETF language tag), since the translations are usually not in Mexican Spanish, but in the "neutral" version made for the whole region?

I know it's a special situation in this case, since it's not something that is available in a single country (like the difference between a [PT] and a [BR ] release).
Title: Re: Release Country TLD Master List
Post by: tripredacus on June 13, 2019, 09:20:42 am
I would need to see some pictures of some, including a back image where I can read any of the fine print.

It can be inferred that any game with Spanish with the ESRB rating is to be Mexico. It does not matter if the game was also sold in another country. The only time we would have an entry for a game like that, but say released in Chile, is if it has an import tag on it. Then the entry should have the import tag visible on one of the photos if at all possible, if not then it would be noted in the description.

If these are games with Spanish and not an ESRB rating (and not sold in Spain) then you can use the [LAT] TLD. If the game has a country specific import label on it, use that country's TLD instead.
Title: Re: Release Country TLD Master List
Post by: theodw on June 13, 2019, 12:16:33 pm
It can be inferred that any game with Spanish with the ESRB rating is to be Mexico.

That's where the issue comes from. Those games are made for the whole of Latin America (Spanish text, ESRB rating.), not only for sale in Mexico (where only an [MX] tag would be valid). My PS4 copy of RDR2 says "Software licensed for play on PS4 consoles sold in Mexico, Central and South America (https://i.imgur.com/J1FGq5v.jpg)" (see text marked up inside the red box), but has an ESRB rating. Similar issue with Spider-Man (https://i.imgur.com/tRbc6hr.jpg). Wouldn't a middle ground be something like [MX][LAT]?

Some Brazilian games (with ClassInd ratings) also come with Spanish texts, but they're sold in the whole region (Like this Fallout: New Vegas: Ultimate Edition (https://articulo.mercadolibre.com.mx/MLM-569190242-videojuego-fallout-new-vegas-ultimate-edition-ps3-sellado-_JM?quantity=1&variation=38158338818), where it says "For sale and distribution in North and South America", in both Spanish and Portuguese, on the back). Should they be classified ad [BR ][LAT] based on that, or [BR ][MX]?
Title: Re: Release Country TLD Master List
Post by: tripredacus on June 17, 2019, 11:06:43 am
As pointed out in other thread, make sure to use actual text on descriptions and not translations.
That Fallout game is  only, as that rating system is for Brazil and not Mexico. If this game was sold in Mexico, it would have an import label or some other distinction.
Title: Re: Release Country TLD Master List
Post by: theodw on June 17, 2019, 11:25:32 am
As pointed out in other thread, make sure to use actual text on descriptions and not translations.
That Fallout game is  only, as that rating system is for Brazil and not Mexico. If this game was sold in Mexico, it would have an import label or some other distinction.

Related to that and the other thread:

Latin America doesn't really have a rating standard. We mostly follow the ESRB rating, because all the games are imported from the US. They can be legally required to include an "imported by" label on the package (like Mexico and Peru) due to consumer law. Some companies make efforts to translate the packaging to the region, but they're not distributed by the companies themselves, but via third parties (like Solutions2Go for Sony and JVLAT for Nintendo)

Y'know? This made me wonder if adding games from Latin America is really worth the time. Gives me the feeling that Mexico is the only market that matters.

EDIT:

Based on the standards, should these entries be removed from the system, since they were not bought in Mexico?

https://vgcollect.com/item/163270
https://vgcollect.com/item/163275
https://vgcollect.com/item/163276
https://vgcollect.com/item/163277
https://vgcollect.com/item/163231
https://vgcollect.com/item/163233
Title: Re: Release Country TLD Master List
Post by: tripredacus on June 17, 2019, 12:09:48 pm
They don't need to be removed, but if they are not Mexico releases then they should be amended.
Title: Re: Release Country TLD Master List
Post by: theodw on June 17, 2019, 12:16:12 pm
They don't need to be removed, but if they are not Mexico releases then they should be amended.

How should they be amended? You mentioned that all games with ESRB rating and Spanish text should be [MX] only, and none of those was bought in MX (And all were official distribution)

(https://vgcollect.com/forum/index.php/topic,7009.msg168111.html#msg168111).
Title: Re: Release Country TLD Master List
Post by: tripredacus on June 17, 2019, 12:26:55 pm
They don't need to be removed, but if they are not Mexico releases then they should be amended.

How should they be amended? You mentioned that all games with ESRB rating and Spanish text should be [MX] only (https://vgcollect.com/forum/index.php/topic,7009.msg168111.html#msg168111).

Be aware that we are tasked with trying to handle everything ever released. Up until you had added a game that fit that criteria but wasn't released in Mexico, that was how we handled it. Because we did not have any users who had games like that, or didn't know what they were. Most users on this site are not interested in documenting specifics about regional releases and are quite happy with just adding "games" into their collections rather than specific items. So I would say less than 1% of our users would fall into this category.

A quote goes "you choose your level of involvement" which means, you have to decide if you want to just add "games" or want to be involved in documenting and researching games in this way and helping us determine the best ways to handle things like this. You can also just give up and we can delete your account, that is up to you, but it seems a bit extreme.

For these specific games, it may be that more research needs to be done before we decide what to do with the entries. There is no harm in them sitting in the db as is until then. Of course, if these are the same as the Spider-Man example, we may want to change [MX] to [AR] for now on those. Perhaps the answer will be to create a new category for these types of releases.

It is good to see that we are reaching into new areas not previously known. We must not really had any users from Central/South America (besides Brazil) that cared about making these entries, or else we would have known about it. So if you want to stick around and help out, it would be great and perhaps we can get more collectors to help out further down the road.
Title: Re: Release Country TLD Master List
Post by: theodw on June 17, 2019, 12:58:42 pm
Regarding that:

Most games are either distributed by JVLAT (http://jvlat.com) (Nintendo, Ubisoft, Activision), CD Distribution (https://cddistribution.com) (Most third parties, including EA and Sega) or Solutions2Go (http://www.solutions2go.ca/home_LATIN.html) (Sony). There are some exceptions, like WB (in Mexico) and Microsoft.

They're released for the region with ESRB ratings, since there is no standard for all the countries, and in some countries they're required to put a "distributed by" label on top of the foil, due to local consumer laws (like Mexico and Peru).

There are some odd exceptions, like that ClassInd FO:NV mentioned before. I remember once having a Fallout 3: GOTY that included two covers in it: One in English and Spanish, with ESRB ratings, and one in Portuguese (Brazil) with a ClassInd rating, so it can be a hodgepodge of standards.

EDIT: This is the "warranty card" (https://i.imgur.com/qJC5scc.jpg) (actually printed on the back of the cover) for the Spider-Man I have.
Title: Re: Release Country TLD Master List
Post by: telly on July 14, 2020, 10:01:50 am
[MX] needs to be added
Title: Re: Release Country TLD Master List
Post by: tripredacus on July 14, 2020, 10:25:30 am
Added.
Title: Re: Release Country TLD Master List
Post by: lio89 on September 16, 2020, 10:03:11 am
after getting a PM from tripredacus and long reading, I though about the case of FR-NL box text games with not the red "attention" should be more [BE] games then?

additional question : is there are Dutch members here? if yes : do you have games with 100% dutch text box, or are they all FR-BE?
Title: Re: Release Country TLD Master List
Post by: fazerco on September 16, 2020, 10:38:08 am
Yes and yes. of ja en ja dus.
Title: Re: Release Country TLD Master List
Post by: lio89 on September 16, 2020, 11:34:15 am
Thanks for your answer, then, for those games, [BE] should be the right one if you have 100% dutch games, or [BE][NL] as those game can also be sold in the nederland?

Dankejewel voor your answer :)
Title: Re: Release Country TLD Master List
Post by: fazerco on September 16, 2020, 01:00:44 pm
Now its NO.

There are some dutch boxed games, as there are french boxed games.

But there are also the dutch/france boxed games. Those are NOT the same games as the only dutch boxed games.
Title: Re: Release Country TLD Master List
Post by: tripredacus on September 16, 2020, 01:25:40 pm
It is important to look at each individual item as its own thing. There is no blanket way to look at a game and say "they are all like this" because we can always find instances where they are not.

I always have said that if you are working on an item in the db and are not sure, just ask someone. Maybe someone in that country the thing is from, or where you think it is from. Or ask into the forums. We have people from all over the world and have a better understanding of the market in which they live in. It never hurts to ask. And as I put before, it is better we put in the correct info than to guess and get something wrong. It happened a lot on this site for many years, where entries evolved into "frankenstein" games, containing a mismash of correct and incorrect info.
Title: Re: Release Country TLD Master List
Post by: tripredacus on December 03, 2020, 10:49:31 am
Quote
Hmmm. I think I'd like to suggest a conversation about that then.  Using [CN] to cover all of SEA doesn't seem like the right way to go.  ISO 3166-1 alpha-2 provides a series of alpha-2 codes that can be user assigned and the ISO 3166/MA will never use the codes in updating process of the standard.  I'd like to put forward the suggestion of using something like AA or XA for SEA categories.  Merge Switch[TW] and Switch[CN] into Switch[XA] and use TLDs like the [EU] categories or further split the Switch categories into Switch[HK], Switch[SG], Switch[TW], and leave Switch[CN] for the Chinese region locked releases.

from: https://vgcollect.com/forum/index.php/topic,10555.msg185056.html#msg185056

As I had put into the TLD post in the Advanced Guide, we are using ccTLD, but that actually corresponds to ISO 3166-1 alpha-2. If we are to fully adhere to this standard, we would be able to select from these:

AA, QM-QZ, XA-XZ and ZZ.

To represent South East Asia, or even perhaps all of Asia and allow India, Turkey, Saudi Arabia and Israel into there... Or perhaps we can just use XA to be Eastern Hemisphere that isn't Europe so that South Africa could also have a place to go.

Then we can change all [CN] cats to [XA] and move the South African items out of the [EU] categories where they exist.

BUT that then leaves us with the issue of the elephant in the room: NA

There is nothing in this ISO that has a representation for North America. It only has US, CA and MX. Would we then use something like XN to replace NA, or change all NA into US? And what would be used for South America?

As it stands currently, we use ccTLD as reference and not adhere to any specific ISO. Having to deal with ISO IRL, I know that we cannot just use part of it, but I also understand we are just using it for reference and are not seeking to become ISO certfied. But I would rather not say exactly that we are following any particular ISO standard while there are still those outliers like those stated above.
Title: Re: Release Country TLD Master List
Post by: ignition365 on December 03, 2020, 11:00:41 am
Yeah.  I would say if we are going to keep NA for North America (which according to ccTLD is Namibia), then there is no reason we can't use [AS] for Asia.

Personally, I think the use of NA and AS will be less confusing for users, but I'm not opposed to using user-defined codes.

For instance, I'm fine with not adhering to the ISO 3166-1 alpha-2 and using NA (North America), EU (Europe), AS (Asia), SA (South America), AF (Africa), etc and use short hands for continents.  Then under each continent region, use the TLD codes for releases in countries like we do in the [EU] categories.  NA where [US] releases don't require TLD, EU where [UK] releases don't require TLD, and I guess AS where [CN] wouldn't require TLD.  I don't know what the prevalent TLD would be for AS, it's also hard to tell which countries some of the games are from.

I'm also fine with us doing something like [XA] for Asia, [XE] for Europe, [XN] for North America, and [XS] for South America. But then you have the issue of what is Africa [XF]?  Maybe scrap logic and just go ordered by use [XA] for NA, [XB] for EU, [XC] for AS, [XD] for SA, [XE] for AF, and so on?

I don't necessarily see a need to use ccTLD for categories, but using ccTLD for individual entries does make sense.  If our categories serve to represent continents rather than countries, it wouldn't be necessary for it to follow the ISO, because it's not relevant.

Edit:  Hmmmm, but that makes JP as a region a wrench in the works, because it would be categorized under [AS] wouldn't it.
Title: Re: Release Country TLD Master List
Post by: tripredacus on December 03, 2020, 11:20:56 am
No I think that using XX for regions, especially to replace EU and NA would be a nightmare for our users and that is one reason why I wouldn't even want to implement it. We did have [AS] in use here but after changing to use ccTLD officially I already worked with admins to take the first step of getting rid of [AS] wherever possible. That next step of dealing with [NA] just never happened. The ideal step would be to change [NA] to [US] and then treat US like we currently do with CN. Whereas all "NA" items that are not in US go into US but use a TLD. It wouldn't change anything with those items already, because nearly all CA and MX entries are already named properly. That being said, I don't want to change EU to anything else.

If you look at the first post here, you can see I made a separation between regions and countries. I think this would give us the ability to use something else to determine region codes. Perhaps we can find some sort of existing standard that lets us use NA and EU, then see what they have for SEA but be careful to not overlap anything a country would use.

Also, I wouldn't worry about Africa that much. The only country that has regional releases that I am aware of is South Africa, and outside of the Sega Mega Drive entries, there are very few currently in the database in the other categories.
Title: Re: Release Country TLD Master List
Post by: telly on December 03, 2020, 11:24:10 am
Yeah.  I would say if we are going to keep NA for North America (which according to ccTLD is Namibia), then there is no reason we can't use [AS] for Asia.

Personally, I think the use of NA and AS will be less confusing for users, but I'm not opposed to using user-defined codes.

For instance, I'm fine with not adhering to the ISO 3166-1 alpha-2 and using NA (North America), EU (Europe), AS (Asia), SA (South America), AF (Africa), etc and use short hands for continents.  Then under each continent region, use the TLD codes for releases in countries like we do in the [EU] categories.  NA where [US] releases don't require TLD, EU where [UK] releases don't require TLD, and I guess AS where [CN] wouldn't require TLD.  I don't know what the prevalent TLD would be for AS, it's also hard to tell which countries some of the games are from.

I'm also fine with us doing something like [XA] for Asia, [XE] for Europe, [XN] for North America, and [XS] for South America. But then you have the issue of what is Africa [XF]?  Maybe scrap logic and just go ordered by use [XA] for NA, [XB] for EU, [XC] for AS, [XD] for SA, [XE] for AF, and so on?

I don't necessarily see a need to use ccTLD for categories, but using ccTLD for individual entries does make sense.  If our categories serve to represent continents rather than countries, it wouldn't be necessary for it to follow the ISO, because it's not relevant.

Even CN has been confused for Canada by some of our users. But even so, I'm in favor of the option that is easiest for users to navigate, so I would rather keep our use of NA, EU, and so on, for usability rather than stick to a regimented system that sacrifices usability only for the sake of being consistent with ISO. I just don't see what we really gain from doing that, because in either case we're grouping continents by our own arbitrary naming system.

I just don't see the problem with using AS for Asia. Are we ever going to get a game that would use that TLD (i.e. being released in American Samoa and nowhere else)? Especially when it's a US territory to begin with?

Personally I think it's MORE confusing to say that our main NA category is US, but all our CA and MX games are also part of that category even though they weren't released in the US.
Title: Re: Release Country TLD Master List
Post by: ignition365 on December 03, 2020, 11:38:10 am
Yeah.  I would say if we are going to keep NA for North America (which according to ccTLD is Namibia), then there is no reason we can't use [AS] for Asia.

Personally, I think the use of NA and AS will be less confusing for users, but I'm not opposed to using user-defined codes.

For instance, I'm fine with not adhering to the ISO 3166-1 alpha-2 and using NA (North America), EU (Europe), AS (Asia), SA (South America), AF (Africa), etc and use short hands for continents.  Then under each continent region, use the TLD codes for releases in countries like we do in the [EU] categories.  NA where [US] releases don't require TLD, EU where [UK] releases don't require TLD, and I guess AS where [CN] wouldn't require TLD.  I don't know what the prevalent TLD would be for AS, it's also hard to tell which countries some of the games are from.

I'm also fine with us doing something like [XA] for Asia, [XE] for Europe, [XN] for North America, and [XS] for South America. But then you have the issue of what is Africa [XF]?  Maybe scrap logic and just go ordered by use [XA] for NA, [XB] for EU, [XC] for AS, [XD] for SA, [XE] for AF, and so on?

I don't necessarily see a need to use ccTLD for categories, but using ccTLD for individual entries does make sense.  If our categories serve to represent continents rather than countries, it wouldn't be necessary for it to follow the ISO, because it's not relevant.

Even CN has been confused for Canada by some of our users. But even so, I'm in favor of the option that is easiest for users to navigate, so I would rather keep our use of NA, EU, and so on, for usability rather than stick to a regimented system that sacrifices usability only for the sake of being consistent with ISO. I just don't see what we really gain from doing that, because in either case we're grouping continents by our own arbitrary naming system.

I just don't see the problem with using AS for Asia. Are we ever going to get a game that would use that TLD (i.e. being released in American Samoa and nowhere else)? Especially when it's a US territory to begin with?

Personally I think it's MORE confusing to say that our main NA category is US, but all our CA and MX games are also part of that category even though they weren't released in the US.
Strong Agree.

I vote NA, EU, JP, and AS.  Again, I just don't know what the prevalent country would be for AS.  Maybe leave ccTLD out if you don't know the specific country, so TW games can be easily identified by the GSRR ratings, a lot of Nintendo releases have colored triangles that detail what country the release is for, etc.
Title: Re: Release Country TLD Master List
Post by: tripredacus on December 03, 2020, 11:55:20 am
China was chosen as the prevalent country to represent Asia (or SEA not Japan or Korea) because Hong Kong has been part of China since 1997. You notice there are HK categories present, but they should only represent games prior to that.

I will look into creating a user poll for us to vote on which direction to move in.

Title: Re: Release Country TLD Master List
Post by: telly on December 03, 2020, 12:07:06 pm
Well here's another thought. If we DID want to make things more consistent, we could combine Japan, Korea, Taiwan, China and Hong Kong into a broad AS category so we don't have a combination of countries and continents making up our large categories like we have now. And Japan would be the country treated as the default like US is for the North American category and UK is for the Europe category.

It would be a lot of work, and I'm not sure if that would improve the database at all, but it's a thought.
Title: Re: Release Country TLD Master List
Post by: dhaabi on December 03, 2020, 12:24:49 pm
Well here's another thought. If we DID want to make things more consistent, we could combine Japan, Korea, Taiwan, China and Hong Kong into a broad AS category so we don't have a combination of countries and continents making up our large categories like we have now. And Japan would be the country treated as the default like US is for the North American category and UK is for the Europe category.

Personally, I wouldn't like to see a broad AS category for these regions. The EU categories already are far cluttered enough, so navigating through another seems irritating. I'd rather categories be as specific as possible, given that there are a suitable amount of releases in each region to warrant a specific sub-category.

On the topic of Canada, it seems as if many categories—at least for more modern consoles—have enough specific entries to warrant a category for Canadian releases to be on their own, apart from US releases. Although, that still wouldn't solve the greater issue at hand about how to handle the current NA category, as MX entries do exist there as well, albeit they are few and far between.
Title: Re: Release Country TLD Master List
Post by: leonefamily on July 31, 2021, 08:19:45 pm
Just stumbled upon a copy of MX vs. ATV Unleashed for the PS2. It's PAL release with French and German text, so usually I would have considered that to be a Switzerland release. However it has a USK rating on the box. The game itself was sent from Austria, literally between Germany and Switzerland. What TLD should I give this item?
Title: Re: Release Country TLD Master List
Post by: tripredacus on August 02, 2021, 10:01:59 am
Can you post some information such as the barcode and/or a picture of the back?
Title: Re: Release Country TLD Master List
Post by: leonefamily on August 02, 2021, 10:21:48 am
Can you post some information such as the barcode and/or a picture of the back?

I'll send you a pm later tonight
Title: Re: Release Country TLD Master List
Post by: nathan776 on January 12, 2022, 12:43:26 am
[HU] Hungary seems to be missing from the list.
Title: Re: Release Country TLD Master List
Post by: tripredacus on January 12, 2022, 09:52:50 am
Added [HU] and all of the other missing TLDs based on the INTL Classifieds list
https://vgcollect.com/forum/index.php/topic,11439.0.html
Title: Re: Release Country TLD Master List
Post by: dhaabi on September 06, 2022, 01:58:33 pm
I know why it's been omitted from the list thus far, but [US] is used in non-game categories such as with accessories and hardware.
Title: Re: Release Country TLD Master List
Post by: tripredacus on September 07, 2022, 10:08:21 am
It is added.
Title: Re: Release Country TLD Master List
Post by: leonefamily on March 13, 2023, 09:16:58 pm
Not sure under which TLD to put this. Has PEGI rating and text in English, French, Portuguese and Arabic. I found that in the Philippines but that's clearly not a Philippines release (games here are usually "english asia" versions).

https://i.imgur.com/sWGPqm1.jpg
Title: Re: Release Country TLD Master List
Post by: dhaabi on March 14, 2023, 09:39:48 am
Not sure under which TLD to put this. Has PEGI rating and text in English, French, Portuguese and Arabic. I found that in the Philippines but that's clearly not a Philippines release (games here are usually "english asia" versions).

https://i.imgur.com/sWGPqm1.jpg

Many of the other yellow dot releases (https://vgcollect.com/search/advanced/no-filter/%22%28yellow%20dot%29%22/no-filter/ALL/ALL/ALL/ALL/ALL/no-filter/no-filter/no-filter) already with database entries are simply given a (yellow dot) descriptor. I've typically seen them on African and Middle Eastern online storefronts, but I wouldn't say there is a clear way of determining which countries exactly they were sold in. I've even seen some games have two yellow dot versions.
Title: Re: Release Country TLD Master List
Post by: leonefamily on March 14, 2023, 09:08:56 pm
Alright thanks! I'll list it as "Driveclub (yellow dot)" under "PS4 [EU]"