Default field lengths for address fields in databases

Posted by Raffael on 09/03/201710/21/2021 Posted in Programming, SQL, Test, Wiki Tagged adr06, adrc, database field length, SAP, t005t

Standard lengths for address fields in databases Today, 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 […]

Change Logitech FN-key behaviour without software

Posted by Raffael on 09/02/2017 Posted in Linux, Test, Tutorials, Windows

Change standard FN-key behaviour Today there is once again a short tip – this time for all owners of Logitech keyboards with a FN-key. Some time ago I was looking for a new keyboard. Criterion: Parallel usage of several devices – usually via Bluetooth. In the end the choice fell on the Logitech K375s. Stylish design, support for up to 3 devices that can be connected via Bluetooth or Logitech Unifying receiver. Only one small problem remained: the FN key.
No products found.
By pressing the FN key, the second assignment of individual keys can be activated. For example: You can control the volume by pressing the F12 key while holding down the FN key. So that’s the way I would prefer it at least. In practice, the FN key is active […]

How to generate Swiss QR Code in C# and VBA

Posted by Raffael on 05/21/201702/18/2018 Posted in C#.Net, Programming, Test, VBA Tagged ISO 18004, iso 20022, qr invoice, swiss qr code

Swiss QR Code in C-Sharp and VBA Today, we are looking into the field of business computer science. Since end of April, SIX has released the specification for the new Swiss QR Code according to ISO 20022. The Swiss QR Code is an integral part of the new Swiss deposit slip, the so-called QR invoice, which shall be implemented by all companies by mid-2018 at the latest. The Swiss QR code is placed in the so-called “number part with QR code” of the QR invoice.
In the following, we will discuss how the Swiss QR code can be generated using C # or VBA. To do this, we use the free QRCoder library, which I developed almost 4 years ago and to which recently added the Swiss QR Code. One more thing before […]

.NET Core – gdiplus.dll not found in Linux

Posted by Raffael on 05/08/2017 Posted in C#.Net, Kubuntu, Linux, Linux Mint, Programming, Test, Ubuntu Server

A few days ago there was an issue raised in my QrCoder project. It was reported that the code would not run under Linux, as the following error message would occur:

Unhandled Exception: System.TypeInitializationException: The type initializer for ‘System.Drawing.KnownColors’ threw an exception.
—> System.TypeInitializationException: The type initializer for ‘System.Drawing.GDIPlus’ threw an exception.
—> System.DllNotFoundException: Unable to load DLL ‘gdiplus.dll’: The specified module could not be found.
(Exception from HRESULT: 0x8007007E)
at System.Drawing.GDIPlus.GdiplusStartup(UInt64& token, GdiplusStartupInput& input,
[…]

However the error message had its origin not in my QrCoder, but in the interplay of the .NET core framework with the GDI Plus library. The .NET Core Framework tries to access “gdiplus.dll” when accessing “System.Drawing.GDIPlus”, which is simply not available on Linux.
First solution approach
First, ensure that GDI+ is installed at all. This can be done with the following shell command:

sudo apt-get install libgdiplus

If libgdiplus is installed, however, another important step is missing …
Link libgdiplus for .NET Core
Because the […]

How to fix SSL error 61 in Citrix Web Receiver on Linux

Posted by Raffael on 05/03/2017 Posted in Kubuntu, Linux, Linux Mint, Test, Ubuntu Server Tagged citrix, citrix ssl error, citrix web receiver, missing root certificate, ssl error 61

How to fix SSL error 61 in Citrix on Linux I admit, the title is quite specific and will certainly appeal to only a small readership. But anyone who is facing the problem will be, like me, grateful for a solution.
In particular, the problem is about the SSL error 61 in the Citrix (Web) receiver under Linux and how to fix it. Since I have been running almost exclusively under Kubuntu for several months, the Citrix Reiceiver also moved into the new Linux box. Unfortunately, no connection to systems could be established, since the receiver disconnected with the following error message.
SSL Error 61: You have not chosen to trust “Go Daddy Root Certificate Authority – G2”, the issuer to the server’s security certificate.