User Tag List

Results 1 to 7 of 7

Thread: unicode not entering mysql database

  1. #1
    Clicker Fusion 2.5 DeveloperiOS Export ModuleSWF Export ModuleInstall Creator ProPatch Maker

    Join Date
    Jul 2006
    Location
    Athens, GA
    Posts
    152
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    unicode not entering mysql database

    I have a free response student testing system that will not insert the unicode (Korean characters) into a mysql database. I am using php with the get object.

    I had designed this program in flash originally but now I am converting it to mmf2 to port in different platforms. In my php code I used the header <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> but this will not work with the get object using $_POST for the data.

    Any help or suggestions would be appreciated.

    Thanks

  2. #2
    Clicker Fusion 2.5 DeveloperAndroid Export ModuleHTML5 Export ModuleiOS Export ModuleSWF Export Module
    Ryan's Avatar
    Join Date
    Nov 2008
    Location
    Australia
    Posts
    1,279
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    the encoding can be set within the mysql database itself for each varchar or text field. It usually defaults to latin1_swedish_ci, but you can change it to UTF-8. Explore the options in your database manager.

  3. #3
    Clicker Fusion 2.5 DeveloperiOS Export ModuleSWF Export ModuleInstall Creator ProPatch Maker

    Join Date
    Jul 2006
    Location
    Athens, GA
    Posts
    152
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I have the database in UTF-8 and the server is hosted in Korea. The Korean text will enter through the cpanel and show correctly in the database but when entered using the get object through a php file it will not show properly. I have also tried url encoding the string with no success.

  4. #4
    Clicker Fusion 2.5 DeveloperAndroid Export ModuleHTML5 Export ModuleSWF Export Module
    happygreenfrog's Avatar
    Join Date
    May 2011
    Location
    I.L.T.D.O.I.R (I.L.T.D.O.I.R's Location: The Dimension Of Infinite Recursion)
    Posts
    4,307
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by crugh View Post
    I have a free response student testing system that will not insert the unicode (Korean characters) into a mysql database. I am using php with the get object.

    I had designed this program in flash originally but now I am converting it to mmf2 to port in different platforms. In my php code I used the header <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> but this will not work with the get object using $_POST for the data.

    Any help or suggestions would be appreciated.

    Thanks
    You're using the Unicode version of MMF2, right? It probably won't work without it. It also might be an issue with the GET object (it might not be Unicode-compatible).

  5. #5
    Clicker Fusion 2.5 DeveloperiOS Export ModuleSWF Export ModuleInstall Creator ProPatch Maker

    Join Date
    Jul 2006
    Location
    Athens, GA
    Posts
    152
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I am using the unicode version of MMF2. Do you think the moosock extension would work?

  6. #6
    Clicker Fusion 2.5 DeveloperAndroid Export ModuleHTML5 Export ModuleSWF Export Module
    happygreenfrog's Avatar
    Join Date
    May 2011
    Location
    I.L.T.D.O.I.R (I.L.T.D.O.I.R's Location: The Dimension Of Infinite Recursion)
    Posts
    4,307
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by crugh View Post
    I am using the unicode version of MMF2. Do you think the moosock extension would work?
    It might, but you should use GET, since, if you encounter any bugs, they will never, ever get fixed, since the Moo objects are abandoned by their developer (and the developer who made them doesn't seem to be around anymore).

  7. #7
    Clicker Fusion 2.5HTML5 Export Module
    Allrounder's Avatar
    Join Date
    Jan 2014
    Posts
    57
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Same problem here.
    I try to transmit unicode from MMF2.5 with the Get object. Mysql database and php is set to UTF-8. The post data of the get object that is received in the php is not UTF-8 and can't be converted to it with php.

    Has anyone already a solution?

Similar Threads

  1. Save and load info into MySQL database
    By Catalyst in forum SWF/Flash Export Module Version 2.0
    Replies: 5
    Last Post: 6th September 2012, 02:54 AM
  2. ASP.NET to access a mySQL database from MMF2?
    By RGBreality in forum Multimedia Fusion 2 - Technical Support
    Replies: 1
    Last Post: 15th September 2010, 08:26 PM
  3. Hi-score and mysql database
    By videogiochi in forum Multimedia Fusion 2 - Technical Support
    Replies: 16
    Last Post: 14th July 2010, 04:10 PM
  4. [REQUEST] MySQL database
    By Dynamite in forum Extension Development
    Replies: 2
    Last Post: 10th March 2010, 05:08 AM
  5. Connecting to a MySQL database....?
    By pinacoladaxb in forum Multimedia Fusion 2 - Technical Support
    Replies: 21
    Last Post: 1st May 2008, 12:07 PM

Posting Permissions

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