SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Zealot eeight's Avatar
    Join Date
    Oct 2006
    Location
    New York City
    Posts
    106
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Arrow Russian in MySQL

    I have the following table, which holds both Russian and English titles and articles:

    Code MySQL:
    CREATE TABLE `articles` (
     `id` tinyint(3) unsigned NOT NULL auto_increment,
     `date` date default NULL,
     `en_title` varchar(100) NOT NULL,
     `ru_title` varchar(100) character set cp1251 NOT NULL,
     `en_content` mediumtext NOT NULL,
     `ru_content` mediumtext NOT NULL,
     PRIMARY KEY  (`id`)
    ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8

    When I insert a new row, the Russian text is converted into nonsense like "??????". As you can see, that column is set to CP1251. I tried using UTF8 (ru_content in above table), but that still returns things like "цуа...".

    I appreciate any help. Thank you!

  2. #2
    SitePoint Wizard PHPycho's Avatar
    Join Date
    Dec 2005
    Posts
    1,200
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hope this thread may help you a bit.
    http://www.sitepoint.com/forums/showthread.php?t=647194


Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •