Brains Coders

If you have uploaded data to SQL Server using the wrong collation, or imported a text file with the wrong encoding, you could end with data full of strange characters.

The problem is being caused by UTF-8/16 bytes being interpreted as Windows-1252 (or ISO 8859-1) bytes

Example: SQL Script to update three different table containing geographic names.

--ADMIN 0

Update [Adm0GeoBoundaries] Set [Adm0NameLocalized] =[Adm0Name];

Update [Adm0GeoBoundaries] Set [Adm0Name] = replace([Adm0Name], 'Ã¤', 'a'),[Adm0NameLocalized] = replace([Adm0NameLocalized], 'Ã¤', N'ä');

Update [Adm0GeoBoundaries] Set [Adm0Name] = replace([Adm0Name], 'Ã¡', 'a'),[Adm0NameLocalized] = replace([Adm0NameLocalized], 'Ã¡', N'á');

Update [Adm0GeoBoundaries] Set [Adm0Name] = replace([Adm0Name], 'Ã¢', 'a'),[Adm0NameLocalized] = replace([Adm0NameLocalized], 'Ã¢', N'â');

Update [Adm0GeoBoundaries] Set [Adm0Name] = replace([Adm0Name], 'Ã£', 'a'),[Adm0NameLocalized] = replace([Adm0NameLocalized], 'Ã£', N'ã');

Update [Adm0GeoBoundaries] Set [Adm0Name] = replace([Adm0Name], 'Ã¥', 'a'),[Adm0NameLocalized] = replace([Adm0NameLocalized], 'Ã¥', N'å');

Update [Adm0GeoBoundaries] Set [Adm0Name] = replace([Adm0Name], 'Ã¦', 'a'),[Adm0NameLocalized] = replace([Adm0NameLocalized], 'Ã¦', N'æ');

Update [Adm0GeoBoundaries] Set [Adm0Name] = replace([Adm0Name], 'Ã©', 'e'),[Adm0NameLocalized] = replace([Adm0NameLocalized], 'Ã©', N'é');

Update [Adm0GeoBoundaries] Set [Adm0Name] = replace([Adm0Name], 'Ã¨', 'e'),[Adm0NameLocalized] = replace([Adm0NameLocalized], 'Ã¨', N'è');

Update [Adm0GeoBoundaries] Set [Adm0Name] = replace([Adm0Name], 'Ãª', 'e'),[Adm0NameLocalized] = replace([Adm0NameLocalized], 'Ã©', N'ê');

Update [Adm0GeoBoundaries] Set [Adm0Name] = replace([Adm0Name], 'Ã«', 'e'),[Adm0NameLocalized] = replace([Adm0NameLocalized], 'Ã«', N'ë');

Update [Adm0GeoBoundaries] Set [Adm0Name] = replace([Adm0Name], 'Ã¬', 'i'),[Adm0NameLocalized] = replace([Adm0NameLocalized], 'Ã¬', N'ì');

Update [adm0GeoBoundaries] Set [adm0Name] = replace([adm0Name], 'Ã', 'i'),[adm0NameLocalized] = replace([adm0NameLocalized], 'Ã', N'í');

Update [Adm0GeoBoundaries] Set [Adm0Name] = replace([Adm0Name], 'Ã®', 'i'),[Adm0NameLocalized] = replace([Adm0NameLocalized], 'Ã®', N'î');

Update [Adm0GeoBoundaries] Set [Adm0Name] = replace([Adm0Name], 'Ã¯', 'i'),[Adm0NameLocalized] = replace([Adm0NameLocalized], 'Ã¯', N'ï');

Update [Adm0GeoBoundaries] Set [Adm0Name] = replace([Adm0Name], 'Ã²', 'o'),[Adm0NameLocalized] = replace([Adm0NameLocalized], 'Ã²', N'ò');

Update [Adm0GeoBoundaries] Set [Adm0Name] = replace([Adm0Name], 'Ã³', 'o'),[Adm0NameLocalized] = replace([Adm0NameLocalized], 'Ã³', N'ó');

Update [Adm0GeoBoundaries] Set [Adm0Name] = replace([Adm0Name], 'Ã´', 'o'),[Adm0NameLocalized] = replace([Adm0NameLocalized], 'Ã´', N'ô');

Update [Adm0GeoBoundaries] Set [Adm0Name] = replace([Adm0Name], 'Ãµ', 'o'),[Adm0NameLocalized] = replace([Adm0NameLocalized], 'Ãµ', N'õ');

Update [Adm0GeoBoundaries] Set [Adm0Name] = replace([Adm0Name], 'Ã¶', 'o'),[Adm0NameLocalized] = replace([Adm0NameLocalized], 'Ã¶', N'ö');

Update [Adm0GeoBoundaries] Set [Adm0Name] = replace([Adm0Name], 'Ã¹', 'u'),[Adm0NameLocalized] = replace([Adm0NameLocalized], 'Ã¹', N'ù');

Update [Adm0GeoBoundaries] Set [Adm0Name] = replace([Adm0Name], 'Ãº', 'u'),[Adm0NameLocalized] = replace([Adm0NameLocalized], 'Ãº', N'ú');

Update [Adm0GeoBoundaries] Set [Adm0Name] = replace([Adm0Name], 'Ã»', 'u'),[Adm0NameLocalized] = replace([Adm0NameLocalized], 'Ã»', N'û');

Update [Adm0GeoBoundaries] Set [Adm0Name] = replace([Adm0Name], 'Ã¼', 'u'),[Adm0NameLocalized] = replace([Adm0NameLocalized], 'Ã¼', N'ü');

Update [Adm0GeoBoundaries] Set [Adm0Name] = replace([Adm0Name], 'Ã§', N'ç'),[Adm0NameLocalized] = replace([Adm0NameLocalized], 'Ã§', N'ç');

Update [Adm0GeoBoundaries] Set [Adm0Name] = replace([Adm0Name], 'Ã±', N'ñ'),[Adm0NameLocalized] = replace([Adm0NameLocalized], 'Ã±', N'ñ');

Update [Adm0GeoBoundaries] Set [Adm0Name] = replace([Adm0Name], 'Â°', N'°'),[Adm0NameLocalized] = replace([Adm0NameLocalized], 'Â°', N'°');

--ADMIN1

Update [adm1GeoBoundaries] Set [adm1NameLocalized] =[adm1Name];

BEGIN TRAN T1;

Update [adm1GeoBoundaries] Set [adm1Name] = replace([adm1Name], 'Ã¤', 'a'),[adm1NameLocalized] = replace([adm1NameLocalized], 'Ã¤', N'ä');

Update [adm1GeoBoundaries] Set [adm1Name] = replace([adm1Name], 'Ã¡', 'a'),[adm1NameLocalized] = replace([adm1NameLocalized], 'Ã¡', N'á');

Update [adm1GeoBoundaries] Set [adm1Name] = replace([adm1Name], 'Ã¢', 'a'),[adm1NameLocalized] = replace([adm1NameLocalized], 'Ã¢', N'â');

Update [adm1GeoBoundaries] Set [adm1Name] = replace([adm1Name], 'Ã£', 'a'),[adm1NameLocalized] = replace([adm1NameLocalized], 'Ã£', N'ã');

Update [adm1GeoBoundaries] Set [adm1Name] = replace([adm1Name], 'Ã¥', 'a'),[adm1NameLocalized] = replace([adm1NameLocalized], 'Ã¥', N'å');

Update [adm1GeoBoundaries] Set [adm1Name] = replace([adm1Name], 'Ã¦', 'a'),[adm1NameLocalized] = replace([adm1NameLocalized], 'Ã¦', N'æ');

Update [adm1GeoBoundaries] Set [adm1Name] = replace([adm1Name], 'Ã©', 'e'),[adm1NameLocalized] = replace([adm1NameLocalized], 'Ã©', N'é');

Update [adm1GeoBoundaries] Set [adm1Name] = replace([adm1Name], 'Ã¨', 'e'),[adm1NameLocalized] = replace([adm1NameLocalized], 'Ã¨', N'è');

Update [adm1GeoBoundaries] Set [adm1Name] = replace([adm1Name], 'Ãª', 'e'),[adm1NameLocalized] = replace([adm1NameLocalized], 'Ã©', N'ê');

Update [adm1GeoBoundaries] Set [adm1Name] = replace([adm1Name], 'Ã«', 'e'),[adm1NameLocalized] = replace([adm1NameLocalized], 'Ã«', N'ë');

Update [adm1GeoBoundaries] Set [adm1Name] = replace([adm1Name], 'Ã¬', 'i'),[adm1NameLocalized] = replace([adm1NameLocalized], 'Ã¬', N'ì');

Update [adm1GeoBoundaries] Set [adm1Name] = replace([adm1Name], 'Ã', 'i'),[adm1NameLocalized] = replace([adm1NameLocalized], 'Ã', N'í');

Update [adm1GeoBoundaries] Set [adm1Name] = replace([adm1Name], 'Ã®', 'i'),[adm1NameLocalized] = replace([adm1NameLocalized], 'Ã®', N'î');

Update [adm1GeoBoundaries] Set [adm1Name] = replace([adm1Name], 'Ã¯', 'i'),[adm1NameLocalized] = replace([adm1NameLocalized], 'Ã¯', N'ï');

COMMIT TRAN T1;

BEGIN TRAN T2;

Update [adm1GeoBoundaries] Set [adm1Name] = replace([adm1Name], 'Ã²', 'o'),[adm1NameLocalized] = replace([adm1NameLocalized], 'Ã²', N'ò');

Update [adm1GeoBoundaries] Set [adm1Name] = replace([adm1Name], 'Ã³', 'o'),[adm1NameLocalized] = replace([adm1NameLocalized], 'Ã³', N'ó');

Update [adm1GeoBoundaries] Set [adm1Name] = replace([adm1Name], 'Ã´', 'o'),[adm1NameLocalized] = replace([adm1NameLocalized], 'Ã´', N'ô');

Update [adm1GeoBoundaries] Set [adm1Name] = replace([adm1Name], 'Ãµ', 'o'),[adm1NameLocalized] = replace([adm1NameLocalized], 'Ãµ', N'õ');

Update [adm1GeoBoundaries] Set [adm1Name] = replace([adm1Name], 'Ã¶', 'o'),[adm1NameLocalized] = replace([adm1NameLocalized], 'Ã¶', N'ö');

Update [adm1GeoBoundaries] Set [adm1Name] = replace([adm1Name], 'Ã¹', 'u'),[adm1NameLocalized] = replace([adm1NameLocalized], 'Ã¹', N'ù');

Update [adm1GeoBoundaries] Set [adm1Name] = replace([adm1Name], 'Ãº', 'u'),[adm1NameLocalized] = replace([adm1NameLocalized], 'Ãº', N'ú');

Update [adm1GeoBoundaries] Set [adm1Name] = replace([adm1Name], 'Ã»', 'u'),[adm1NameLocalized] = replace([adm1NameLocalized], 'Ã»', N'û');

Update [adm1GeoBoundaries] Set [adm1Name] = replace([adm1Name], 'Ã¼', 'u'),[adm1NameLocalized] = replace([adm1NameLocalized], 'Ã¼', N'ü');

Update [adm1GeoBoundaries] Set [adm1Name] = replace([adm1Name], 'Ã§', N'ç'),[adm1NameLocalized] = replace([adm1NameLocalized], 'Ã§', N'ç');

Update [adm1GeoBoundaries] Set [adm1Name] = replace([adm1Name], 'Ã±', N'ñ'),[adm1NameLocalized] = replace([adm1NameLocalized], 'Ã±', N'ñ');

Update [adm1GeoBoundaries] Set [adm1Name] = replace([adm1Name], 'Â°', N'°'),[adm1NameLocalized] = replace([adm1NameLocalized], 'Â°', N'°');

COMMIT TRAN T2;

--ADMIN2

Update [adm2GeoBoundaries] Set [adm2NameLocalized] =[adm2Name];

BEGIN TRAN T3;

Update [adm2GeoBoundaries] Set [adm2Name] = replace([adm2Name], 'Ã¤', 'a'),[adm2NameLocalized] = replace([adm2NameLocalized], 'Ã¤', N'ä');

Update [adm2GeoBoundaries] Set [adm2Name] = replace([adm2Name], 'Ã¡', 'a'),[adm2NameLocalized] = replace([adm2NameLocalized], 'Ã¡', N'á');

Update [adm2GeoBoundaries] Set [adm2Name] = replace([adm2Name], 'Ã¢', 'a'),[adm2NameLocalized] = replace([adm2NameLocalized], 'Ã¢', N'â');

Update [adm2GeoBoundaries] Set [adm2Name] = replace([adm2Name], 'Ã£', 'a'),[adm2NameLocalized] = replace([adm2NameLocalized], 'Ã£', N'ã');

Update [adm2GeoBoundaries] Set [adm2Name] = replace([adm2Name], 'Ã¥', 'a'),[adm2NameLocalized] = replace([adm2NameLocalized], 'Ã¥', N'å');

Update [adm2GeoBoundaries] Set [adm2Name] = replace([adm2Name], 'Ã¦', 'a'),[adm2NameLocalized] = replace([adm2NameLocalized], 'Ã¦', N'æ');

Update [adm2GeoBoundaries] Set [adm2Name] = replace([adm2Name], 'Ã©', 'e'),[adm2NameLocalized] = replace([adm2NameLocalized], 'Ã©', N'é');

Update [adm2GeoBoundaries] Set [adm2Name] = replace([adm2Name], 'Ã¨', 'e'),[adm2NameLocalized] = replace([adm2NameLocalized], 'Ã¨', N'è');

Update [adm2GeoBoundaries] Set [adm2Name] = replace([adm2Name], 'Ãª', 'e'),[adm2NameLocalized] = replace([adm2NameLocalized], 'Ã©', N'ê');

Update [adm2GeoBoundaries] Set [adm2Name] = replace([adm2Name], 'Ã«', 'e'),[adm2NameLocalized] = replace([adm2NameLocalized], 'Ã«', N'ë');

Update [adm2GeoBoundaries] Set [adm2Name] = replace([adm2Name], 'Ã¬', 'i'),[adm2NameLocalized] = replace([adm2NameLocalized], 'Ã¬', N'ì');

Update [adm2GeoBoundaries] Set [adm2Name] = replace([adm2Name], 'Ã', 'i'),[adm2NameLocalized] = replace([adm2NameLocalized], 'Ã', N'í');

Update [adm2GeoBoundaries] Set [adm2Name] = replace([adm2Name], 'Ã®', 'i'),[adm2NameLocalized] = replace([adm2NameLocalized], 'Ã®', N'î');

Update [adm2GeoBoundaries] Set [adm2Name] = replace([adm2Name], 'Ã¯', 'i'),[adm2NameLocalized] = replace([adm2NameLocalized], 'Ã¯', N'ï');

COMMIT TRAN T3;

BEGIN TRAN T4;

Update [adm2GeoBoundaries] Set [adm2Name] = replace([adm2Name], 'Ã²', 'o'),[adm2NameLocalized] = replace([adm2NameLocalized], 'Ã²', N'ò');

Update [adm2GeoBoundaries] Set [adm2Name] = replace([adm2Name], 'Ã³', 'o'),[adm2NameLocalized] = replace([adm2NameLocalized], 'Ã³', N'ó');

Update [adm2GeoBoundaries] Set [adm2Name] = replace([adm2Name], 'Ã´', 'o'),[adm2NameLocalized] = replace([adm2NameLocalized], 'Ã´', N'ô');

Update [adm2GeoBoundaries] Set [adm2Name] = replace([adm2Name], 'Ãµ', 'o'),[adm2NameLocalized] = replace([adm2NameLocalized], 'Ãµ', N'õ');

Update [adm2GeoBoundaries] Set [adm2Name] = replace([adm2Name], 'Ã¶', 'o'),[adm2NameLocalized] = replace([adm2NameLocalized], 'Ã¶', N'ö');

Update [adm2GeoBoundaries] Set [adm2Name] = replace([adm2Name], 'Ã¹', 'u'),[adm2NameLocalized] = replace([adm2NameLocalized], 'Ã¹', N'ù');

Update [adm2GeoBoundaries] Set [adm2Name] = replace([adm2Name], 'Ãº', 'u'),[adm2NameLocalized] = replace([adm2NameLocalized], 'Ãº', N'ú');

Update [adm2GeoBoundaries] Set [adm2Name] = replace([adm2Name], 'Ã»', 'u'),[adm2NameLocalized] = replace([adm2NameLocalized], 'Ã»', N'û');

Update [adm2GeoBoundaries] Set [adm2Name] = replace([adm2Name], 'Ã¼', 'u'),[adm2NameLocalized] = replace([adm2NameLocalized], 'Ã¼', N'ü');

Update [adm2GeoBoundaries] Set [adm2Name] = replace([adm2Name], 'Ã§', N'ç'),[adm2NameLocalized] = replace([adm2NameLocalized], 'Ã§', N'ç');

Update [adm2GeoBoundaries] Set [adm2Name] = replace([adm2Name], 'Ã±', N'ñ'),[adm2NameLocalized] = replace([adm2NameLocalized], 'Ã±', N'ñ');

Update [adm2GeoBoundaries] Set [adm2Name] = replace([adm2Name], 'Â°', N'°'),[adm2NameLocalized] = replace([adm2NameLocalized], 'Â°', N'°');

COMMIT TRAN T4;

The script has been built on the following table:

Table for Debugging Common UTF-8 Character Encoding Problems.
Code Point		Characters		UTF-8 Bytes	Code Point		Characters		UTF-8 Bytes
Unicode	Windows 1252	Expected	Actual	UTF-8 Bytes	Unicode	Windows 1252	Expected	Actual	UTF-8 Bytes
U+20AC	0x80	€	â‚¬	%E2 %82 %AC	U+00C0	0xC0	À	Ã€	%C3 %80
	0x81				U+00C1	0xC1	Á	Ã	%C3 %81
U+201A	0x82	‚	â€š	%E2 %80 %9A	U+00C2	0xC2	Â	Ã‚	%C3 %82
U+0192	0x83	ƒ	Æ’	%C6 %92	U+00C3	0xC3	Ã	Ãƒ	%C3 %83
U+201E	0x84	„	â€ž	%E2 %80 %9E	U+00C4	0xC4	Ä	Ã„	%C3 %84
U+2026	0x85	…	â€¦	%E2 %80 %A6	U+00C5	0xC5	Å	Ã…	%C3 %85
U+2020	0x86	†	â€	%E2 %80 %A0	U+00C6	0xC6	Æ	Ã†	%C3 %86
U+2021	0x87	‡	â€¡	%E2 %80 %A1	U+00C7	0xC7	Ç	Ã‡	%C3 %87
U+02C6	0x88	ˆ	Ë†	%CB %86	U+00C8	0xC8	È	Ãˆ	%C3 %88
U+2030	0x89	‰	â€°	%E2 %80 %B0	U+00C9	0xC9	É	Ã‰	%C3 %89
U+0160	0x8A	Š	Å	%C5 %A0	U+00CA	0xCA	Ê	ÃŠ	%C3 %8A
U+2039	0x8B	‹	â€¹	%E2 %80 %B9	U+00CB	0xCB	Ë	Ã‹	%C3 %8B
U+0152	0x8C	Œ	Å’	%C5 %92	U+00CC	0xCC	Ì	ÃŒ	%C3 %8C
	0x8D				U+00CD	0xCD	Í	Ã	%C3 %8D
U+017D	0x8E	Ž	Å½	%C5 %BD	U+00CE	0xCE	Î	ÃŽ	%C3 %8E
	0x8F				U+00CF	0xCF	Ï	Ã	%C3 %8F
	0x90				U+00D0	0xD0	Ð	Ã	%C3 %90
U+2018	0x91	‘	â€˜	%E2 %80 %98	U+00D1	0xD1	Ñ	Ã‘	%C3 %91
U+2019	0x92	’	â€™	%E2 %80 %99	U+00D2	0xD2	Ò	Ã’	%C3 %92
U+201C	0x93	“	â€œ	%E2 %80 %9C	U+00D3	0xD3	Ó	Ã“	%C3 %93
U+201D	0x94	”	â€	%E2 %80 %9D	U+00D4	0xD4	Ô	Ã”	%C3 %94
U+2022	0x95	•	â€¢	%E2 %80 %A2	U+00D5	0xD5	Õ	Ã•	%C3 %95
U+2013	0x96	–	â€“	%E2 %80 %93	U+00D6	0xD6	Ö	Ã–	%C3 %96
U+2014	0x97	—	â€”	%E2 %80 %94	U+00D7	0xD7	×	Ã—	%C3 %97
U+02DC	0x98	˜	Ëœ	%CB %9C	U+00D8	0xD8	Ø	Ã˜	%C3 %98
U+2122	0x99	™	â„¢	%E2 %84 %A2	U+00D9	0xD9	Ù	Ã™	%C3 %99
U+0161	0x9A	š	Å¡	%C5 %A1	U+00DA	0xDA	Ú	Ãš	%C3 %9A
U+203A	0x9B	›	â€º	%E2 %80 %BA	U+00DB	0xDB	Û	Ã›	%C3 %9B
U+0153	0x9C	œ	Å“	%C5 %93	U+00DC	0xDC	Ü	Ãœ	%C3 %9C
	0x9D				U+00DD	0xDD	Ý	Ã	%C3 %9D
U+017E	0x9E	ž	Å¾	%C5 %BE	U+00DE	0xDE	Þ	Ãž	%C3 %9E
U+0178	0x9F	Ÿ	Å¸	%C5 %B8	U+00DF	0xDF	ß	ÃŸ	%C3 %9F
U+00A0	0xA0		Â	%C2 %A0	U+00E0	0xE0	à	Ã	%C3 %A0
U+00A1	0xA1	¡	Â¡	%C2 %A1	U+00E1	0xE1	á	Ã¡	%C3 %A1
U+00A2	0xA2	¢	Â¢	%C2 %A2	U+00E2	0xE2	â	Ã¢	%C3 %A2
U+00A3	0xA3	£	Â£	%C2 %A3	U+00E3	0xE3	ã	Ã£	%C3 %A3
U+00A4	0xA4	¤	Â¤	%C2 %A4	U+00E4	0xE4	ä	Ã¤	%C3 %A4
U+00A5	0xA5	¥	Â¥	%C2 %A5	U+00E5	0xE5	å	Ã¥	%C3 %A5
U+00A6	0xA6	¦	Â¦	%C2 %A6	U+00E6	0xE6	æ	Ã¦	%C3 %A6
U+00A7	0xA7	§	Â§	%C2 %A7	U+00E7	0xE7	ç	Ã§	%C3 %A7
U+00A8	0xA8	¨	Â¨	%C2 %A8	U+00E8	0xE8	è	Ã¨	%C3 %A8
U+00A9	0xA9	©	Â©	%C2 %A9	U+00E9	0xE9	é	Ã©	%C3 %A9
U+00AA	0xAA	ª	Âª	%C2 %AA	U+00EA	0xEA	ê	Ãª	%C3 %AA
U+00AB	0xAB	«	Â«	%C2 %AB	U+00EB	0xEB	ë	Ã«	%C3 %AB
U+00AC	0xAC	¬	Â¬	%C2 %AC	U+00EC	0xEC	ì	Ã¬	%C3 %AC
U+00AD	0xAD		Â	%C2 %AD	U+00ED	0xED	í	Ã-	%C3 %AD
U+00AE	0xAE	®	Â®	%C2 %AE	U+00EE	0xEE	î	Ã®	%C3 %AE
U+00AF	0xAF	¯	Â¯	%C2 %AF	U+00EF	0xEF	ï	Ã¯	%C3 %AF
U+00B0	0xB0	°	Â°	%C2 %B0	U+00F0	0xF0	ð	Ã°	%C3 %B0
U+00B1	0xB1	±	Â±	%C2 %B1	U+00F1	0xF1	ñ	Ã±	%C3 %B1
U+00B2	0xB2	²	Â²	%C2 %B2	U+00F2	0xF2	ò	Ã²	%C3 %B2
U+00B3	0xB3	³	Â³	%C2 %B3	U+00F3	0xF3	ó	Ã³	%C3 %B3
U+00B4	0xB4	´	Â´	%C2 %B4	U+00F4	0xF4	ô	Ã´	%C3 %B4
U+00B5	0xB5	µ	Âµ	%C2 %B5	U+00F5	0xF5	õ	Ãµ	%C3 %B5
U+00B6	0xB6	¶	Â¶	%C2 %B6	U+00F6	0xF6	ö	Ã¶	%C3 %B6
U+00B7	0xB7	·	Â·	%C2 %B7	U+00F7	0xF7	÷	Ã·	%C3 %B7
U+00B8	0xB8	¸	Â¸	%C2 %B8	U+00F8	0xF8	ø	Ã¸	%C3 %B8
U+00B9	0xB9	¹	Â¹	%C2 %B9	U+00F9	0xF9	ù	Ã¹	%C3 %B9
U+00BA	0xBA	º	Âº	%C2 %BA	U+00FA	0xFA	ú	Ãº	%C3 %BA
U+00BB	0xBB	»	Â»	%C2 %BB	U+00FB	0xFB	û	Ã»	%C3 %BB
U+00BC	0xBC	¼	Â¼	%C2 %BC	U+00FC	0xFC	ü	Ã¼	%C3 %BC
U+00BD	0xBD	½	Â½	%C2 %BD	U+00FD	0xFD	ý	Ã½	%C3 %BD
U+00BE	0xBE	¾	Â¾	%C2 %BE	U+00FE	0xFE	þ	Ã¾	%C3 %BE
U+00BF	0xBF	¿	Â¿	%C2 %BF	U+00FF	0xFF	ÿ	Ã¿	%C3 %BF

Brains Engineering Blog

Encoding issue on accented (and other) characters in Latin alphabet

Add comment

Related posts

Add comment