How to identify content with 10-bit color depth. How to check what color depth is used in a photo and video
Posted by Alex On August 31, 2023
How can I tell if 10-bit depth is being used in a video or photo? How to determine color depth in an image First of all, if the photo is in JPG format, then it is safe to say that 10-bit color depth is not used in it, because this format simply does not support […]
How to watch HDR videos on YouTube on Linux
Posted by Alex On August 31, 2023
To get started, make sure that your monitor supports 10-bit color depth and enable 10-bit (or, as it is usually indicated in the settings, 30-bit) color depth at the level of the Linux operating system. In your web browser's address bar, enter: chrome://flags Use the search to find the “Force color profile” flag. Select “Display […]
Why Google Chrome web browser is gray when 10-bit color is enabled and how to fix it
Posted by Alex On August 31, 2023
After enabling 10-bit color depth on Linux, you may find that some applications turn gray. For some of them, this cannot be fixed, but in Google Chrome you can select the correct color profile, which will make it possible to watch HDR videos on YouTube, while all other websites will have normal brightness. The Google […]
How to determine the number of colors (bits per pixel) in X11
Posted by Alex On August 31, 2023
How to determine the number of colors (bits per pixel) in X11 How can I find out how many bits per pixel are actually available in a running X11 session? To check the system-wide value, run the command: xwininfo -root | grep Depth Example output: Depth: 24 The following command will print the supported bitness […]
How to fix Linux booting to black screen (SOLVED)
Posted by Alex On August 27, 2023
Pretty harmless video card settings (for example, installing drivers, choosing a video card for video output on a laptop, enabling 10-bit color depth) can lead to a serious problem for beginners: the Linux operating system boots into a black screen. Since this problem cannot be solved by the usual methods in the graphical interface, novice […]
“ERROR 1366 (22007): Incorrect string value” in MySQL/MariaDB (SOLVED)
Posted by Alex On August 26, 2023
How to insert emoji into MySQL/MariaDB database On the one hand, inserting emoji into a MySQL / MariaDB database table does not require any special preparatory steps – just insert one or more emoji characters, which may contain other text. For example: INSERT INTO TestTABLE (`test_column`) VALUES ("🎫⏭️✈️ and hi 🌅"); But when executing the […]
PHP not displaying emoji from MySQL/MariaDB database (SOLVED)
Posted by Alex On August 25, 2023
When retrieving rows from a MySQL (MariaDB) database, you may encounter a situation where all the text is displayed correctly, but question marks are displayed instead of emoji. The most likely problem is an incorrectly used encoding when executing queries against the MySQL (MariaDB) DBMS. There are two ways to fix this situation. 1. Select […]
What is the difference between utf8_general_ci, utf8_unicode_ci, utf8mb4_general_ci, utf8mb4_unicode_ci collations. Which collation, character set and encoding to choose for MySQL database
Posted by Alex On August 25, 2023
As of MySQL 5.5.3 you must use utf8mb4 and not utf8. Both of these groups refer to UTF-8 encoding, but the older utf8 has MySQL-specific restrictions that prevent characters above 0xFFFD from being used. Thus, neither utf8_general_ci nor utf8_unicode_ci need to be used anymore. As for the new encoding versions utf8mb4_general_ci and utf8mb4_unicode_ci. That is […]
Error “ERROR 1142 (42000)”: command denied to user for table in MySQL / MariaDB (SOLVED)
Posted by Alex On August 25, 2023
Error number 1142 (42000) occurs when the user does not have enough privileges on the table or database to execute the query. An example of an error when executing a query with a SELECT statement: SELECT * FROM TestDB.TestTABLE; The request failed with an error: ERROR 1142 (42000): SELECT command denied to user 'mial'@'localhost' for […]
Error “ERROR 1143 (42000)”: command denied to user for column in table in MySQL (MariaDB) (SOLVED)
Posted by Alex On August 24, 2023
How to fix “ERROR 1143 (42000)” in MySQL (MariaDB) Error number 1143 (42000) occurs when a user has privileges on some columns of a table, but he tries to exercise his privileges on those columns for which he does not have permissions. If the user tries to perform actions for which he does not have […]