voskobovich
/ gist:537b2000108e4781f70b
Last active
November 25, 2024 18:36
List of most currency ISO code and symbol format in SQL.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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; |
emsifa
/ Data daftar kode telepon Indonesia
Last active
March 29, 2022 07:52
Daftar kode telepon yang gw grab dan parse dari http://id.wikipedia.org/wiki/Daftar_kode_telepon_di_Indonesia
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?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', |