We are trying to store some text with Japanese characters inside Maria DB 5. However, we can see only question marks after save.  We tried to set UTF-8 encoding with following command, but this also does not help.  ALTER DATABASE my_db COLLATE = 'utf8_unicode_ci'; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA where schema_name = 'my_db';   Any clues?
I'm setting up a new server and want to support UTF-8 fully in my web application. I have tried this in the past on existing servers and always seem to end up having to fall back to ISO-8859-1.  Where exactly do I need to set the encoding/charsets? I'm aware that I need to configure Apache, MySQL, and PHP to do this — is there some standard checklist I can follow, or perhaps troubleshoot where the mismatches occur?  This is for a new Linux server, running MySQL 5, PHP, 5 and Apache 2.
How to completely remove virtual packages? It turns out that removing a virtual package with apt-get only remove the package itself,  leaving behind the real packages that were installed by it  So how do you remove a virtual package, along with all the real packages that it installs? How can I ssh to a remote server with an automated password and no key? How long does a sequence need to be to be guaranteed to have a monotonic subsequence length k? The sequence 7, 2, 4, 1, 4, 8 has an increasing subsequence length four (2, 4, 4, 8) and a decreasing subsequence length three (7, 4, 1). It has other monotonic (increasing or decreasing) subsequences too, but none longer than four.  How long does a sequence need to be to be guaranteed to have a monotonic subsequence length k? Java - How to reduce the size of third-party jars to reduce the size of your application How do I upgrade an iPhone 4 from iOS 7.1.2 to iOS 8 or 9 Can you teleport farther away with misty step if you have a double from Invoke Duplicity? The Channel Divinity feature says:     you can cast spells as though you were in the illusion's space, but   you must use your own senses. (PHB 63)   If you were where your duplicate is, you could step to a space 30ft from its position. So if it is 60ft from you, you could teleport to a space 90ft from your actual position. But the spell says that:     you teleport up to 30 feet (PHB 260)   This would put a hard limit on the distance you can travel.  Which rule takes precedence here? I've always managed my iPhone/iPad/iPod Manually, I recently updated to iTunes 11 and now I can see no way to get my music onto my device.  I used to be able to just drag songs from my library to my device, now there is seemingly no way to do this.  I can view the music on my device by clicking on it on the top right corner of iTunes, but I can't seem to get to a state where I can drag music from my computer onto my device.  I'm using iTunes 11.0.1.12 for Windows if that makes a difference. Select 1px aliased border When I choose Select > Modify > Border and select a 1px border - the border I get is anti-aliased, hence if I fill my selection a 3px border is affected.  Is there a way to select a 1px aliased border? How Do I Compute the Eigenvalues of a Small Matrix? The center of the dihedral group How to prove that the center of the dihedral group $D_{2n}$ is $\{1,r^{n}\}$ and the center of $D_{2n-1}$ is $\{1\}$?  I don't know how to prove it in this general case. Unwanted comma between author and year using citet command I've been using the biblatex package for a while, and since updating my TeX installation (post-el capitan upgrade) I have been experiencing the following.   If the following is typed:  Such and such has been said \citep[111]{citekey}.   The following text is displayed:  Such and such has been said (Author, 2016, p. 111).   And if the following is typed:  \citet[111]{citekey} has said such and such.   The following text is displayed:  Author, (2016, p. 111) has said such and such.   The citep command is working as I want it to, but I do not want a comma placed after the author's name when using the citet command. I would like it to display as follows:  Author (2016, p. 111) has said such and such.    If I use the \citeyearpar command, it is fine, but I would rather not have to type the author's name in manually.   Here is the command placed in the preamble:  \usepackage[backend=bibtex, style=authoryear-icomp, url=true, isbn=false, natbib=true, sortcites=true, block=space, pagetracker=false, loccittracker=constrict]{biblatex}   Here is an example of an entry in my bib file (made using BibDesk):  @article{poldrack2006, Author = {Poldrack, Russell}, Journal = {Trends in Cognitive Sciences}, Number = {2}, Pages = {59--63}, Title = {{Can cognitive processes be inferred from neuroimaging data?}}, Volume = {10}, Year = {2006}}   I have also tried changing the entry to the following:  @article{poldrack2006, Author = {Russell Poldrack}, Journal = {Trends in Cognitive Sciences}, Number = {2}, Pages = {59--63}, Title = {{Can cognitive processes be inferred from neuroimaging data?}}, Volume = {10}, Year = {2006}}   The bibliography entry appears as follows, and is fine:  Poldrack, Russell (2006). “Can cognitive processes be inferred from neuroimaging data?” In: Trends in Cognitive Sciences 10.2, pp. 59–63.  Thank you for any help that can be offered. Closed-loop function question How do I find the   How do I find the transfer function of Gd(s)?  I am able to find the transfer function of Gr(s) but I am not really sure about Gd(s)? and how do i determine which order is this closed system? \includegraphics: Dots in filename \includegraphics cannot handle filenames that contain more than the one dot, separating the filename from the extension. Apparently it uses everything after the first dot as extension and then, of course, complains about an unknown graphics extension.  This is annoying as I very often have filenames that contain parameter values, e.g. plot_a0.4_b0.6.pdf.  Is there a way to teach LaTeX to interpret only the string behind the last dot as extension? Convince grep to output all lines, not just those with matches Ubuntu 17.10, changing input switching to alt-shift (with gnome-tweaks) creates problem in firefox I recently installed Ubuntu 17.10, and when I tried to set my keyboard layout to change with alt+shift, I hit a . There is  which works, but then it creates an unwanted behaviour on Firefox (perhaps other programs as well).   After setting alt+shift through gnome-tweak-tool as the combination to change language, whenever this combination is pressed within Firefox, it triggers a toggle that Firefox uses to show/hide the Menu Bar (with File/Edit/View etc.), and 'focus' is taken away from wherever the cursor was.   It's very frustrating, because one has to go and click again at the cursor.  The only solution I found was to permanently enable Menu Bar in Firefox because then alt doesn't do anything and I can use it to change languages. But I don't want to have Menu Bar on top always.  I hope you can understand what I'm trying to explain.  Any thoughts? Volume calculation of truncated cones with elipses as base and top I wish to calculate the volumes of a truncated cone whith asymetry over all axes and ellipses as base and top - how do I do that?  I have height and radii of the corresponding ellipses. (I assume correctly I need the geometric means of the 2 radii describing the ellipsis.)  Kind Regards Place questions with X net downvotes on hold automatically To resolve the frequent issue of poor question unfairly gaining answers, and thus paving the way for more poor questions to be asked  I Propose  EDIT: From feedback, have changed net vote threshold to 5 (to at least match that of the current 5 users at 3k rep) END EDIT     If a question has 5 net downvotes, the question is put   on hold automatically, and no answers are allowed until the question   is resolved/has been edited and net votes are > -5.   The net vote threshold could be perhaps different, to avoid grey area questions being on hold unfairly, but this also needs to be high enough to allow for early action.  On hold note, something such as:     This question has been put on hold via community voting on the   question, and cannot receive answers. To resolve this, edit and   improve the question.   This proposal would assist in stopping poor questions from receiving answers, as currently questioners not wanting to put in any effort know they will likely get an answer eventually.  This could also help improve site quality by making people improve their questions before they can have answers, so answers are only given to decent questions. "Naturally occurring" non-Hausdorff spaces? Is there a list of error codes for Minecraft? Comparing two java.util.Dates to see if they are in the same day