I´m having some troubles while inserting words with tildes and special characters from a csv in my MYSQL database.   That´s what I see in my DB:   And I should see this:   I put this in my HTML:      &lt;meta charset="utf8" /&gt;   and this in my PHP:  mysqli_query($db_conexion,"SET NAMES utf8"); if (!$db_conexion-&gt;set_charset("utf8")) {    printf("Error changing the utf8 character set: %s\n", $db_conexion-&gt;error); }  else {    printf("Current character set: %s\n", $db_conexion-&gt;character_set_name()); }   and it´s returning me "Current character set: utf-8" so I don´t understand why it´s inserting wrong... any help is welcome!
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.
25058
What is the fastest, easiest tool or method to convert text files between character sets?  Specifically, I need to convert from UTF-8 to ISO-8859-15 and vice versa.  Everything goes: one-liners in your favorite scripting language, command-line tools or other utilities for OS, web sites, etc.  Best solutions so far:  On Linux/UNIX/OS X/cygwin:   Gnu  suggested by  is best used as a filter. It seems to be universally available. Example:  $ iconv -f UTF-8 -t ISO-8859-15 in.txt &gt; out.txt   As pointed out by , there is an . Gnu  () suggested by  will convert one or several files in-place. Example:  $ recode UTF8..ISO-8859-15 in.txt   This one uses shorter aliases:  $ recode utf8..l9 in.txt   Recode also supports surfaces which can be used to convert between different line ending types and encodings:  Convert newlines from LF (Unix) to CR-LF (DOS):  $ recode ../CR-LF in.txt   Base64 encode file:  $ recode ../Base64 in.txt   You can also combine them.  Convert a Base64 encoded UTF8 file with Unix line endings to Base64 encoded Latin 1 file with Dos line endings:  $ recode utf8/Base64..l1/CR-LF/Base64 file.txt    On Windows with  ():    PS C:\&gt; gc -en utf8 in.txt | Out-File -en ascii out.txt  (No ISO-8859-15 support though; it says that supported charsets are unicode, utf7, utf8, utf32, ascii, bigendianunicode, default, and oem.)   Edit  Do you mean iso-8859-1 support? Using "String" does this e.g. for vice versa  gc -en string in.txt | Out-File -en utf8 out.txt   Note: The possible enumeration values are "Unknown, String, Unicode, Byte, BigEndianUnicode, UTF8, UTF7, Ascii".   CsCvt -  is another great command line based conversion tool for Windows.
87331
When I Import Mysql from local server to web ser it is showng me error 1115 - Unknown character set: 'utf8mb4' in Creating wordpress wp_comment table CREATE TABLE IF NOT EXISTS  `wp_commentmeta` ( // // ) ENGINE = INNODB DEFAULT CHARSET = utf8mb4 AUTO_INCREMENT =1;  #1115 - Unknown character set: 'utf8mb4'  My mysql version is Version information: 4.0.4, latest stable version: 4.4.10 (local version)  Version information: 4.0.10.7, latest stable version: 4.4.10( server version)  Please help me to solve out the error
50971
I have a web interface that generates LaTeX-letters to customers. These letters are rendered dynamically. Some customers have some special characters in their names, that LaTeX can't translate, so I run into unicode errors all the time. The *.tex-Template includes \usepackage[utf8]{inputenc}, but I keep having problems with unicode characters. Here are two error messages from today: Unicode char \\u8:\xc2\xb0 not set up for use with LaTeX. Unicode char \\u8:\xe5\x8d\x97 not set up for use with LaTeX. For now, I use a Python dictionary to convert some already as problematic identified chars into correct LaTeX code. But it's never ending. Is there a way to tell LaTeX to ignore ALL unicode-related compiling errors, e.g. by telling LaTeX to convert all problematic chars into one ?-char?
105734
In my web app, I submit some form fields with jQuery's $.getJSON() method. I am having some problems with the encoding. The character-set of my app is charset=ISO-8859-1, but I think these fields are submitted with UTF-8.   How I can set encoding used in $.getJSON calls?
115204
I want to import shapefile into PostGIS. There is one database postgres in it but no table added yet.   I am using this command:   shp2pgsql -I -s 4326 districts.shp districts | psql -d postgres -U postgres    and it's giving me some error:      Unable to convert data value to UTF-8 (iconv reports "Invalid or incomplete multibyte or wide character"). Current encoding is "UTF-8". Try "LATIN1" (Western European), or one of the values described at postgresql.org/docs/current/static/multibyte.html   Is my command wrong ??
52079
How does one insert a "\" (backslash) into the text of a LaTeX document? And how does one insert a "~" (tilde)? (If you insert \~, it will give you a tilde as an accent over the following letter.)    I believe \backslash may be used in math formulae, but not into text itself. Lamport's, Kopka's, and Mittelbach's texts have said as much (but no more), and so left me hanging on how to get a backslash into regular text.
12526
Would you recommend using a  or a  field, and why (using MySQL)?   I'm working with PHP on the server side.
82615
On PHP 5.3.13/MySQL 5.5.21 the following code doesn't work:  if($check_custom_fields_form!=1){     $sql = "CREATE TABLE IF NOT EXISTS ". $table_custom_fields_form ." (                 `form_name` longtext NOT NULL,                 `field_id` bigint(20) NOT NULL,                 FOREIGN KEY (`field_id`) REFERENCES $table_custom_fields (`ID`) ON DELETE CASCADE ON UPDATE CASCADE     ) CHARACTER SET utf8 COLLATE utf8_general_ci";     dbDelta($sql); } if($check_subscribe_cat!=1){     $sql = "CREATE TABLE IF NOT EXISTS ". $table_subscribe_cat ." (                 `subscribe_id` bigint(20) NOT NULL,                 `cat_id` bigint(20) NOT NULL,                 FOREIGN KEY (`subscribe_id`) REFERENCES ".$wpdb-&gt;prefix."tgt_subscription (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,                 FOREIGN KEY (`cat_id`) REFERENCES ".$wpdb-&gt;prefix."terms (`term_id`) ON DELETE CASCADE ON UPDATE CASCADE     ) CHARACTER SET utf8 COLLATE utf8_general_ci";     dbDelta($sql);  }   The  suggested a downgrade to MySQL 5.1.37 (no, thanks) or the following update:  if($check_custom_fields_form!=1){         $sql = "CREATE TABLE IF NOT EXISTS ". $table_custom_fields_form ." (                     `form_name` longtext NOT NULL,                     `field_id` bigint(20) NOT NULL,                     KEY(field_id)         ) CHARACTER SET utf8 COLLATE utf8_general_ci";         dbDelta($sql);     } if($check_subscribe_cat!=1){       $sql = "CREATE TABLE IF NOT EXISTS ". $table_subscribe_cat ." (                   `subscribe_id` bigint(20) NOT NULL,                   `cat_id` bigint(20) NOT NULL,                   KEY(subscribe_id),                   KEY(cat_id)       ) CHARACTER SET utf8 COLLATE utf8_general_ci";       dbDelta($sql);    }   Which seems like a rather dirty way to work around the problem (no cascading deletes/updates). Therefore:   Do I really have to live with that ? Is it true that dbDelta only works with foreign key in a 3 year old MySQL version?
27610
I'm receiving the following warnings when I use mysql_query() in my modules:  mysql_query(): A link to the server could not be established in ...... on line 6  If I use db_query() instead, it works fine.   The code is a simple SELECT query with no special characters or variables. The actual query is mysql_query("SELECT * FROM custom_nodify WHERE nid = 345");  I should mention that this happens with ANY mysql_query(), not just the one above.  Any suggestions as to why this doesn't work?
102353
Is it correct to use certain special characters, as +, &amp;, ', . (dot) and , (comma), basically, in filenames.   I understand that you can use - and _ with no problem, but doing some research I have been unable to find something definite about the other symbols; some say that you can, some say that you can't, and some others say that it is "not encouraged" to use them (whatever that means).
39001
For my thesis, I use biblatex for the bibliography.  As seen , biblatex is not compatible, with \usepackage[utf8x]{inputenc}. It was reported as close but I still have the same problem with my version of bibtex (last one on archlinux ). I want to use the € symbol inside my report but it fails without utf8.  ! Package biblatex Error: Incompatible package 'ucs'.  See the biblatex package documentation for explanation. Type  H &lt;return&gt;  for immediate help.  ...                                                l.7 \begin{document}   Any idea idea how to fix ?  \documentclass{report}  \usepackage[utf8x]{inputenc} \usepackage{biblatex} \bibliography{includes/mybib}{}  \begin{document}  X said Y \cite{bib1}  \printbibliography  \end{document}   and the file mybib  @online { bib1,        title = {Refrence title},        author = {X},        url = {http://site.com/y}}
116141
I recently started renting space on a remote server so that I could work on a project. I found that a relatively painless way to access it on a windows machine is through PuTTY. However, there is one thing that has always irked me when using it: for seemingly no reason random characters are sometimes inserted at the cursor.  Most of the time it is just a single tilde, but rarely it spits out what looks like some escape sequence ([[^8 or the like). It will only occur when I am focused on the window, whether I am typing or 20 feet away from the keyboard. If left for long enough, it will spit tildes at random intervals (average is about 1 minute).  Finally, this behavior seems to be inconsistant when running programs such as nano or the mysql interface: in nano, instead of inserting tildes, it will set marks (ctrl-^); in mysql, lines will become un-editable.  My question is this: Has anyone else experienced this sort of behavior in PuTTY? And if so, what can be done to prevent/correct this behavior?
102316
I'm trying to insert source code in LaTeX with using listings, but my code has accents and pdflatex gives me this error:  Unicode char \u8:�\expandafter not set up for use with LaTeX.   This is a code the reproduces the error.  example.tex  \documentclass{article} \usepackage{listings} \usepackage[utf8]{inputenc} \usepackage[spanish]{babel}  \begin{document}  \lstinputlisting[language=C++]{code.cpp}  \end{document}   code.cpp  // Código con una tilde   What can I do to generate the PDF correctly?
20942
There are several Unicode charactes I'm just seeing as boxes. This happens in Chrome only. The Character Encoding is set to UTF-8, but Autodetection doesn't help.   Example: [⁠]  You will only see two square brackets, but actually there is the Unicode Character  in between. It's a zero-width non-breaking space.  I also put together a little . I can't see the World Joiner character, but I can see the Hair Space. (And by seeing it I actually mean I don't see it. You see?)  This also happens when people post some new style emoticons etc.  How can I fix this?  Update:  This happens everywhere (Twitter, Facebook, you name it). I'm not using special fonts or have changed something font-related on my system (Windows 7, 64 bit). Am I wrong assuming this should just work?  Update 2:  This drives me insane. There are still so many characters that are not displaying.  Example (wrapped gift): 🎁    As you can see, Chrome is not displaying the character by default. Only when I explicitly set the font to Segoe UI Symbol, it does. Why is Chrome not using the font as a fallback automatically?  How can I make Chrome recognize the Segoe UI Symbol font?
110595
I am trying to save multiple values from a textarea to a database table.  I use the following code, but I feel it is the wrong way.   foreach ($user_emails as $key =&gt; $value) {   $insert_banned_emails = db_insert('banned_users');   $insert_banned_emails     -&gt;fields(array(       'email' =&gt; $value,     ))     -&gt;execute(); }   Is there a different way for achieving the same result?
45470
I'm trying to make a URL with a tilde character (~) in it:  \usepackage{url} ... \url{http://lyle.smu.edu/~tspell/jaws}   It looks right in the resulting PDF, but when clicking on it the browser goes to a wrong URL: http://lyle.smu.edu/%18tspell/jaws  If I type in the browser %7e (escape code for '~') instead of %18 the browser then goes to the correct URL.  Any idea how to get a correct link in the PDF?