SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    John 8:24 JREAM's Avatar
    Join Date
    Sep 2007
    Location
    Florida
    Posts
    1,508
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Having a hard time with Cryllic and MySQL

    ** We Fixed It, Just Deleted Tables * Reinstalled and it worked **

    Im not too sure how this is happening..

    I have my HTML charset=utf-8
    I have my MySQL at utf8-general-ci
    My PHP files are set to UTF8 without BOM

    PHP Ver: 5
    MySQL Ver: 5, and 4.1

    When I connect to the database I do this:
    mysql_query("SET CHARACTER SET utf8");
    mysql_query("SET NAMES utf8");

    Here are some characters
    АБВГДЕЁЖЗИЙКЛМНОПРСТУФХЦЧШЩЪЫЬЭЮЯ
    абвгдеёжзийклмнопрстуфхцчшщъыьэюя

    But they show up as ??????? in the database and in the page.
    A few other encodings did: –ЗИЙКЛМÐ�ОПРСТУФХÐ

    I cant seem to find the right one or right way to get this going.
    Last edited by JREAM; Jul 17, 2009 at 04:06.

  2. #2
    secure webapps for all Aleksejs's Avatar
    Join Date
    Apr 2008
    Location
    Riga, Latvia
    Posts
    755
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi!
    Is Cyrillic in fashion today?
    http://www.sitepoint.com/forums/showthread.php?t=627396
    Have you made sure that you execute:
    SET names 'utf8'
    save data to db and when you retrieve data from db?

  3. #3
    John 8:24 JREAM's Avatar
    Join Date
    Sep 2007
    Location
    Florida
    Posts
    1,508
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hey there, yeah Cryllic is the new trend haha. We got it working after removing the database and reinstalling it, it wasnt working when we tried just setting it to utf8


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
  •