I have a table in MYSQL. It is defined as character set - utf8, collation: utf8_general_ci. The ITEM_TITLE column defined as a varchar. I have this query: UPDATE  details SET ITEM_TITLE="★32GB VALUE PACK★ Sony Xperia miro ST23i 4GB Int     White with silver" WHERE TaskID=109 The result is that in the column ITEM_TITLE i have a title without the ★ and with "?" instead.   THE QUESTION: What should i do, in order to save "★" in the DB properly?  **I found a solution for SQL server - using Nvarchar and not varchar but there is no such type in MySQL.  Answer: I understood what was the problem and why the solution that worked for someone, didnt work for me. First off all, the default for my DB is charset latin. So i changed it to UTF-8 but it didnt solve the issue. The reason for that is that i had a charset latin for most of the rows. I didnt know that it is set automatically for varchar and doesnt change even when i set the table as UTF-8. So I changed everything to UTF-8 and it works fix.  Thanks for all the help!
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 was Thor able to dent Captain America's Shield? I was reading about Adamantium on the      Proto-Adamantium   This is the original Adamantium created by Dr. MacLain. Proto-Adamantium is the official name for the metal that makes up Captain America's Shield. It has never been recreated and is the absolute most invulnerable item in all of existence.    This lead me to read about      The true shield was once slightly dented by an enraged Odinforce empowered Thor, using Mjolnir, but he later reconciled and pounded out the small dent.    Was the dent caused by Odinforce or Thor's Hammer? Is Mjolnir or Captain America's Shield "the absolute most invulnerable item in all of existence"? To be clear on this, I know what is the definition of an inner product space and some properties and theorems about them. What I am asking for is an intuition for this definition in the complex case. In the real case, the intuition (or at least one of them) is  geometric: The inner product of two vectors is the length of the projection of the first to the second scaled by the norms of both vectors so that it is symmetric (modulo some details). In particular I (and everybody else) think of "inner product zero" as geometric orthogonality and of orthonormal bases as, well, orthonormal bases and so on. The question is, what should I think about when working with complex (or should I say hermitian?) inner product spaces? what is the "meaning" of the complex number associated to two vectors called their inner product?  I will be happy to hear all kinds of answers. For example, what physical phenomena does it model or in what mathematical situations does in "naturally" appear. Answers that stress the "nice structure" resulting are also welcome, yet I feel that by itself  it is a bit unsatisfying. When can a hyphen ("-") be used, and what does it mean? I've seen the hyphen (-) used in phrases a lot, for example:     audience-knowing      moves-sometimes      do-gooder   When and why is the hyphen used, and what does it mean when it's used? $(m, m+2)$ is twin prime, iff $4((m-1)! + 1) \equiv -m \pmod {m(m+2)}$ The Wiki page on  says     The pair $(m, m+2)$ is twin prime, iff $4((m-1)! + 1) \equiv -m \pmod {m(m+2)}$.   This is obviously connected to Wilson's Theorem. Can anybody provide a proof for that, along the lines of thought given here, ? There are several ways to execute a script. The ones I know are: /path/to/script # using the path (absolute or relative) . script        # using the . (dot) source script   # using the `source` command  Are there any other way? What are the differences between them? Are there situations that I must use one and not another? Yesterday I started the upgrade from 12.10 to 13.04, but I interrupted it because it was taking too long. Now if I restart it, it doesn't proceed.  Is there any possibility to clean the mess it left when I interrupted it and make a clean restart of this update? Cauchy condensation test The following is Cauchy condensation test:  If $b_n \ge 0$ and $b_n \ge b_{n+1}$ then $\sum b_n$ converges if and only if $\sum 2^n b_{2^n}$ converges.  Is the following modified Cauchy condensation test possible:  Let $N \in \mathbb N$. Then if $b_n \ge 0$ and $b_n \ge b_{n+1}$ then $\sum b_n$ converges if and only if $\sum N^n b_{N^n}$ converges? About big parenthesis larger than Bigg I want to add a comma in the thousands place for a number.     String.Format()? What is the monomorphism restriction? What do you call a person who "shuts down" ideas? The units of $\mathbb Z[\sqrt{2}]$ Axiom of Choice: Where does my argument for proving the axiom of choice fail? Help me understand why this is an axiom, and not a theorem. In terms of purely set theory, the axiom of choice says that for any set $A$, its power set (with empty set removed) has a choice function, i.e. there exists a function $f\colon \mathcal{P}^*(A)\rightarrow A$ such that for any subset $S$ of $A$, $f(S)\in S.$ Is this correct?  My question then is about proving this fact, so that we do not need to put it as an axiom. Now as per the research done on this single object- Axiom of Choice, I believe here that there should be some falsity in my argument. I do not find the mistake.  For any $S\in \mathcal{P}^*(A)$, since $S\neq \emptyset$, $\exists s\in S$. Define $f(S)=s$. Then $f$ is a choice function.  This was showing me that the axiom of choice is proved, but then why it had been put as an axiom? For example, in  book, the author asserts that      It is a metatheorem of mathematical logic that it is impossible to specify the function that assigns to each non-empty subset of $\mathbb{R}$, an element of itself.     There are several notes and books on axiom of choice, but here I am trying to understand through doing some argument for some problem, where problem actually arises. Should there be a comma in 'a 30-day, money-back guarantee'? Finding $\int^{\infty}_{0}\frac{\ln^2(x)}{(1-x^2)^2} dx$ Today a student asked me $\int \ln (\sin x) \, dx.$ Calculate the integral $$\int \ln (\sin x) \, dx.$$ Agreeing on a single shortened nomenclature? I've noticed across various stack exchange sites that when they refer to their own stack exchange on their site, they'll shorten the name to something similar to either:  EE.SE (Electrical Engineering Stack Exchange) OR Tex.Sx (LaTeX Stack Exchange)  Essentially they'll do XX.SE or XX.SX which has the possibility to generate some confusion for new users.    Have I not visited enough sites and just noticed an outlier or would it be beneficial for Stack Exchange sites to agree on a shortened name nomenclature? What is the exact difference between fluid and responsive design? What is the exact difference between fluid and responsive design?  I am bit confused about fluid and responsive design. Fluid is the one where we give width in percentages so that design will look good on browsers even if shrink or expand the browser. But what's different about responsive? Does "the same number of people" behave as singular or plural? Different Google Searches return different titles for the same page