emsifa

<?php

// grabbed and parsed from http://id.wikipedia.org/wiki/Daftar_kode_telepon_di_Indonesia
return array(
	'subulussalam' => '0627', 'kutacane' => '0629', 'aceh tenggara' => '0629', 'langsa' => '0641', 'blang kejeren' => '0642', 
	'gayo lues' => '0642', 'takengon' => '0643', 'aceh tengah' => '0643', 'bireuen' => '0644', 'bireuen' => '0644', 'lhokseumawe' => '0645', 
	'idi' => '0646', 'aceh timur' => '0646', 'sinabang' => '0650', 'simeulue' => '0650', 'banda aceh' => '0651', 'jantho' => '0651', 
	'aceh besar' => '0651', 'lamno' => '0651', 'aceh jaya' => '0651', 'sabang' => '0652', 'sigli' => '0653', 'pidie' => '0653', 
	'calang' => '0654', 'aceh jaya' => '0654', 'meulaboh' => '0655', 'aceh barat' => '0655', 'tapaktuan' => '0656', 'aceh selatan' => '0656', 
	'bakongan' => '0657', 'aceh selatan' => '0657', 'singkil' => '0658', 'aceh singkil' => '0658', 'blangpidie' => '0659', 'aceh barat daya' => '0659', 

voskobovich

DROP TABLE currency;

-- Create table variable
CREATE TABLE currency (
  name   VARCHAR(20),
  code   VARCHAR(3),
  symbol VARCHAR(5)
);

ALTER TABLE currency CONVERT TO CHARACTER SET utf8;