You can just show the user the transliteration & have them confirm it makes sense. Always store the original version since you can't reverse the process. But you can compare the transliterated version to make sure it matches.
Debit cards a pretty common example of this. I believe you can only have ASCII in the cardholder name field.
>But you can compare the transliterated version to make sure it matches
No you can't.
Add: Okay, you need to know why. I'm right here a living breathing person with a government id that has the same name scribed in two scripts side by side.
There is an algorithm (blessed by the same government that issued said it) which defines how to transliterate names from one to another, published on the parliament web site and implement in all the places that are involved in the id issuing business.
The algorithm will however not produce the outcome you will see on my id, because me, living breathing person who has a name asked nicely to spell it the way I like. The next time I visit the id issuing place, I could forget to ask nicely and then I will have two valid ids (no, the old one will not be marked as void!) with three names that don't exactly match. It's all perfectly fine, because name as a legal concept is defined in the character set you probably can't read anyway.
Your example fails to explain any problem with GPs proposal. They would show you a transliteration of your name and ask you to confirm it. You would confirm it or not. It might match one or other of your IDs (in which case you would presumably say yes) or not (in which case you would presumably say no). What's the issue?
You will compare the transliterated version I provided with the one you have already, it will not match and then what? Either you tell me I have invalid name or you just ignore it.
I think they were suggesting the opposite order - do an automatic transliteration and offer you the choice to approve or correct it.
But even if the user is entering both, warning them that the transliteration doesn't match and letting them continue if they want is something that pays for itself in support costs.
I have an ID that transliterated my name, and included the original, but the original contained an obvious typo. I immediately notified the government official, but they refused to fix it. They assured me that only the transliterated name would be used.
Human systems aren't always interested in avoiding or fixing defects.
Not just young women, but older people too (~64%). Seems hard to believe they literally think it's hell, without serious societal breakdown. Are immigration and suicide sky high?
> South Korea has the fourth highest suicide rate in the world and the highest among OECD countries. The elderly in South Korea are at the highest risk of suicide, but deaths from teen suicide have been rising since 2010. In 2022 suicide caused more than half of all deaths among South Koreans in their twenties. It is the leading cause of death for those between the age of 10 and 39, in line with most OECD countries.
Shouldn't it be even higher if you think your country is literally hell? Maybe they have a more optimistic idea of hell than me. I guess that squares with 3% more believing it's hell than wants to leave.
I still think this survey doesn't make sense, or at least something is lost in transactional.
A 2021 study further found that one in three Korean women have experienced domestic violence, with intimate partners responsible for 46 percent of these cases.
The actual wealth in an economy is the value of goods and services. Money is not a good or a service. Increasing the amount of money does not change the value of goods and services, it just devalues the money (inflation).
That sounds like the pg stats are messed up somehow. Try running explain analyze foo to see if it changes things.
Postgres doesn’t automatically create indexes - I bet the others have some implicit index on organization_id, created_at. Otherwise they would be giving bad results in other cases. I don’t see why you can’t just make that index in postgres.
It's a neat idea, but I think you need some automation to make it useful over a long period of time. There's a website to do track gas prices, and they just change too much to keep updated.
How can the fed both cause inflation and high housing costs? Raising interest rates like they have been doing should lower inflation but make housing more expensive.
Debit cards a pretty common example of this. I believe you can only have ASCII in the cardholder name field.
reply