Default field lengths for address fields in databases

Standard lengths for address fields in databasesToday, we will dive into some more theoretical stuff. The topic of this article will be field lengths of database fields for addresses. For every second database I create, I am faced with the same problem: How long / “big” do I actually make the database fields for addresses? So fields, such as first name, surname, street, e-mail address, etc.
So far I have oriented myself to given requirements or old databases. But now I wanted to work up the topic once for all right. So the question is: Is there actually a standard for address field lengths?
Looking for standards for address field lengths
A search for “address field lengths for databases” spits a huge amount of hits. Unfortunately there are only opinions and experiences everywhere. […]

Time change for DSLR cameras

DSLR - time changeTwice a year it’s time to change the clocks. I do not want to discuss about sense and nonsense or it’s origin, but also make a lot more attention to an issue that I’m even gone “into the trap”.
Meanwhile the time change is not a big deal anymore, because – apart from a few analog watches and alarm clocks – almost any device changes its time settings automatically. So I thought at least until my holiday pictures showed up in a relatively strange temporal order. The reason therefore? One of my DSLRs hadn’t changed the time and I forgot to do it manually. And as this – according to Google – still concerns a lot of camera models, that are not able to automatically switch to daylight savings time, I wrote this article.
How to […]

[Wiki] Motion JPEG

Motion JPEG, also known as MJPEG, is a video codec which saves every single frame as jpeg image.
In contrary to videos which are comprimized with MPEG codecs where, among other things, only the frame differences are stored, in MJPEG videos the whole frames are saved as separately jpeg images.  This brings advantages as also disadvantages with it.
On the one hand there are no artefacts in fast video sequences/scenes but on the other hand you get much larger video files because much more image information has to be stored. For a video in SVHS-quality, which is saved in MJPEG format, you need round about 25 MBit (3,1 MByte) per second.
MJPEG encoded video material can be found today usually only in the ip-cam sector.  (ip-cam = network camera) For network cameras the MJPEG codec seems to be ideal, because it needs hardly any hardware resources for encoding the video and nearly every […]

New category – “wiki”

 
Hello together,
I’ll just want to inform you that there’ll be soon a new category. The category will be named “wiki” and gradually filled with articles, which on the contrary to my other articles on this blog, will completely missing my personal touch. The articles should be seen as pure knowledge articles which are totally free from any comments of mine or my personal opinion.
If you now ask yourself, “Why does he do that?” I’ll say, “let me explain it to you.” A couple of times there have been articles where I used techniques and terms whiche are not very common. So as not to bloat these articles with all that nerdy stuff, I will create wiki articles on specific topics, which you can work through, to get the necessary background knowledge for the main articles.
 
 
Greetings,
Raffi