Tag: error
July 12, 2022
SQLSTATE[HY000]: General error: 1366 Incorrect string value: ‘\xE2\x80\x8B\xE2\x80\x8B…’ for column
If you get this (or similar) when trying to insert/update in a MySQL database, you table is not able to cope with the extended version of the UTF8 character set.
You will need to convert your table to use the utf8mb4 character set, and utf8mb4_unicode_ci collation.
An example to do so:
ALTER TABLE `your_table_here` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
read more
Tag: mysql
July 12, 2022
SQLSTATE[HY000]: General error: 1366 Incorrect string value: ‘\xE2\x80\x8B\xE2\x80\x8B…’ for column
If you get this (or similar) when trying to insert/update in a MySQL database, you table is not able to cope with the extended version of the UTF8 character set.
You will need to convert your table to use the utf8mb4 character set, and utf8mb4_unicode_ci collation.
An example to do so:
ALTER TABLE `your_table_here` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
read more
Tag: unicode
July 12, 2022
SQLSTATE[HY000]: General error: 1366 Incorrect string value: ‘\xE2\x80\x8B\xE2\x80\x8B…’ for column
If you get this (or similar) when trying to insert/update in a MySQL database, you table is not able to cope with the extended version of the UTF8 character set.
You will need to convert your table to use the utf8mb4 character set, and utf8mb4_unicode_ci collation.
An example to do so:
ALTER TABLE `your_table_here` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
read more
Tag: utf8
July 12, 2022
SQLSTATE[HY000]: General error: 1366 Incorrect string value: ‘\xE2\x80\x8B\xE2\x80\x8B…’ for column
If you get this (or similar) when trying to insert/update in a MySQL database, you table is not able to cope with the extended version of the UTF8 character set.
You will need to convert your table to use the utf8mb4 character set, and utf8mb4_unicode_ci collation.
An example to do so:
ALTER TABLE `your_table_here` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
read more
Tag: utf8mb4
July 12, 2022
SQLSTATE[HY000]: General error: 1366 Incorrect string value: ‘\xE2\x80\x8B\xE2\x80\x8B…’ for column
If you get this (or similar) when trying to insert/update in a MySQL database, you table is not able to cope with the extended version of the UTF8 character set.
You will need to convert your table to use the utf8mb4 character set, and utf8mb4_unicode_ci collation.
An example to do so:
ALTER TABLE `your_table_here` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
read more
Tag: gnome-keyring
May 14, 2020
Skype forgetting login details on Ubuntu
TLDR; Install gnome-keyring
If you are not using the default install of Ubuntu, you might not be using Gnome. This is the case for flavours such as: Kubuntu (KDE Plsama), Lubuntu (LXQt), Xubuntu (XFCE), and so on.
And if you have installed Skype using snap, then you will likely find that it will always ask you to login upon loading, even if you have it configured to automatically run at login.
read more
Tag: kde
May 14, 2020
Skype forgetting login details on Ubuntu
TLDR; Install gnome-keyring
If you are not using the default install of Ubuntu, you might not be using Gnome. This is the case for flavours such as: Kubuntu (KDE Plsama), Lubuntu (LXQt), Xubuntu (XFCE), and so on.
And if you have installed Skype using snap, then you will likely find that it will always ask you to login upon loading, even if you have it configured to automatically run at login.
read more
Tag: skype
May 14, 2020
Skype forgetting login details on Ubuntu
TLDR; Install gnome-keyring
If you are not using the default install of Ubuntu, you might not be using Gnome. This is the case for flavours such as: Kubuntu (KDE Plsama), Lubuntu (LXQt), Xubuntu (XFCE), and so on.
And if you have installed Skype using snap, then you will likely find that it will always ask you to login upon loading, even if you have it configured to automatically run at login.
read more