I have this piece of code below and it's working fine, the issues is that when it goes up if I use bulgarian characters everything comes out like Ð¡Ñ‚Ñ€Ð°Ð½Ð°Ñ‚Ð° Ð½Ð° Ñ‡ÑƒÐ´ÐµÑÐ°Ñ‚Ð  But when I add bulgarian stuff from the admin menu (Opencart) display in Bulgarian.   The Database table 'name' is in utf8_general_ci.     &lt;?php include 'config.php'; $servername = DB_HOSTNAME; $username = DB_USERNAME; $password = DB_PASSWORD; $dbname = DB_DATABASE; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn-&gt;connect_error) {     die("Connection failed: " . $conn-&gt;connect_error); }   $sql = "UPDATE product_description SET name = REPLACE(name, 'The amazing spiderman Phone', 'Страната на чудесата')";  if ($conn-&gt;query($sql) === TRUE) {     echo "Record updated successfully"; } else {     echo "Error updating record: " . $conn-&gt;error; }  $conn-&gt;close(); ?&gt;
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.
Let a,b,c,d be real or complex numbers with absolute value less than $1$. Is the following true:  $$|ab-cd| \leq |a-c| +|b-d|?$$ I'm playing around, trying to write some code to use the  APIs to shorten a URL.  After reading , I tried:     TRIM_API_URL = 'http://api.tr.im/api'    auth_handler = urllib2.HTTPBasicAuthHandler()    auth_handler.add_password(realm='tr.im',                              uri=TRIM_API_URL,                              user=USERNAME,                              passwd=PASSWORD)    opener = urllib2.build_opener(auth_handler)    urllib2.install_opener(opener)    response = urllib2.urlopen('%s/trim_simple?url=%s'                               % (TRIM_API_URL, url_to_trim))    url = response.read().strip()   response.code is 200 (I think it should be 202).  url is valid, but the basic HTTP authentication doesn't seem to have worked, because the shortened URL isn't in my list of URLs (at ).  After reading  I also tried:     TRIM_API_URL = 'api.tr.im/api'    password_mgr = urllib2.HTTPPasswordMgrWithDefaultRealm()    password_mgr.add_password(None, TRIM_API_URL, USERNAME, PASSWORD)    auth_handler = urllib2.HTTPBasicAuthHandler(password_mgr)    opener = urllib2.build_opener(auth_handler)    urllib2.install_opener(opener)    response = urllib2.urlopen('http://%s/trim_simple?url=%s'                               % (TRIM_API_URL, url_to_trim))    url = response.read().strip()   But I get the same results.  (response.code is 200 and url is valid, but not recorded in my account at .)  If I use query string parameters instead of basic HTTP authentication, like this:     TRIM_API_URL = 'http://api.tr.im/api'    response = urllib2.urlopen('%s/trim_simple?url=%s&amp;username=%s&amp;password=%s'                               % (TRIM_API_URL,                                  url_to_trim,                                  USERNAME,                                  PASSWORD))    url = response.read().strip()   ...then not only is url valid but it's recorded in my tr.im account. (Though response.code is still 200.)  There must be something wrong with my code though (and not tr.im's API), because  $ curl -u yacitus:xxxx http://api.tr.im/api/trim_url.json?url=http://www.google.co.uk   ...returns:  {"trimpath":"hfhb","reference":"nH45bftZDWOX0QpVojeDbOvPDnaRaJ","trimmed":"11\/03\/2009","destination":"http:\/\/www.google.co.uk\/","trim_path":"hfhb","domain":"google.co.uk","url":"http:\/\/tr.im\/hfhb","visits":0,"status":{"result":"OK","code":"200","message":"tr.im URL Added."},"date_time":"2009-03-11T10:15:35-04:00"}   ...and the URL does appear in my list of URLs on .  And if I run:  $ curl -u yacitus:xxxx http://api.tr.im/api/trim_url.json?url=http://www.google.co.uk   ...again, I get:  {"trimpath":"hfhb","reference":"nH45bftZDWOX0QpVojeDbOvPDnaRaJ","trimmed":"11\/03\/2009","destination":"http:\/\/www.google.co.uk\/","trim_path":"hfhb","domain":"google.co.uk","url":"http:\/\/tr.im\/hfhb","visits":0,"status":{"result":"OK","code":"201","message":"tr.im URL Already Created [yacitus]."},"date_time":"2009-03-11T10:15:35-04:00"}   Note code is 201, and message is "tr.im URL Already Created [yacitus]."  I must not be doing the basic HTTP authentication correctly (in either attempt).  Can you spot my problem?  Perhaps I should look and see what's being sent over the wire?  I've never done that before.  Are there Python APIs I can use (perhaps in pdb)?  Or is there another tool (preferably for Mac OS X) I can use? What is the best way to filter a Java Collection? I can't seem to find info on installing a Swedish language package on my machine. The language is not listed  and the hits on Google I got led nowhere (or, rather, to the said page).  Where can I ask such a question (within the realm of Stack Exchange)? Why is the atmosphere transparent in the visible spectrum? One of the great 'coincidences' in physics is that the Sun happens to shine most brightly at exactly the wavelengths our eyes can see; it's an easy explanation that our eyes evolved to make the most out of what was available.  However, this spectral window is also , with Rayleigh scattering and the ozone layer protecting us from the UV and strong water vapour absorption in the IR until way into the radio range.  My question is: is this a coincidence? Were there geological factors that made it so? Or is it just lucky chance? (I also notice other planets in our neighbourhood weren't quite so lucky.) Or had atmospheric absorption been different our eyes would have tuned to whatever spectral window were brighter as a whole? Can I draw something on my card and play tournaments with it? Just out of curiosity, what can I do to the card, so it's still legal to play it in official tournaments?   Can I draw something over ruling texts?  Can I draw something over artwork? Can I draw something over mana cost? Can I draw something over its name?   I'll be glad to see some official rulings about it. :) I want to express $$\sum_{n=-\infty}^\infty \dfrac{1}{(z+n)^2+a^2}$$ in closed form. What comes to mind is the formula $$\pi\cot\pi z = \dfrac{1}{z}+\sum_{n\ne 0}\left(\dfrac{1}{z-n}+\dfrac1n\right)=\dfrac{1}{z}+\sum_{n=1}^\infty\dfrac{2z}{z^2-n^2}$$  and also $$\dfrac{\pi^2}{\sin^2\pi z}=\sum_{n=-\infty}^\infty \dfrac{1}{(z-n)^2}.$$ But neither of these gives the term $(z+n)^2+a^2$ that we want. Perhaps we can adjust somehow? Proving that a function has a removable singularity at infinity Where are the pristine, untouched contents of a ~/.profile file? Is there a Linux equivalent of Windows' "resource files"? I remember reading a while back about arithmetics with only a single operator that did all the work of the familiar $+ - \times /$ operators. If there is such a thing, could someone point me to it?  As background: I have a side project where I'm playing with neural nets and genetic search algorithms. Right now it's the good old kind, with matrix multiplication and addition. I thought it would be interesting to implement a sort of neural network that used a combined or "all in one" operator.  I've googled like heck and can't pick up the trail of where I thought I saw that before.  Is there study in that area, or am I mis-remembering, or worse, just making it up? I'd appreciate any pointers. What is the function of this circuit? Just wondering if someone can give me an explanation for this capacitor layout - what is it's function? The chip to the right is an ADC.  Circled in blue.    I'm guessing it is well known but i don't know how to search for it. What exactly is a photon? Consider the question, .  The answers say, "an elementary particle" and not much else. They don't actually answer the question. Moreover, the question is flagged as a duplicate of,  &ndash; the answers there don't tell me what a photon is either. Nor do any of the answers to  mentioned in the comments. When I search on , I can't find anything useful. Questions such as,  look promising, but bear no fruit.  say things like, "the photon is an excitation of the photon field." That tells me  nothing. Nor does the , which says:     The photon is the quantum of the electromagnetic four-potential, and therefore the massless bosonic particle associated with the electromagnetic force, commonly also called the 'particle of light'...   I'd say that's less than helpful because it gives the impression that photons are forever popping into existence and flying back and forth exerting force. This same concept is in the  too - but it isn't true. As , "Virtual particles only exist in the mathematics of the model." So, who can tell me what a real photon is, or refer me to some kind of authoritative informative definition that is accepted and trusted by particle physicists? I say all this because I think it's of paramount importance. If we have no clear idea of what a photon actually is, we lack foundation. It's like what :     Photons seem to be one of the foundation ideas of quantum mechanics, so I am concerned that without a clear definition or set of concrete examples, the basis for understanding quantum experiments is a little fuzzy.   I second that, only more so. How can we understand pair production if we don't understand what the photon is? Or the electron? Or the electromagnetic field? Or everything else? It all starts with the photon.   I will give a 400-point bounty to the least-worst answer to the question. One answer will get the bounty, even if I don't like it. And the question is this:    What exactly is a photon? How to stop Skype from starting automatically when booting Windows 10? Permalinks: custom post type -> custom taxonomy -> post I am having trouble working with WordPress rewrite rules, and could use some help.  I have a custom post type called _shows_.  All shows have a single custom taxonomy category _show-category_. A _show_ will never have more than one _show-category_.  I would like my urls to route in this manner:  www.mysite.com/shows/  =&gt;  archive-shows.php  www.mysite.com/shows/%category%/ =&gt; taxonomy-show-category.php  www.mysite.com/shows/%category%/%postname%/ =&gt; single-shows.php   So as a real world example, lets say we have a _show-category_ "Foo" and a _show_ post titled "Bar" that has "Foo" as it's _show-category_. I would expect my WordPress app to look like this:  www.mysite.com/shows/foo/ =&gt; shows all posts under the foo category www.mysite.com/shows/foo/bar =&gt; shows the indivual post   I try to avoid plugins when possible, but am open to any solution. biblatex - issue number of journal in date Well, you can see it for yourself. The badge multiplier is a bit misaligned. Can you fix this please? (I know it's kinda a minor issue but it's bugging me and it's somehow off)    If it helps, I'm using Chrome version 44.0.2403.125 m. (Also repro'ed on FireFox 39.0 and )    For no good reason, that's a screenie from 's profile page. How can I convince hyperref and xindy to play together nicely? I am trying to restore a database with the following command:  $ sudo -u postgres pg_restore -C -d dvdrental dvdrental.tar  [sudo] password for t:    However, I am receiving the following error message:      could not change directory to "/home/t/mydata/.../relation model/SQL/implementations/Implementations, i.e. relational database management systems/postgreSQL/general/web/postgresqltutorial/databases": Permission denied      pg_restore: [archiver] could not open input file "dvdrental.tar": No such file or directory   I was wondering why I can't change directory to the current directory with permission denied?  File permission bits are:   -rw-rw-r-- 1 t t 2838016 May 26  2013 dvdrental.tar   Is it because one of its ancestry directory is not both readable and executable by any one?  The file has  many ancestry directories, and how can I verify that? What are the drawbacks with using UUID or GUID as a primary key? I would like to build a distributed system. I need to store data in databases and it would be helpful to use an  or a  as a primary key on some tables. I assume it's a drawbacks with this design since the UUID/GUID is quite large and they are almost random. The alternative is to use an auto-incremented INT or LONG.  What are the drawbacks with using UUID or GUID as a primary key for my tables?  I will probably use Derby/JavaDB (on the clients) and PostgreSQL (on the server) as DBMS.