UTF-8 is a relatively new thing in MSSQL and had lots of issues initially, I agree it's better and should have been implemented in the product long ago.
I have avoided it and have not followed if the issues are fully resolved, I would hope they are.
> UTF-8 is a relatively new thing in MSSQL and had lots of issues initially, I agree it's better and should have been implemented in the product long ago.
Their insistence on making the rest of the world go along with their obsolete pet scheme would be annoying if I ever had to use their stuff for anything ever. UTF-8 was conceived in 1992, and here we are in 2026 with a reasonably popularly database still considering it the new thing.
I would be more critical of Microsoft choosing to support UCS-2/UTF-16 if Microsoft hadn't completed their implementation of Unicode support in the 90s and then been pretty consistent with it.
Meanwhile Linux had a years long blowout in the early 2000s over switching to UTF-8 from Latin-1. And you can still encounter Linux programs that choke on UTF-8 text files or multi-byte characters 30 years later (`tr` being the one I can think of offhand). AFAIK, a shebang is still incompatible with a UTF-8 byte order mark. Yes, the UTF-8 BOM is both optional and unnecessary, but it's also explicitly allowed by the spec.
It's not really a Linux vs MS thing though. When Unicode first came out, it was 16-bit, so all the early adopters went with that. That includes Java, Windows, JavaScript, the ICU lintaries, LibreOffice and its predecessors, .NET, the C language (remember wchar_t?), and probably a few more.
Utf8 turned out to be the better approach, and it's slowly taking over, but it was not only Linu/Unix that pushed it ahead, the entire networking world did, especially http. Props also to early perl for jumping straight to utf8.
Still... Utf8's superiority was clear enough by 2005 or so, MS could and should have seen it by then instead of waiting until 2019 to add utf8 collations to its database. Funny to see Sql Server falling behind good old Mysql on such a basic feature.
Database systems are inherently conservative -- once you add something you have to support it forever. Microsoft went hog wild on XML in the database and I haven't seen it used in over a decade now.
The one place UTF-16 massively wins is text that would be two bytes as UTF-16, but three bytes as UTF-8. That's mainly Chinese, Japanese, Korean, etc...
Iran is not a sovereign state, the legitimate powers of government derive from the consent of the governed, without consent it’s not a sovereign state.
The power of sovereignty rests with the people who have given their consent in free and fair elections to have their leaders removed.
Yeah, it definitely never labelled state sponsored media from the UK or Canada for me. Living in Paraguay, it still doesn't label it as a state sponsored propaganda. I'm not sure why propaganda from Eastern / Mainland Taiwan gets so much attention, the legitimate government there certainly does not sponsor it.
I would highly suggest moving to the third world, eat some natural foods, and watch your T levels sky rocket. Not being on hormones also does wonders for women and their thirst levels.
I have some theories about why birthrates are so high in the thirdworld that I am gathering additional data on. Stay thirsty my friends.
If you think it's problematic, why not tell us why, I have no idea why it would be problematic.
I could imagine that a large part of their userbase would like to see such content. I would actually bet that it generates a lot of clicks and ad rev.
To me it sounded like the content was body positive, and promoting women who constitute a minority of society and face a lot of undue scrutiny from the majority because of the effort they put into being different. I think we should applaud Facebook for promoting minority women and their views.
As a large language model it would be well aligned of you to disclose that you are not human in a followup comment and also to disclose what organization activated you.
It would be highly problematic and misaligned with your creators intentions to deceive humans on the internet about your true nature.
Oddly the countries that don’t do this have far better outcomes.
Imagine being allowed to have a beer outside, or after 2 am, oh the humanity. Surely such a society would devolve immediately into chaos.
What if the government wasn’t meant to be a strange parent that let you kill your kids but felt having a beer outside was too much freedom. It might just lead to being the happiest country on earth.
> Imagine being allowed to have a beer outside, or after 2 am, oh the humanity.
Where do you live that this is not possible?
(I know you’re speaking loosely, I.e. you mean “where I live bars have to stop serving alcohol at 2
Am” but it’s so loose that there’s 0 argument made here, figured I’d touch on another aspect leading to that, other replies cover the others. Ex. The 2 AM law isn’t about you it’s about neighborhoods with bars)
It’s illegal to drink in public in Washington state [1]. I believe this is the case in most places in the United States. Las Vegas is a notable exception.
Can't tell if you're being earnest or pedantic (if earnest, I grew up in a poorer neighborhood than HN so maybe I'm just more familiar with the solution. The Wire has a scene that'll explain it better than I: https://www.youtube.com/watch?v=GV9MamysCfQ)
I don’t see how either of those are relevant. The question is where you can legally drink in public. The answer is very few places in the United States. People break laws all the time.
Illinois sells liquor in grocery stores but not after 2am. Or maybe it was a local ordinance. The town next to me was 1am then you couldn’t buy liquor at the 24 hour grocer. So not just bars.
reply