Short. I am moving a database and webpage. It is now an exact copy but on the webpage it doesnt display the swedish characters correctly. Example VÃƑÂ„RMARE should be VÄRMARE In the old database it is VÃ„RMARE in the new it is VÃƒÂ„RMARE It is an old webpage on an old php version that when i am moving will be a much later php version and a mariaDB. I think it has to do with the collation in the database for the tables but in phpmyadmin 2.11.8.1 i can't se collation for the columns. In the head i define &lt;meta charset=&quot;utf-8&quot;&gt;  I don't even know where to start troubleshooting. Any suggestions how to troubleshoot would be amazing for me.
326
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.
53187
How can I set my database to see the 'date' as "MDY" without running:  SET datestyle = "ISO, MDY";   every-time I'm trying to access it? I'm using Postgresql version 9.1, Ubuntu 12.04. My system locale, at the time of the database installation was set to en_CA.utf8 and I recently changed it to en_US.utf8.  show lc_CTYPE   returns: --> "en_CA.UTF-8"  but  show LC_CoLLATE   returns: --> "en_CA.UTF-8"
38513
Several of my site's pages are appearing in search results with [Translate this page] next to it. When I click that it takes me to Google Translate and translates my page "from Catalan to English".  The pages are in English but have a couple of foreign words (actually Japanese romanisations, not Catalan) that appear to be tripping Google up.  A few weeks ago I set the html tag to &lt;html lang="en"&gt; which from research appears to be the best method to specify the language of a document. Google has cached the pages with this attribute but it is still offering to translate.  More research led me to a "notranslate" attribute which prevents translation entirely: &lt;html lang="en" class="notranslate"&gt;. The problem now is users cannot translate from English to their desired language!  Are there any other solutions that force Google to parse my site as English only?
118141
Too often I messed with bad formated BibTeX files from references databases that are infected with active characters  as % or &amp; (usually in the abstract, that is not printed but produce an error anyway) but I can live with this inconvenient and replace those by with \% or \&amp;.   Also with some input encoding errors due to some UTF8 character that cannot be managed by pdflatex. In references this error is more disturbing that in the main text, but in best cases, is only change some greek letter as γ. In others is the insidious zero width U+200B, but with I can search and replace even this character.    The worse for me is the obnoxious U+301, specially when is not in over a consonant but hiding in vowels as normal acute characters, that are perfectly managed using inputenc, i.e., the   normal e character (U+0065) plus U+301 look exactly like the kind é (U+00E9) and so on with á, Á, í, etc., so if is hard detect the poisonous diacritic mark.   Disappointingly, search U+0065 plus U+301 find also the single character U+00E9 and vice versa in some editors, so I ended with the pain of searching &amp; replacing every accented letter (single or double) with the single character versión.    So the question is specifically is: There are clevers ways to sanitize .bib files with U+301 tildes?   (Of course, a more general answer, covering some automagic cleaning of all unrecognized and active characters will be welcome.)  The minimal (not) working example:   \documentclass{article} \begin{filecontents}{test.bib} @article{xx, author={González, M. and Ruíz, P.} title={Mañana hará calor &amp; bochorno con un 90% de humedad} }    \end{filecontents} \usepackage[utf8]{inputenc} \usepackage[T1]{fontenc} \usepackage[spanish]{babel} \begin{document} Hello  \cite{xx} \bibliography{test} \bibliographystyle{plain} \end{document}
77077
I was creating a table in SQL Server CE and realized it doesn't support varchar.   Looking this up, I found that "non-Unicode text columns (varchar, char, text) and smallmoney are not supported; although nvarchar, nchar, ntext, and money are supported" as .  Is this true? Why is this, exactly? It would seem that a compact database would support data types that take less bytes to store...I'm assuming it takes more space to save the Unicode characters.   What is the reasoning behind this?
9723
Please consider the following MWE:  \documentclass{article} \usepackage[spanish]{babel} \selectlanguage{spanish} \usepackage[utf8]{inputenc} \usepackage[T1]{fontenc}  \begin{document} Works: áéà  Does not work: \(\pmod1\) \end{document}   The áéà text is copied correctly, but if I try to copy (mód 1) it says: (m´od 1).  Does anyone know why this happens? How is it solved?  Thanks!
80932
I have a data stream that may contain \r, \n, \r\n, \n\r or any combination of them.  Is there a simple way to normalize the data to make all of them simply become \r\n pairs to make display more consistent?  So something that would yield this kind of translation table:  \r     --&gt; \r\n \n     --&gt; \r\n \n\n   --&gt; \r\n\r\n \n\r   --&gt; \r\n \r\n   --&gt; \r\n \r\n\n --&gt; \r\n\r\n
90579
Recently I noticed that some strings in Transifex have lost their translations. E.g. :   You've earned the "$badgeName$" badge ($badgeDescription$) for "$postTitle$".    I know that same string was already translated and used on ruSO for the long time. Now translation is lost, but even Transifex says that there is 100% match string in suggestions (acquired from the translation history). This means that new string is the same as the old one and should not be reset as happens if original string is slightly modified (even with one symbol).        Why did this happen? Did you change the string's key generation (hash) function? Could this be prevented in the future updates to minimize losing of translations?
93580
I'm working with a MySQL database that has some data imported from . The data contains non- characters (em dashes, etc.) as well as hidden carriage returns or line feeds. Is there a way to find these records using MySQL?
122345
I am working on a (my first) Drupal 8 project witch is a multilingual site. Drupal 8 really delivers in terms of native support for content translation.  However, I have a few strings set directly in some if the theme .Twig template files printed out like ex.   {{ 'Read more'|trans }}   I am really stuck on where to handle the translation for strings like these within the Drupal 8 installation.  What steps do I need to take to be able to translate these strings into the language currently selected for on the site? Do I need any additional modules other than the ones included in Drupal 8 core?  Steps I have taken:   Activated the Content Translation &amp; Interface Translation modules Added Twig strings like {{ 'Read more'|trans }} Flushed cache and refreshed pages containing the strings Checked admin/config/regional/translate for the strings with no result
48211
Im using smarty and mysql_real_escape_string() for user input, and when I insert some code with ' or " , and lookup in phpmyadmin it shows without backslashes.  When I get record from DB i doesn't have backslashes also. But when I just pass escaped string without inserting into the db it is backslashed.  Shouldn't it add slashes, insert with them and then I would  strip them when i would output? Or am I missing something?
3752
I have PHP configured so that magic quotes are on and register globals are off.  I do my best to always call htmlentities() for anything I am outputing that is derived from user input.  I also occasionally seach my database for common things used in xss attached such as...  &lt;script   What else should I be doing and how can I make sure that the things I am trying to do are always done.
23889
im currently writing my bachelors thesis and while inserting some cites and adding something to my bib file the above mentioned error occured. i tried to "fix" it by removing all the steps prior to the occuring error but it still remains and i just cant find any solution. since im a total newbie in latex, i would be grateful for any quick help! i found something that should remove this error but it doesnt:  \DeclareUnicodeCharacter{200}{„ “}   which i insert directly after   \usepackage[utf8]{inputenc}   but that still doesnt solve it  thx in advance guys!
10708
Some questions, for example    Instead of using a correct URL, such as  http://meta.stackexchange.com/questions/79543/٩●̮̮̃-̃۶-forbid-unicode   are using  https://superuser.com/questions/516363/what-is-the-��-character   What is causing this behavior?
15767
I have a set of 10 tables and each has an extra column that I don't want. Specifically, these tables are descriptions of database tables exported by phpMyAdmin, and they all have a "MIME" column that I would like to remove. Is there a way to do this other than using string manipulation / find and replace?   I have tried setting the column to p{0in}, but the column title still remains.
94550
When I installed phpmyadmin in Ubuntu 16.04 LTS, it gives me an error mentioned below.     The mbstring extension is missing. Please check your PHP configuration   then I tried to install php-mbstring, it says mbstring is up to date, Can anyone help me to solve this?
99906
One of the responses to  suggested that I should make sure my database can handle UTF-8 characters correctly. How I can do this with MySQL?