CF8 Unicode problems

Discussion in 'Programming' started by donboers, Jul 3, 2010.

  1. #1
    Hi everyone

    I have a page where the product details should be displayed in English and Greek (coming from the database). I have asked the hosting company to configure the DSN to unicode settings what they did.

    This is the database:

    
    CREATE TABLE `LProducts` (
      `p_id` int(8) unsigned NOT NULL auto_increment,
      `p_cat_id` smallint(2) NOT NULL,
      `p_subcat_id` smallint(4) NOT NULL,
      `p_name` varchar(64) NOT NULL,
      `p_description` text,
      `p_greek_description` text,
      `p_price` float(100,2) NOT NULL,
      `p_added` timestamp NOT NULL default CURRENT_TIMESTAMP,
      `p_offer` float(100,2) default NULL,
      `p_isOffer` tinyint(1) NOT NULL default '0',
      PRIMARY KEY  (`p_id`),
      KEY `p_name` (`p_name`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    Code (markup):
    I furthermore added the following the Application.cfm:
    
    <cfcontent type="text/html; charset=utf-8">
    <cfscript>
    SetEncoding("form","utf-8");
    SetEncoding("url","utf-8");
    </cfscript> 
    
    Code (markup):
    and added this to the pages that should display the Greek text:
    
    <cfprocessingdirective pageEncoding="utf-8">
    
    Code (markup):
    Off-line (locally) everything is working fine but on-line I get only question marks. Does someone have an idea what i'm doing wrong?

    Thank you in advance
     
    donboers, Jul 3, 2010 IP
  2. Paul_K

    Paul_K Greenhorn

    Messages:
    85
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    18
    #2
    Did you ever solve this?
     
    Paul_K, Jul 25, 2010 IP