as written it should be pronounced

shw-meth-quey-em-ass-em

where the shw is throaty - is it different because of the language?

But also: databases shouldn't forbid uncommon unicode letters if it isn't called for.

I stumble across this issue quite often. When you fill out a form for US customs, you are both required to provide exact data and you are only allowed a-z, 0-9, and some punctuation. That you cannot fulfil both because they are mutually exclusive does not cross their blessed little minds.

More than three syllables, too complicated for the average American.

w isn't even a real letter

are you thinking because of the use of IPA characters? because those have defined sounds only within the IPA.

Is this not IPA? I thought the article said it was

it's the alphabet the BC first nations use. it uses similar characters but not with ipa pronunciations.

TIL - thanks

Putting it in a DB is the easy part.

It’s support in a thousand other systems that deal with addresses that’s the real problem.

For something like a street address, interoperability is a hell of a lot more important than culturally preferred spelling.

Anglo-Saxon? Lmao what a bizarre way to talk. Not that it even makes sense considering Anglo-Saxon settlers in the US weren't even close to being the majority.

It's down to unicode support. Not a plot from "Anglo-Saxons" to keep others in their place lol

To be fair, not considering unicode support a priority is a pretty damn English-language-centric attitude.

So... what Seattle does in the International District is this:

Street names are written in both English, and... Mandarin, Japanese, Vietnamese.

Sometimes its two different signs, sometimes its one big sign.

I... don't really see how just putting a sign that writes it out in both languages... is not a reasonable solution to this scenario?

But that doesn't really even appear to be the main issue going on here.

...

As a person who has maintained large databases... yeah, it is... possible to implement support for nonstandard characters... but you would have to very, very directly legally require this specific level of support, and probably have a lot of lead time.

Not saying its morally right or justifiable, but the industry standard is almost always to just support the very basic, bare minimum of charsets... and then everything is built on top of that assumption, and the actual core setup configs at that level haven't been touched in 20+ years, and probably there's only 2 people at the entire org that even know... that such things exist, or what actual physical server they are running on.

It can be a bitch and a half to fundamentally rework an entire database system to support and uncommon character set, usually security minded practices will have you scrubbing out or charswapping or banning anything that isn't standard... and if there is any link in the chain, at any point, that doesn't properly support your new charset, well, it all blows up.

So... that is everything from front end to backend that has to come up with a solution, and the reality is, for just most of such modern software systems... that means you're going through god knows how many vendors and liscensed software, and now they all have to be compliant as well, in more or less exactly the same way.

Anyway, NAPA does exist in at least comprehensive character standards:

https://www.iana.org/assignments/language-subtag-registry/language-subtag-registry

Type: variant

Subtag: fonnapa

Description: North American Phonetic Alphabet

Description: Americanist Phonetic Notation

Added: 2016-06-24

So it should be theoretically possible.

...

Another... weird aspect to this is... NAPA is not like the actual written characters that the Musqueam, or any other Peoples of the Salish Sea... actually ever used, historically.

It is a modern, academic alphabet, similar to IPA, primarily developed out of trying to basically reverse engineer almost entirely oral, spoken languages.

It is not something any of them ever historically used as a written character set, outside of modern academia and modern attempts to revive various languages of various peoples, to encourage their use and prevent the languages from going extinct.

Similar to NAPA is Saanich, or SENĆOŦEN, or Sənčáθən.

Saanich dialect - Wikipedia

(en.m.wikipedia.org)

This writing system is used by the some of the Saanich peoples, academics and modern language revival movements... very roughly speaking, the Saanich peoples/languages are a subset of the broader group of Salish peoples/languages

...

Another problem with this realm is that... there is no 100% respected as an authority standard on how exactly to use or implement exactly which characters in NAPA to represent exactly which sounds... so... different specific Peoples, Tribes, Academics, etc, may be using different characters within NAPA for the same sound.

Its all very confusing from the standpoint of a database / data entry software dev trying to figure out how to actually implement this.

Signposts on the Vancouver street bear the English name below the official Musqueam name, which is written in the North American Phonetic Alphabet.

I don't see the issue here.

Arguably. Or it's just what the dev team was used to. Or a bunch of other explanations.

I just don't find "a historic Germanic group of settlers that immigrated to medieval Britain are purposely neglecting unicode support as a means to suppress people that aren't part of their group."

Going through their post history, they seem obsessed with the "Anglo Saxons".

Just a bizarre conspiracy theory from a one day old account that's also advocating for genociding everyone in the middle east lol

I love how they put up the English name after the first outcry of "where do I send the ambulance again" fears.