Database misstep
-
@BernieTheBernie said in Database misstep:
STD
-
In germany, you must not have a vanity plate which somehow encodes Nazi symbols. That might get you in trouble.
At the car registration office:
E.g.AH 88
stands forAdolf Hitler Heil Hitler
.
I'd like vanity numberAH 88
!
OK, That'sAH
forAnal Homoerotics
, and the88
is a symbol for mutual contact of testicles.
You are very courageous!
-
@BernieTheBernie no, no, to chastise violent nativists you need a Superman.
-
@BernieTheBernie said in Database misstep:
@Gurth said in Database misstep:
amuse yourself by reading German plates
Well, might be. Because they're German, not Dutch or English.
So, when your car was registered in Stade county, the number will start withSTD
.
And some one in Neuss (NE
) might receiveUK
after the-
(Dutchneuk
meansfuck
). And yes, in FĂźrth (FĂ
), you can getCK
-fĂźck
is not at all English, is it?One actual example I remember offhand is
VIE-H
, which I found funny on a normal car. Iâve also seen more than one withAC-DC
and several others whose combinations I donât remember that made me at least smile.
-
@Gurth Some people in Stuttgart (
S
) enjoyEX
(does not need translation, I guess) orAU
(Sau = pig). In Limburg (LM
),AA
is not uncommon (LmaA
is short forLeck mich am Arsch
=Lick my ass
)...
-
Oh yeah, I found this one funny too:
Duwen /ËdyĘÉ(n)/, which like most Dutch verbs is often pronounced without the /n/, is the infinitive and imperative of âto pushâ.
-
@Vault_Dweller said in Database misstep:
@Steve_The_Cynic said in Database misstep:
"the best custom plate I ever saw"Some pictures I've taken while on the road:
-
@BernieTheBernie and Hungarian license plays have 3 letteres followed by 3 numbers. They very recently switched to 4 letters so you should be able to find every TLA somewhere in the country
-
@BernieTheBernie said in Database misstep:
@Gurth said in Database misstep:
amuse yourself by reading German plates
Well, might be. Because they're German, not Dutch or English.
So, when your car was registered in Stade county, the number will start withSTD
.
And some one in Neuss (NE
) might receiveUK
after the-
(Dutchneuk
meansfuck
). And yes, in FĂźrth (FĂ
), you can getCK
-fĂźck
is not at all English, is it?The (very) old Czech scheme had three letters and four digits, with the first two letters determined by the district. The district of PĹerov, which had
PR
, skipped lettersC
andD
in the third position, because âprcâ ~ (one) fuck, and âprdâ = fart.
-
@Bulb Thatâs what you get for having a spelling that decides it can do without vowels in a lot of words :) Dutch canât, which is why it was decided to not have vowels on licence plates when the point was reached at which they would have sequences of four letters.š Even before then, certain combinations of letters were not used, either because of connotations with the Second World War (
SA
,SD
andSS
) or because they were common abbreviations for then-current political parties.š Netherlands plates used to have blocks of two letters and blocks of two digits in various combinations â
LL-DD-DD
,LL-DD-LL
, etc., changing their order when the possible combinations of the current sequence were exhausted. Of course, that means at some point you get toLL-LL-DD
. After that, it went to a combination of one-digit block, two-digit block and three-letter block, which can make rude words in Dutch. Few people would want to have, say,1-LUL-23
on their car, I think.
-
@Arantor Or just dont...
How about just using a UUID typed "oID" for your own database with a surrogate key for VIN.
This way, if your business decides to pivot into the automotive re-birthing industry, the majority of the schema can remain in tact. You just need to add a new table for VINs, then add an FK constraint on your VIN field. If you're really thorough, rename VIN to be CURRENT_VIN, and you've addressed all the requirements of even the most "agile" business decisions.
-
@Arantor - NO, use a GUID as your primary key and key the VEHICLE_VIN_IDENTIFICATION_NUMBER_ID only in an auxiliary lookup.
update: Noticed that caffiend posted similar concept before I did... (darn failure to refresh local caches!)
-
-
@TheCPUWizard said in Database misstep:
update: Noticed that caffiend posted similar concept before I did... (darn failure to refresh local caches!)
No harm done, good database design stands on it's own.
I was mainly trying to help people keep the "Enterprise" in "Criminal Enterprise"
-
-
@Bulb said in Database misstep:
@BernieTheBernie said in Database misstep:
@Gurth said in Database misstep:
amuse yourself by reading German plates
Well, might be. Because they're German, not Dutch or English.
So, when your car was registered in Stade county, the number will start withSTD
.
And some one in Neuss (NE
) might receiveUK
after the-
(Dutchneuk
meansfuck
). And yes, in FĂźrth (FĂ
), you can getCK
-fĂźck
is not at all English, is it?The (very) old Czech scheme had three letters and four digits, with the first two letters determined by the district. The district of PĹerov, which had
PR
, skipped lettersC
andD
in the third position, because âprcâ ~ (one) fuck, and âprdâ = fart.Oddly enough, the district of Strakonice skipped the STB (https://en.wikipedia.org/wiki/StB) and went straight to STC. STD can still be met on the roads (drive carefully!)
-
@BernieTheBernie said in Database misstep:
@Gurth said in Database misstep:
amuse yourself by reading German plates
Well, might be. Because they're German, not Dutch or English.
So, when your car was registered in Stade county, the number will start withSTD
.
And some one in Neuss (NE
) might receiveUK
after the-
(Dutchneuk
meansfuck
). And yes, in FĂźrth (FĂ
), you can getCK
-fĂźck
is not at all English, is it?This one that I came across today is right up your alley:
A few minutes earlier, I noticed this one which is slightly more family-friendly:
Though only if itâs not a family picknick, I suppose.
And as if thatâs not enough, on the same trip I spotted one that had
F-UN
plus some numbers, but couldnât take a picture of it.
-
@Gurth I'm still waiting for the
W-TF 123
plate to show up.
-
@dkf I have actually seen one of those in my area not that long ago, but again, had no opportunity for taking a photo.
-
I've seen a license plate 11-UM-11.
-
@dkf said in Database misstep:
@Gurth I'm still waiting for the
W-TF 123
plate to show up.Ok, I googled it... There's a bunch.
-
@dcon Yes, but I was hoping for one from Wuppertal.
-
In Ontario, we have
AAAA-111
format plate numbers. They're mostly sequential, but they officially exclude some alphabetic characters:G
,I
,O
,Q
andU
. But anecdotally, I think there are some sequences that aren't used. We're at the end of the C range now, and I've never seenCRAP
, even though all those letters are commonly used. Sequences with WTF may be in the same situation.You can also get custom plates (with some restrictions), and keep them between cars
-
@dkf
BASE10
(still - ) exists in my area. I want it so badly I just considered discovering and assassinating the current owner.
-
@dkf said in Database misstep:
@Gurth I'm still waiting for the
W-TF 123
plate to show up.Travel to Wuppertal (
W
) or Waldshut (WT
), and look around there.
-
@BernieTheBernie said in Database misstep:
Wuppertal
Where do I know that one from ...
https://www.youtube.com/watch?v=9IFh6wFTJiQ&ab_channel=TheTimTraveller
oh jeah ... silly Germans
On a related noted ... almost ended up here but my travel companions didn't share my level of border pedantry so we just sticked to Monschau "city"
https://www.youtube.com/watch?v=KEM_cp6hVeM&t=30s&ab_channel=TheTimTraveller
-
-