UTF-8 geeft correct weer in texteditor, niet in MySQL tabel

Pagina: 1
Acties:

Acties:
  • 0 Henk 'm!

  • Carharttguy
  • Registratie: Juli 2010
  • Laatst online: 04-07 23:09
Beste

Ik het een lijst aan SQL queries:

code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
UPDATE Country SET symbol = "L" WHERE currency = "ALL";
UPDATE Country SET symbol = "؋" WHERE currency = "AFN";
UPDATE Country SET symbol = "$" WHERE currency = "ARS";
UPDATE Country SET symbol = "ƒ" WHERE currency = "AWG";
UPDATE Country SET symbol = "$" WHERE currency = "AUD";
UPDATE Country SET symbol = "₼" WHERE currency = "AZN";
UPDATE Country SET symbol = "$" WHERE currency = "BSD";
UPDATE Country SET symbol = "$" WHERE currency = "BBD";
UPDATE Country SET symbol = "p." WHERE currency = "BYR";
UPDATE Country SET symbol = "BZ$" WHERE currency = "BZD";
UPDATE Country SET symbol = "$" WHERE currency = "BMD";
UPDATE Country SET symbol = "Bs." WHERE currency = "BOB";
UPDATE Country SET symbol = "KM" WHERE currency = "BAM";
UPDATE Country SET symbol = "P" WHERE currency = "BWP";
UPDATE Country SET symbol = "лв" WHERE currency = "BGN";
UPDATE Country SET symbol = "R$" WHERE currency = "BRL";
UPDATE Country SET symbol = "$" WHERE currency = "BND";
UPDATE Country SET symbol = "៛" WHERE currency = "KHR";
UPDATE Country SET symbol = "$" WHERE currency = "CAD";
UPDATE Country SET symbol = "$" WHERE currency = "KYD";
UPDATE Country SET symbol = "$" WHERE currency = "CLP";
UPDATE Country SET symbol = "¥" WHERE currency = "CNY";
UPDATE Country SET symbol = "$" WHERE currency = "COP";
UPDATE Country SET symbol = "₡" WHERE currency = "CRC";
UPDATE Country SET symbol = "kn" WHERE currency = "HRK";
UPDATE Country SET symbol = "₱" WHERE currency = "CUP";
UPDATE Country SET symbol = "Kč" WHERE currency = "CZK";
UPDATE Country SET symbol = "kr" WHERE currency = "DKK";
UPDATE Country SET symbol = "RD$" WHERE currency = "DOP";
UPDATE Country SET symbol = "$" WHERE currency = "XCD";
UPDATE Country SET symbol = "£" WHERE currency = "EGP";
UPDATE Country SET symbol = "$" WHERE currency = "SVC";
UPDATE Country SET symbol = "kr" WHERE currency = "EEK";
UPDATE Country SET symbol = "€" WHERE currency = "EUR";
UPDATE Country SET symbol = "£" WHERE currency = "FKP";
UPDATE Country SET symbol = "$" WHERE currency = "FJD";
UPDATE Country SET symbol = "₵" WHERE currency = "GHC";
UPDATE Country SET symbol = "£" WHERE currency = "GIP";
UPDATE Country SET symbol = "Q" WHERE currency = "GTQ";
UPDATE Country SET symbol = "£" WHERE currency = "GGP";
UPDATE Country SET symbol = "$" WHERE currency = "GYD";
UPDATE Country SET symbol = "L" WHERE currency = "HNL";
UPDATE Country SET symbol = "$" WHERE currency = "HKD";
UPDATE Country SET symbol = "Ft" WHERE currency = "HUF";
UPDATE Country SET symbol = "kr" WHERE currency = "ISK";
UPDATE Country SET symbol = "₹" WHERE currency = "INR";
UPDATE Country SET symbol = "Rp" WHERE currency = "IDR";
UPDATE Country SET symbol = "﷼" WHERE currency = "IRR";
UPDATE Country SET symbol = "£" WHERE currency = "IMP";
UPDATE Country SET symbol = "₪" WHERE currency = "ILS";
UPDATE Country SET symbol = "J$" WHERE currency = "JMD";
UPDATE Country SET symbol = "¥" WHERE currency = "JPY";
UPDATE Country SET symbol = "£" WHERE currency = "JEP";
UPDATE Country SET symbol = "KSh" WHERE currency = "KES";
UPDATE Country SET symbol = "лв" WHERE currency = "KZT";
UPDATE Country SET symbol = "₩" WHERE currency = "KPW";
UPDATE Country SET symbol = "₩" WHERE currency = "KRW";
UPDATE Country SET symbol = "лв" WHERE currency = "KGS";
UPDATE Country SET symbol = "₭" WHERE currency = "LAK";
UPDATE Country SET symbol = "Ls" WHERE currency = "LVL";
UPDATE Country SET symbol = "£" WHERE currency = "LBP";
UPDATE Country SET symbol = "$" WHERE currency = "LRD";
UPDATE Country SET symbol = "Lt" WHERE currency = "LTL";
UPDATE Country SET symbol = "ден" WHERE currency = "MKD";
UPDATE Country SET symbol = "RM" WHERE currency = "MYR";
UPDATE Country SET symbol = "₨" WHERE currency = "MUR";
UPDATE Country SET symbol = "$" WHERE currency = "MXN";
UPDATE Country SET symbol = "₮" WHERE currency = "MNT";
UPDATE Country SET symbol = "MT" WHERE currency = "MZN";
UPDATE Country SET symbol = "$" WHERE currency = "NAD";
UPDATE Country SET symbol = "₨" WHERE currency = "NPR";
UPDATE Country SET symbol = "ƒ" WHERE currency = "ANG";
UPDATE Country SET symbol = "$" WHERE currency = "NZD";
UPDATE Country SET symbol = "C$" WHERE currency = "NIO";
UPDATE Country SET symbol = "₦" WHERE currency = "NGN";
UPDATE Country SET symbol = "kr" WHERE currency = "NOK";
UPDATE Country SET symbol = "﷼" WHERE currency = "OMR";
UPDATE Country SET symbol = "₨" WHERE currency = "PKR";
UPDATE Country SET symbol = "B/." WHERE currency = "PAB";
UPDATE Country SET symbol = "Gs" WHERE currency = "PYG";
UPDATE Country SET symbol = "S/." WHERE currency = "PEN";
UPDATE Country SET symbol = "₱" WHERE currency = "PHP";
UPDATE Country SET symbol = "zł" WHERE currency = "PLN";
UPDATE Country SET symbol = "﷼" WHERE currency = "QAR";
UPDATE Country SET symbol = "lei" WHERE currency = "RON";
UPDATE Country SET symbol = "₽" WHERE currency = "RUB";
UPDATE Country SET symbol = "¥" WHERE currency = "RMB";
UPDATE Country SET symbol = "£" WHERE currency = "SHP";
UPDATE Country SET symbol = "﷼" WHERE currency = "SAR";
UPDATE Country SET symbol = "Дин." WHERE currency = "RSD";
UPDATE Country SET symbol = "₨" WHERE currency = "SCR";
UPDATE Country SET symbol = "$" WHERE currency = "SGD";
UPDATE Country SET symbol = "$" WHERE currency = "SBD";
UPDATE Country SET symbol = "S" WHERE currency = "SOS";
UPDATE Country SET symbol = "R" WHERE currency = "ZAR";
UPDATE Country SET symbol = "₨" WHERE currency = "LKR";
UPDATE Country SET symbol = "kr" WHERE currency = "SEK";
UPDATE Country SET symbol = "CHF" WHERE currency = "CHF";
UPDATE Country SET symbol = "$" WHERE currency = "SRD";
UPDATE Country SET symbol = "£" WHERE currency = "SYP";
UPDATE Country SET symbol = "TSh" WHERE currency = "TZS";
UPDATE Country SET symbol = "NT$" WHERE currency = "TWD";
UPDATE Country SET symbol = "฿" WHERE currency = "THB";
UPDATE Country SET symbol = "TT$" WHERE currency = "TTD";
UPDATE Country SET symbol = "₺" WHERE currency = "TRY";
UPDATE Country SET symbol = "₤" WHERE currency = "TRL";
UPDATE Country SET symbol = "$" WHERE currency = "TVD";
UPDATE Country SET symbol = "USh" WHERE currency = "UGX";
UPDATE Country SET symbol = "₴" WHERE currency = "UAH";
UPDATE Country SET symbol = "£" WHERE currency = "GBP";
UPDATE Country SET symbol = "$" WHERE currency = "USD";
UPDATE Country SET symbol = "$U" WHERE currency = "UYU";
UPDATE Country SET symbol = "лв" WHERE currency = "UZS";
UPDATE Country SET symbol = "Bs" WHERE currency = "VEF";
UPDATE Country SET symbol = "₫" WHERE currency = "VND";
UPDATE Country SET symbol = "﷼" WHERE currency = "YER";
UPDATE Country SET symbol = "Z$" WHERE currency = "ZWD";


