Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options answers only user 1876
1
vote
In MySQL, you state two independent things: The encoding of the bytes in the client, and The encoding in the column in the table. That is, you can have one of them be utf8 and the other be latin2 …
answered Oct 18 '16 by Rick James
0
votes
Don't go changing the text until you have verified that it was stored incorrectly, and not merely read incorrectly. Use HEX() as mentioned in "Test the data" in https://stackoverflow.com/a/38363567/1 …
answered Jul 22 '16 by Rick James
4
votes
-bit stuff) is a subset of latin1 and of utf8mb4. As such, the encoding is identical, so no space difference will be seen for purely ascii text. However, there are a few hiccups when you declare … correctly say what encoding is used in the client. There must be a mapping between the two charsets. (English always maps. (Western Europe can map among latin1, utf8, utf8mb4, but not much else.) …
answered Jul 19 '17 by Rick James
2
votes
Mojibake or double encoding. Please provide SELECT col, HEX(col) FROM tbl WHERE ... to see whether the data is stored correctly. If correctly encoded for storage, è will be hex c3a8. Don't run your app as root; it ignores init-connect, but you need the SET NAMES (or equivalent). …
answered Dec 3 '15 by Rick James
1
vote
Thanks for the minimal test case. Your TEXT column is declared to be latin1; there is no "dotless i", in latin1, so it was converted from utf8's hex C4B1 to ? during INSERT. Change the table declara …
answered Mar 25 '15 by Rick James
9
votes
There are two possible questions here, and they have two different answers -- How do I make all new tables utf8mb4 It can be done (for one database) while creating a database: CREATE DATABASE dbnam …
answered Dec 16 '15 by Rick James
0
votes
You are saying (in both cases) that an INSERT of xml containing 😏 was performed. And that it worked in the first case, but gave an error in the second case? Describe the client -- its connection pa …
answered Mar 7 '16 by Rick James
0
votes
expected? Etc. (See that link.) Dump the hex from the table; it should be E0A4B9 E0A4BF E0A4A8 E0A58D E0A4A6 E0A580 for those letters and signs. C3A0 C2A4 ... would indicate "double encoding". I point … out the hex because your statement 'changed into "हरिà" in database but looking correct in webpage' could be caused by either Mojibake or double encoding -- depending on whether the coding …
answered Dec 3 '17 by Rick James
0
votes
Show us what you did to (1) use utf8 in the client(s), (2) how you established the charset from client to server, and (3) SHOW CREATE TABLE. If you left out any one of those, that that is likely to b …
answered May 16 '15 by Rick James
1
vote
That won't fix or recognize any malformed data already in the table. Yes, that is a good technique. ALTER..CONVERT TO.. does the bulk of the work. And, since utf8 is a subset of utf8mb4, there shou …
answered Jul 11 '18 by Rick James
1
vote
Where does Ö sort? utf8_estonian_ci: Between 'W' and 'X' danish, icelandic, swedish: After 'Z' utf8_gernan2_ci: As if the two letters 'oe' hungarian and turkish: Between 'O' and 'P' (that is, after …
answered Aug 26 '18 by Rick James