When I add data to my db Russian letter are converted into some kind of symbols like this: Ð´Ð°Ð²Ð¸Ð´. Same with Georgian language. I use PHP to insert data from web to db. In html charset is utf-8 and also in database Collation is set to utf8_general_ci. How can i fix it?
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.
59310
I can't create a post with the .  There are errors for both the Japanese and Chinese characters.  Here is the post in question . It is peculiar that it supports 59 languages besides Japanese and Chinese.
90867
I'm doing some web scraping and sites frequently use HTML entities to represent non ascii characters. Does Python have a utility that takes a string with HTML entities and returns a unicode type?  For example:  I get back:  &amp;#x01ce;   which represents an "ǎ" with a tone mark.  In binary, this is represented as the 16 bit 01ce.  I want to convert the html entity into the value  u'\u01ce'
105113
In PostgreSQL, what is the difference between collations C and C.UTF-8?   Both show up in rows of pg_collation. Is it perhaps the case that C.UTF-8 is the same as C with encoding UTF-8 regardless or what the actual encoding of a database is?
51399
I experience a problem similar to    Here's a screenshot on the website     I've tried:   Removing fonts I have installed Setting the encoding to Western, UTF-8, Greek, Automatic Changing the fonts used in Google Chrome Removing Google Chrome, including all application data/user profiles Running CCleaner Reinstalling Google Chrome, twice Installing Chromium (fonts display fine in Chromium) Turning off Windows ClearType Changing Windows/Chrome languages from English (Australia) to US, UK Restarting Windows several times after making changes   All of which did not work. I do not connect over VPN/proxy.   Can anyone give me any tips?  Windows 7 x64 Ultimate
92402
I would like to have a bibliography with both Cyrillic and Latin and the main document language being English. How can I make biblatex to automatically switch between languages? (without using XeTeX as suggested by some) The minimal example returns an error if the main language is English. However, with the main language being Russian the document works.  \documentclass{article}  \usepackage[utf8]{inputenc} \usepackage[russian,english]{babel}  \usepackage[backend = biber,babel=other]{biblatex} \usepackage{csquotes} \addbibresource{library.bib}  \begin{document} %\selectlanguage{russian} %if the main document language is Russian the bibliography is compiled without any problem. This is a test. \parencite{Bara2006,Baranov2001}  \printbibliography  \end{document}   The .bib entries are  @book{Bara2006, address = {New York}, author = {Bara, Judith}, publisher = {Routledge}, title = {{English Citation entry}}, year = {2006} }  @book{Baranov2001, address = {Санкт-Петербугр}, author = {Баранов, Николай А}, title = {{Эволюция взглядов}}, year = {2001} }
35988
I am programmatically exporting data (using PHP 5.2) into a .csv test file. Example data:   Numéro 1 (note the accented e). The data is utf-8 (no prepended BOM).  When I open this file in MS Excel is displays as NumÃ©ro 1.  I am able to open this in a text editor (UltraEdit) which displays it correctly.  UE reports the character is decimal 233.  How can I export text data in a .csv file so that MS Excel will correctly render it, preferably without forcing the use of the import wizard, or non-default wizard settings?
65600
If you try to enter a internationalized domain name as your "website" in your profile, it will be silently stripped of any non-English characters.  Ex: My webiste is  but when I try to enter that it saves it as http://linus.unnebck.se/ when it actually should display linus.unnebäck.se and link to http://linus.xn--unnebck-9wa.se/ (or just link with the ä, don't now what is the right thing to do).  As I wrote this post I also noticed that the markup ends the link at the first non-English character aswell, look at the example above.
9028
How can I add text with non Latin characters? I'd like to get text in other languages like Arabic, Russin (Cyrilic), Japanese, Chinese, Malayalam among others, but I get rectangles instead of Arabic letters.
47610
This has been confusing me for some time. With the advent of UTF-8 as the de-facto standard in web development I'm not sure in which situations I'm supposed to use the HTML entities and for which ones should I just use the UTF-8 character. For example,   em dash (–, &amp;emdash;) ampersand (&amp;, &amp;amp;) 3/4 fraction (¾, &amp;frac34;)   Please do shed light on this issue. It will be appreciated.
79622
I want to type guillemets (angle quotes, «») in Ubuntu when using   Russian keyboard mapping English keyboard mapping   Is it possible (preferably without typing numeric codes)?  There is a discussion , but it does not mention Linux.
26314
Please, do you know if there's any possibility how to use the listings package together with XeLaTeX? I have to use XelaTeX and therefore I have UTF-8 encoded files. This is not compatible with listings which allows one-byte encoding. (I know there is listingsutf8 package, but it converts files from UTF-8 which I don't need.)  The listings package works somehow, bu I only can use English letters. I've fond some solution like a list of special characters (  ) but it seems it works only for some letters. It there anything that would support UTF-8 in listing 'naturally'?
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?
63819
We're moving from SQL 2005 [Instance and DB have collation of SQL_Latin1_General_CP1_CI_AS]  to SQL 2008 [which defaults to Latin1_General_CI_AS].  I completed a SQL 2008 R2 installation, and used default Latin1_General_CI_AS collation, with the restoration of the database still on SQL_Latin1_General_CP1_CI_AS. The excepted problems occurred - the #temp tables where in  Latin1_General_CI_AS whilst the db was in  SQL_Latin1_General_CP1_CI_AS and this is where I am now - I need advice on the pitfalls now please.  On installation of SQL 2008 R2, I have the option on installation to use 'SQL Collation, used for backwards compatibility' where I have the option to select the same collation as the 2005 database : SQL_Latin1_General_CP1_CI_AS.   This will allow me to not have problems with #temp tables, but are there pitfalls? Would I lose any functionality or features of any kind by not using a "current" collation of SQL 2008? What about when we move (e.g. in 2 years ) from 2008 to SQL 2012? Will I have problems then? Would I at some point be forced to go to Latin1_General_CI_AS? I read that some DBA's script complete the rows of complete databases, and then run the insert script into the database with the new collation - I'm very scared and wary of this - would you recommend doing this?
36680
I'm working with Oracle databases from 10g-r1 to 11g-r2. They are set as ISO-8859-15 (WE8ISO8859P15) character set.  I need to create a tablespace set as UTF-8 (AL32UTF8) character set inside these databases. Is it possible? What is the correct syntax?
1735
In order to store results in the newly released (Winter 16') Platform Cache, I need an alphanumeric string, but currently have a String with the report name that I'm attempting to store, some of which have spaces, hyphens, parenthesis, etc. (i.e. "Sales - Actual Results (TY)").  I'm not sure in APEX how I would strip all these unwanted characters from the string to convert it into the alphanumeric key that I need.  Please &amp; Thank you!
71498
I realize similar questions have been asked before but I am not satisfied with any of the answers I've seen. I would like to use the Cyrillic letter Ш to denote a particular group in mathematics. Most solutions involve using OT2 or T2A encoding; for example, at . However, this makes the other text in the document look bad.   For example, using the solution above, I get    while I would like to have     The first seems to be shaded strangely and the characters don't seem to align right.  Does anyone know how I can write the character Ш (in math mode) without changing the default font for the rest of the text?