De symooltjes zijn juist, maar als ik ze in een MySQL tabel uitvoer zie ik op veel plaatsen een '?' of gewoon niets. Ik heb de collation veranderd naar UTF-8 of UTF-16, maar dat veranderd helemaal niets. Zie ik iets over het hoofd?

Edit: Hij fucked het hier blijkbaar ook, terwijl dat ik het wel kan lezen in de editor van T.net

Acties:
  • 0 Henk 'm!

  • orf
  • Registratie: Augustus 2005
  • Laatst online: 16:05

orf

Dit is goed (verstandig) om te lezen: http://www.joelonsoftware.com/articles/Unicode.html

Het is belangrijk dat je overal dezelfde encoding gebruikt. Je verbinding naar de database, je bestanden, je editor, etc.

Acties:
  • +1 Henk 'm!

  • DJMaze
  • Registratie: Juni 2002
  • Niet online
1. ؋ hoort niet in de database, daar plaats je het UTF-8 '؋' in een utf8mb4 kolom.
2. Vergeet niet dat je verbind in de utf8mb4 modus met de database, meeste software doet dat niet!
3. Je website moet wel de juist Content-Type header sturen.

Maak je niet druk, dat doet de compressor maar


Acties:
  • 0 Henk 'm!

  • Cartman!
  • Registratie: April 2000
  • Niet online
DJMaze schreef op vrijdag 14 oktober 2016 @ 13:13:
1. ؋ hoort niet in de database, daar plaats je het UTF-8 '؋' in een utf8mb4 kolom.
Ik vermoed dat het door React komt dat er hier in html entities staan en dat de queries zelf wel kloppen. Eens met de andere 2 punten overigens :)

[ Voor 6% gewijzigd door Cartman! op 15-10-2016 11:49 ]