Jump to content

[Wiki] [solved] Dealing with unicode in mysql


Recommended Posts

Whats the best table encoding to store non-ansi characters like the ones below.

CREATE TABLE `dbc_DeclinedWord` (
   `Col1` TEXT NOT NULL)
ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Export of DeclinedWord';
INSERT INTO `dbc_DeclinedWord` VALUES
(741,"Косматый молодой волк");
INSERT INTO `dbc_DeclinedWord` VALUES
INSERT INTO `dbc_DeclinedWord` VALUES
(743,"Трогг Каменной Челюсти");

When these are imported into MYSQL they display corrupted

Link to comment
Share on other sites

  • 1 month later...
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use