Author: Alex

Why is there almost no voice heard in films (SOLVED)

Posted by Alex On April 11, 2024

Why is the voice in the film very muffled or almost inaudible? You may have encountered a situation where various special sound effects in a movie are played very loudly, and the voices of the actors are almost inaudible. Moreover, this may not happen in all films or in all media players. The simplest reason for this could be that...

How to paste unformatted text in Writer (LibreOffice) using Ctrl+V

Posted by Alex On April 9, 2024

By default, the Writer text editor in LibreOffice recognizes different clipboard contents depending on the program you copied the text from. For example, if you copied a fragment from a site (web page), then in addition to the always present “Unformatted text” option, there will also be the insertion option “HyperText Markup Language (HTML)”. If you copied a fragment from...

How to change the Word Completion key and other Word Completion settings in Writer (LibreOffice)

Posted by Alex On April 9, 2024

Word completion is a text editor feature that offers suggestions for the complete word as you type words. If you see that the program has suggested the correct word, then you can press the button (“Enter” by default) and the word will be added automatically. All in all, it is a handy feature, although it does take some getting used...

How to find the place where a photo was taken without third-party services

Posted by Alex On March 25, 2024

There are a huge number of online services that, using metadata (saved GPS information), can determine where a photo was taken and can show this place on the map. I wrote a couple of these services myself: https://suip.biz/?act=locatepicture https://w-e-b.site/?act=locatepicture Some people have concerns about how safe it is to send photos to third-party services. With an unstable and slow upload...

How to play a movie with an external audio track in VLC

Posted by Alex On March 25, 2024

In a convenient context menu, you can select an audio track (for example, with different languages or dubbing from different studios). But this only works if all audio tracks are embedded in one video file. But what if you want to play a video in VLC along with the audio in a separate file? VLC provides this functionality and you...

How to change the interface (menu) language of VLC media player in Linux

Posted by Alex On March 24, 2024

In VLC media player, in the settings there is an option to select the interface language. But this option is only present in the Windows version. In Linux there is no this option and you cannot change the language through the program settings. But the problem can be solved very easily in the console. How to change VLC language at...

How to increase the size of columns in phpMyAdmin

Posted by Alex On February 15, 2024

Table of contents 1. Why phpMyAdmin does not show the full contents of a cell (column) 2. How to view the full contents of a cell in phpMyAdmin 3. Why does changing column widths not show the entire data? 4.How to increase the number of characters in cells in phpMyAdmin Why phpMyAdmin does not show the full contents of a...

How to search in phpMyAdmin

Posted by Alex On February 14, 2024

Table of contents 1. How does searching through databases and tables work in phpMyAdmin 2. Instructions for using the search function in phpMyAdmin 3. Search the database as a whole. Search multiple tables simultaneously 4. Single table search Conclusion How does searching through databases and tables work in phpMyAdmin Searching MySQL/MariaDB is performed using SQL queries and therefore requires knowledge...

What is the difference between the LIKE operator and the equal sign (=) in MySQL/MariaDB. How to use LIKE in SQL

Posted by Alex On February 13, 2024

Table of contents 1. What to use to search in MySQL/MariaDB: LIKE operator or equals (=) operator 2. When to use equal sign (=) in SQL 3. When to use the LIKE operator in SQL 4. Even more differences under the hood Conclusion What to use to search in MySQL/MariaDB: LIKE operator or equals (=) operator The LIKE operator and...

Case sensitive search in phpMyAdmin

Posted by Alex On February 12, 2024

Table of contents 1. Case sensitive search in phpMyAdmin 2. How to create a request with “BINARY” in phpMyAdmin 3. How can I make SQL case sensitive string search in phpMyAdmin 4. Video on how to find a case-sensitive string in phpMyAdmin Case sensitive search in phpMyAdmin Let’s try to find rows in the table that contain the word “test”....
Loading...
X