Beste
Ik het een lijst aan SQL queries:
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
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