-
Notifications
You must be signed in to change notification settings - Fork 1
/
latincharstoutf8.sql
37 lines (37 loc) · 1.79 KB
/
latincharstoutf8.sql
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
update catalog_product_entity_text set value = replace(value, cast(_latin1 0x91 as char(1) character set utf8), "'"); -- left single quote
update catalog_product_entity_text set value = replace(value, cast(_latin1 0x92 as char(1) character set utf8), "'"); -- right single quote
update catalog_product_entity_text set value = replace(value, cast(_latin1 0x93 as char(1) character set utf8), '"'); -- left double quote
update catalog_product_entity_text set value = replace(value, cast(_latin1 0x94 as char(1) character set utf8), '"'); -- right double quote
update catalog_product_entity_text set value = replace(value, cast(_latin1 0x99 as char(1) character set utf8), '™'); -- TM
--0x80 0x20AC #EURO SIGN
--0x81 #UNDEFINED
--0x82 0x201A #SINGLE LOW-9 QUOTATION MARK
--0x83 0x0192 #LATIN SMALL LETTER F WITH HOOK
--0x84 0x201E #DOUBLE LOW-9 QUOTATION MARK
--0x85 0x2026 #HORIZONTAL ELLIPSIS
--0x86 0x2020 #DAGGER
--0x87 0x2021 #DOUBLE DAGGER
--0x88 0x02C6 #MODIFIER LETTER CIRCUMFLEX ACCENT
--0x89 0x2030 #PER MILLE SIGN
--0x8A 0x0160 #LATIN CAPITAL LETTER S WITH CARON
--0x8B 0x2039 #SINGLE LEFT-POINTING ANGLE QUOTATION MARK
--0x8C 0x0152 #LATIN CAPITAL LIGATURE OE
--0x8D #UNDEFINED
--0x8E 0x017D #LATIN CAPITAL LETTER Z WITH CARON
--0x8F #UNDEFINED
--0x90 #UNDEFINED
--0x91 0x2018 #LEFT SINGLE QUOTATION MARK
--0x92 0x2019 #RIGHT SINGLE QUOTATION MARK
--0x93 0x201C #LEFT DOUBLE QUOTATION MARK
--0x94 0x201D #RIGHT DOUBLE QUOTATION MARK
--0x95 0x2022 #BULLET
--0x96 0x2013 #EN DASH
--0x97 0x2014 #EM DASH
--0x98 0x02DC #SMALL TILDE
--0x99 0x2122 #TRADE MARK SIGN
--0x9A 0x0161 #LATIN SMALL LETTER S WITH CARON
--0x9B 0x203A #SINGLE RIGHT-POINTING ANGLE QUOTATION MARK
--0x9C 0x0153 #LATIN SMALL LIGATURE OE
--0x9D #UNDEFINED
--0x9E 0x017E #LATIN SMALL LETTER Z WITH CARON
--0x9F 0x0178 #LATIN CAPITAL LETTER Y WITH DIAERESIS