Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I think there are really two separate issues at play here. Language and country. They most definitely are not the same thing. The HTTP spec explicitly defines the Accept-Language request-header field as <em>language</em> specifier, not a country specifier.</p> <p>For example: en-US refers to a specific language (the version of English spoken mostly in the United States), en-GB refers to another language (the version of English spoken mostly in the United Kingdom). This really has nothing to do with where you currently are in the world, it just defines what language is most acceptable to you when viewing a website. And that <strong>should</strong> be respected because even novice users should have a browser in their language which will by default send the correct request-header field.</p> <p>But that's not what sites traditionally use it as. Like another poster, I've noticed that sites equate language with country and tailor their site to that country's unique <strong>political</strong> restrictions/freedoms/the company's offerings there, not necessarily for the <strong>language</strong>. The example given was a company that doesn't sell a particular product in a particular country but does in others.</p> <p>In the case of what products to display for different countries, geolocating the IP address would be better than making decisions based off the language but it still wouldn't be perfect. What if I'm in another country temporarily but want to order something and have it delivered back home? What if my IP address doesn't reflect where I physically am, it's not perfect?</p> <p>Yes, things work correctly for most people most of the time. But why on Earth would you make it hard for people to get the site in the language that they ask for?? It's just bad UI design.</p>
    singulars
    1. This table or related slice is empty.
    1. POHow should sites (Google and/or you) treat Accept-Language header?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. UScolithium
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow should sites (Google and/or you) treat Accept-Language header?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWell, if I didn't agree with you from the start I wouldn't post the question.
      singulars
      1. PO
      1. USilya n.
    2. COWell the question was what would I do, I thought my answer made it clear that it always makes sense to honor the Accept-Language field and don't redirect based off of geocoding. I mean of course if they ask for the Spanish language version of the site give it to them, but don't redirect them there based off of IP. And definitely don't make language choice hard to find if you do.
      singulars
      1. PO
      1. UScolithium
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload