Delphi Handbooks Collection


Delphi XE Handbook


Delphi 2010 Handbook


March 18, 2010

A Tale of Changing ZIP Code

At times using and comparing apparently immutable data can cause significant disruption. Data changes, invariably.

At times using and comparing apparently immutable data can cause significant disruption. Data changes, invariably. There is no think as fixed data, which is why in your database tables you have to use ID whenever possible, rather than data fields, to refer to records. But here I don't want to discuss the database theory, rather tell a couple of personal stories.

The first relates to my name. To be more precise, to my last name ( I didn't change name or ANYTHING like that!). The problem with my last name is that is has an accented latter. Now on my passport and ID card there no accented letter is possible, so my last name is spelled with a apostrophe after it. Not a big deal, you might think. However, on flight tickets only plain letters are used. That's why now and then as I board a plane I'm taken on a side by security claiming there is a problem because automatic check on my passport determined my ticket is for a different person. A rapid check unveils the issue, and I never had any serious problem.

Now let me get to the second story, the one I'm referring to in the title. Last year, the Italian postal service was so cute to determine that some middle-sized cities should now have two ZIP codes rather than a single one. So they changed my ZIP code. Again, it seems not a big deal, as mail with the original ZIP code will still get delivered for years. The problem is that my credit cards are tied to my ZIP code, so when I buy anything online and get it shipped I have to remember which ZIP code each credit card is bound to. If I get it wrong, the system will complain. I also had to remember the ZIP code of one of my credit cards to refuel while I was in the US recently.

Again, you might think this is not a big deal, as all I should do is edit my credit card information and update the ZIP code, right? Wrong: some of the sites used to edit that information won't let you enter the ZIP code but only pick the one for your city. And they have it wrong, so changing the data is far from trivial. Another system I use won't let me change my address without signing a specific paper requests, which is done (again) to avoid fraud. I've already been through it as not only I have this ZIP code issue, but the street I live in has two different spellings (San, for saint, vs. S.). So as I place an online order with my credit card, I might have it shipped to a different last name, at a different address, with a differetn ZIP code. But that's always me.

No, there is no such thing as safe immutable data!





 

5 Comments

A Tale of Changing ZIP Code 

"No, there is no such thing as safe immutable data". 
True. But there are many systems with flawed designs 
and implementations.
Comment by Luigi D. Sandon on March 18, 11:10

A Tale of Changing ZIP Code 

Wait, it'll get worse when automated processing of
personal data harvested from the web becomes normal. 

You may find yourself refused credit, or a booking,
etc., and you won't know why. And worse, nor will the
company offering the service! They want to reduce
company risk. You got automatically flagged as a
higher than normal risk. Tough.
Comment by Ken Knopfli on March 18, 14:57

A Tale of Changing ZIP Code 

Right now all these "authentication" methods are based
on shared knowledge between oneself and a company. 

Here in the US it has become very common for companies
to ask for the last four digits of your social
security number and your Mother's maiden name. This is
as secure as the information is private. But because
you are sharing this information in many ways (Medical
forms, credit applications, companies databases, etc.)
this will prove fallible as well.

Until we find a better methods of authenticating and
trusting a person all this little details are going to
drive you mad. 

Comment by Alan Fletcher [http://www.delphibistro.com] on March 18, 18:31

A Tale of Changing ZIP Code 

In Norway we have the letters Æ, Ø Å (comes after Z), 
as "special" characters. The first thing I decided when 
I was going to become a father for the first time, was 
that my kids should not have names with such 
characters. My last name has thankfully not some of 
those letters:)
Comment by Frode on March 19, 12:44

A Tale of Changing ZIP Code 

 Hello Marco
my house and my office are in the same building,
the office is on the first floor and the house is on
the second floor but we have 2 different addresses.

The nice thing is that the two street names that are
at the post office does not match with "ufficio del
catasto" and are still different from those on the
maps of navigation systems.

a mess all Italian

regards
daniele
Comment by Daniele on March 19, 21:34


Post Your Comment

Click here for posting your feedback to this blog.

There are currently 0 pending (unapproved) messages.