Zen Follower
- Join Date:
- May 2009
- Posts:
- 228
- Plugin Contributions:
- 1
Upgraded site is not in UTF8? My one isnt
I have 1.39 ZC in utf 8. When i upgraded to 1.5 i used completely new file set and old database
Somehow my site is not in UTF8 now and the thai characters are not showing.
What do i need to do? I think the files should all be standard but anyway its not working
bangkok flower delivery [dot] c om
Ive seen notes to change older versions to utf8 but not this new version. What can i do please?
I already went to phpadmin and changed the collation to utf unicode and have checked the database everythign there is set to utf unicode
The start of my databse looks like this
DROP TABLE IF EXISTS module_version_tracker;
CREATE TABLE IF NOT EXISTS module_version_tracker (
ID int(10) NOT NULL AUTO_INCREMENT,
module_code varchar(255) NOT NULL,
patch_level int(10) NOT NULL,
version_name varchar(255) DEFAULT NULL,
PRIMARY KEY (ID),
UNIQUE KEY module_code (module_code)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Table structure for table vft_address_book
DROP TABLE IF EXISTS vft_address_book;
CREATE TABLE IF NOT EXISTS vft_address_book (
address_book_id int(11) NOT NULL AUTO_INCREMENT,
customers_id int(11) NOT NULL DEFAULT '0',
entry_gender char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
entry_company varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
entry_firstname varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
entry_lastname varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
entry_street_address varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
entry_suburb varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
entry_postcode varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
entry_city varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
entry_state varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
entry_country_id int(11) NOT NULL DEFAULT '0',
entry_zone_id int(11) NOT NULL DEFAULT '0',
entry_telephone varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,****