1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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