This is the code:
UPDATE `table_name`
SET `field_name` = replace(field_name, 'old_text', 'new_text')
how to avoid #1265 error changing a value in a table structure
That is avoiding “data truncated” error. You must avoid to replace a value in use.
The right way, if a given value is already applied to some items, is
- to add the new value (supposed similar to the old) to the table structure
- search for all the items with old value
- replace in each item the old value with the new one
- delete the old value in the table structure
batch change encoding to UTF-8 for several text (php) files
You can use recode
recode UTF-8 *.php -v
provided that all the files have the same encoding.
Otherwise you can try with something like
iconv -f US-ASCII -t UTF-8 *.php
a minor problem
It could be an apparent problem if there aren’t non-ascii characters in a file: then these files are yet recognized, with
file -i --mime-encoding *
as us-ascii.
So you can add a non ascii character, like è:
sed -i -e “$aè” *.php
and afterwards redo the command “recode” as above and replace some ascii expression, like agrave; with UFT-8 à character.
Eventually you will delete the “è” from the end of the files.
How to change encodig of “.srt” Subtitle File in UTF-8
To encode your SRT file in UTF-8 (for instance: “video.srt”), please follow this process:
1. Rename (F2) the “video.srt” file with your PC in “video.srt.txt”.
2. Launch a text app, like Kate.
3. Click on the “File” menu then select “Save the file as…”.
4. In coding option, select “UTF-8”. Then save your file.
5. Rename (F2) the file “video.srt.txt” to “video.srt”.
Done!
from: Zappiti Player 4K [EN]
svg editor
Inkscape is in my opinion too complicated (and Sodipodi very difficult to install, because of its dipendecies), a very interesting project is SVG-edit, at https://github.com/SVG-Edit/svgedit.
Without any installation on your PC, you can edit on-line your svg files. The resulting code is very clean, even though we have found some problem in setting colors.
permission denied
If you get rhis error message even you have all the rights, probably you are trying to run the command on a mounted partition that had the “noexec” flag on.
So change partition, .f.e. try your /home.
tag object in firefox
It’s probably a bug, but you couldn’t manage to view an svg object tag with firefox, unless is setted as image/svg (and not a text/svg).
mysql wrong autoincrement number
It can happen that the ID autoincrement goes wrong; in this case my solution is very simple: I delete the ID column, and afterwards I re-create it (with the same parametres). It works.
ancient greek in LibreOffice
Some days ago I wrote this:
a simple maquillage, unfortunately
I mean ancient greek font so that you can, typing ‘a’ get immediatly ‘α’. So far the free most interesting true type font (the only recognised by LibreOffice) is SPIonic.
You can see more details here.
With this font you can tranform the word “Nomos” in “Nomov“, with few mouse clics (basically with the font menu, even though in this case you have to convert the final sigma as well).
caveat
Absolutely to avoid the “AncientGreek” extension: cumbersome, useless and very aggressive (after removing leaves you with modified shortcuts, including some basic like ctrl + z, ctrl + b and F3).Vey bad!
a new solution
I noticed that the above solution works only within LibreOffice: if you copy a greek word in another program, you get a no-greek text (with latin encoding). That’s why I call it now a maquillage.
A possible, better solution is go to a website that easyly encode your text in ancient greek, such as this.
keeping updated your custom css (in Calibre viewer or in markdown-viewer browser extension)
You can link within the css (in Calibre it is within the file “viewer-webengine.json”, in markdown-viewer browser extension is the css file you yourself have chosen) your external css file, with something like
@import url(http://localhost/path-to-your-css-file/your-css-file.css)
Provided you have a apache/php server in localhost, of course.