The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 2,917 other followers

Archive for January 6th, 2022

When MySQL characterset ‘utf’ does not allow you to enter some Unicode code points

Posted by jpluimers on 2022/01/06

Contrary to what many believe is that MySQL utf8 is not always full blown UTF-8 support, but actually utf8mb3, which has been deprecated for a while now.

Only utf8mb4 will give you full blown UTF-8 support.

This when someone reminded me of this in a Delphi application:

When I insert :joy: emoji into mysql varchar filed I got an error :
#22007 Incorrect string value: '\xF0\x9F\x98\x82' for column 'remarks' at row 1

database charset is utf8

Note that the :joy: emoji is ūüėā and has Unicode code point U+1F602 which is outside the basic multilingual plane.

See:

–jeroen

Posted in Conference Topics, Conferences, Database Development, Delphi, Development, Encoding, Event, MySQL, Software Development, UTF-8, UTF8 | Leave a Comment »

Some links and graphs on ESXi capping/throtteling disk speeds

Posted by jpluimers on 2022/01/06

As promised in ‚ÄúSolution‚ÄĚ on ESXi 6.7 smartinfo throwing error Cannot open device, here are a few links in capping throttling disk speeds by ESXi followed by a few graphs of my own:

My own observations on ESXi 6.7 update 3:

  1. One rsync operation:
    1 rsync from 860 EVO SSD to 960 PRO NVMe

    1 rsync from 860 EVO SSD to 960 PRO NVMe

  2. Two rsync operations:
    2 rsync from 860 EVO SSD to 960 PRO NVMe

    2 rsync from 860 EVO SSD to 960 PRO NVM

  3. Resume actions were about 10 times faster than the single rsync read speeds:
    Resume action

    Resume action

  4. Suspend actions were between 4 and 6 times faster than rsync write speeds:
    Start of suspend action

    Start of suspend action

     

    Finish of suspend action

    Finish of suspend action

For each rsync operation, I had a separate SSH session going, and the speed doubled.

The resume action of all Virtual Machines was almost a flat speed curve.

The suspend action of all Virtual Machines started fast (when all machines were suspending) and finished slower (when only the largest virtual machines were still suspending)

–jeroen

Posted in ESXi5, ESXi5.1, ESXi5.5, ESXi6, ESXi6.5, ESXi6.7, ESXi7, Power User, Virtualization, VMware, VMware ESXi | Leave a Comment »

LIDL Radio Controlled Wall Clock IAN 100489 English manual

Posted by jpluimers on 2022/01/06

Model 100489-14-01 wall clock

Model 100489-14-01 wall clock

Just in case I need it again.

The signal quality fluctuates during the day (it is a lot better at night when there is less inionisation in the atmosphere), and is worsened by concrete walls (like our home).

Best way to get prolonged reception is at night, on the top floor behind a window or outside.

The clock usually needs between 3 and 10 minutes to pick up the DCF77 signal from the transmitter.

Wall clock manual: [Wayback] 100489_EN.pdf of which this abstract:

DCF77 HD-1688 clock mechanism

DCF77 HD-1688 clock mechanism

Numbers:

  1. M.SET button
    • Press and keep pressed the M.SET button 1 at least 3 seconds. The wall clock switches into manual mode.
    • Press and keep pressed the M.SET button again until the hands reach the correct position for you to set the time.
    • Briefly pressing the M.SET button moves the hands forward in one minute steps to enable you to set the current time manually.
      Note: After 8 seconds without pressing the M.SET button, the wall clock switches out of manual mode and keeps the time as normal. The manually set value is overwritten as soon as reception of the DCF radio time signal is successful.
  2. RESET button
    • Press the RESET button 2 to reset the radio clock settings. Alternatively, remove the batteries from the device and insert them again.
    • The product now automatically starts to search for the DCF radio time signal.
  3. REC button
    • Press and keep pressed the REC button 3 at least 5 seconds. The wall clock attempts to receive the DCF radio time signal. This process takes a few minutes to complete.
  4. Battery compartment
    • Battery type: 1 x 1.5 V ‚éď AA, LR6

 

More on the signal, transmitter and encoding: DCF77 – Wikipedia, where the below images are from:

DCF77 reception area from Mainflingen

DCF77 signal strength over a 24-hour period measured in¬†Nerja, on the south coast of Spain 1,801¬†km (1,119¬†mi) from the transmitter. Around 1 AM it peaks at ‚Čą 100 ¬ĶV/m signal strength. During the day, the signal is weakened by ionization of the ionosphere due to solar activity.

Another DCF77 clock I have: CSL Bearware 302658 DCF clock manual

–jeroen

Posted in Development, Encoding, Hardware Development, LifeHacker, Power User, Software Development | Leave a Comment »

 
%d bloggers like this: