Yağızhan Bayram ybbayram

Full Stack Developer

kasperkamperman / fixwrongutf8encoding.php

Created July 3, 2018 11:58

Function to fix ut8 special characters displayed as 2 characters (utf-8 interpreted as ISO-8859-1 or Windows-1252)

	<?php header('Content-Type: text/html; charset=utf-8'); ?>
	<html>
	<head>
	<title>Fix wrong encoded UTF8 characters</title>
	<meta http-equiv="Content-type" content="text/html; charset=utf-8" />
	</head>
	<body>
	<pre>
	<?php
	/* Problem description:

halillusion / countries-ulkeler.html

Created March 11, 2017 16:10

Türkçe Ülke Kod Listesi (Select Option)

	<select>
	<option value="TR">Türkiye</option>
	<option value="VI">ABD Virgin Adaları</option>
	<option value="AF">Afganistan</option>
	<option value="AX">Aland Adaları</option>
	<option value="DE">Almanya</option>
	<option value="US">Amerika Birleşik Devletleri</option>
	<option value="UM">Amerika Birleşik Devletleri Küçük Dış Adaları</option>
	<option value="AS">Amerikan Samoası</option>
	<option value="AD">Andora</option>

yahyaerturan / tr_countries.sql

Last active March 11, 2022 09:57

Türkçe Ülkeler MySQL Tablosu

	CREATE TABLE IF NOT EXISTS `countries_list` (
	`id_country` tinyint(3) unsigned NOT NULL auto_increment,
	`country_name` varchar(30) collate utf8_unicode_ci NOT NULL,
	PRIMARY KEY (`id_country`)
	) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=207 ;

	--
	-- Dumping data for table `countries_list`
	--