MrDuck wrote:
I had a site running 1.06 CMSMS (single-language), and i need to get more langs support..following this:
http://forum.cmsmadesimple.org/index.ph ... 318.0.html .. (second post,case C), well, it goes well, tull the STOP warning, when i check my site there, it has messed up encodings. When i tried that on testing server,it was just ok. Tried messing with encodings in DB and config,but with no clue found...any ideas? (there's utf-8 in config and utf_czech_ci tables...database is latin2 though, no idea why,not my work
).
Please if anyone has an idea..it's pretty urgent.
Hum... in my opinion is better utf8_unicode_ci but I don't use eastern languages
I think that you have a old DB backup
I suppose that your backup have DROP table command?
If yes, do a copy, search and replace with an editor last row of CREATE command with:
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
For example:
Code: Select all
CREATE TABLE `cms_additional_htmlblob_users` (
`additional_htmlblob_users_id` int(11) NOT NULL,
`user_id` int(11) default NULL,
`htmlblob_id` int(11) default NULL,
PRIMARY KEY (`additional_htmlblob_users_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
import this backup, upgrade and check
Read
this topic also
Good luck
Alby