- `supp_name` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
- `supp_ref` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
- `address` tinytext COLLATE utf8_unicode_ci NOT NULL,
- `supp_address` tinytext COLLATE utf8_unicode_ci NOT NULL,
- `gst_no` varchar(25) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
- `contact` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
- `supp_account_no` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
- `website` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
- `bank_account` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
- `curr_code` char(3) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `supp_name` varchar(60) NOT NULL DEFAULT '',
+ `supp_ref` varchar(30) NOT NULL DEFAULT '',
+ `address` tinytext NOT NULL,
+ `supp_address` tinytext NOT NULL,
+ `gst_no` varchar(25) NOT NULL DEFAULT '',
+ `contact` varchar(60) NOT NULL DEFAULT '',
+ `supp_account_no` varchar(40) NOT NULL DEFAULT '',
+ `website` varchar(100) NOT NULL DEFAULT '',
+ `bank_account` varchar(60) NOT NULL DEFAULT '',
+ `curr_code` char(3) DEFAULT NULL,