Answers

• rf1234 Posts: 2,806Questions: 85Answers: 406

  January 2018 edited January 2018

  Path is Editor-PHP-.../php/config.php In that file you'll find this:

  $sql_details = array(
      "type" => "Mysql",   // Database type: "Mysql", "Postgres", "Sqlserver", "Sqlite" or "Oracle"
      "user" => "",        // Database user name
      "pass" => "",        // Database password
      "host" => "",        // Database host
      "port" => "",        // Database connection port (can be left empty for default)
      "db"   => "",        // Database name
      "dsn"  => "",        // PHP DSN extra information. Set as `charset=utf8` if you are using MySQL
      "pdoAttr" => array() // PHP PDO attributes array. See the PHP documentation for all options
  );
  

  Mine looks like this - and I have no problem with utf8.

  $sql_details = array(
      "type" => "Mysql",  // Database type: "Mysql", "Postgres", "Sqlite" or "Sqlserver"
      "user" => "youUserName",       // Database user name
      "pass" => "yourPassword",       // Database password
      "host" => "",       // Database host
      "port" => "",       // Database connection port (can be left empty for default)
      "db"   => "youDatabaseName",       // Database name
      "dsn"  => "charset=utf8"        // PHP DSN extra information. Set as `charset=utf8` if you are using MySQL
  );
  

  I ran into a similar issue when I built my own PDO PHP class based on this example: http://culttt.com/2012/10/01/roll-your-own-pdo-php-class/

  The example has this statement which doesn't work for UTF8:

  // Set DSN
  $dsn = 'mysql:host=' . $this->host . ';dbname=' . $this->dbname;
  

  I replaced it with this and it has been working fine ever since:

  define("DB_CHARSET",        "utf8");
  
  private $charset = DB_CHARSET;  
  $dsn = 'mysql:host=' . $this->host . ';dbname=' . $this->dbname . ';charset=' . $this->charset;
  
• classic12 Posts: 228Questions: 60Answers: 4

  January 2018

  Thanks for the help.

  I have added "dsn" => "charset=utf8" but I still get the same issue.

  Cheers

  Steve Warby
• rf1234 Posts: 2,806Questions: 85Answers: 406

  January 2018

  Steve, I tried it myself entered "90°" into a VARCHAR field in one of my tables and it worked out fine.
  The table has the collation "utf8 - utf8_unicode_ci". The column has character set "utf8" and collation "utf8_unicode_ci".

  Maybe you want to check your Mysql table and column definitions?!
• allan Posts: 61,667Questions: 1Answers: 10,096 Site admin

  January 2018

  You could also try adding:

  $db->sql("SET character_set_client=utf8");
  $db->sql("SET character_set_connection=utf8");
  $db->sql("SET character_set_results=utf8");
  

  before your initialise the Editor instance in the PHP.

  Allan
• classic12 Posts: 228Questions: 60Answers: 4

  August 2018

  Hi Guys,

  I am still having an issue.

  I am using the following code config.php

  <?php if (!defined('DATATABLES')) exit(); // Ensure being used in DataTables env.
  
  // Enable error reporting for debugging (remove for production)
  ini_set('display_errors', 1);
  ini_set('display_startup_errors', 1);
  error_reporting(E_ALL);
  
  
  /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
   * Database user / pass
   */
   
  $sql_details = array(
      "type" => "Mysql",   // Database type: "Mysql", "Postgres", "Sqlserver", "Sqlite" or "Oracle"
      "user" => "xxx",        // Database user name
      "pass" => "xxx",        // Database password
      "host" => "localhost",        // Database host
      "port" => "",        // Database connection port (can be left empty for default)
      "db"   => "xxx",        // Database name
      "dsn"  => "charset=utf8",        // PHP DSN extra information. Set as `charset=utf8` if you are using MySQL
      //"pdoAttr" => array() // PHP PDO attributes array. See the PHP documentation for all options
  );
  

  anims.php

  
  <?php
  header('Access-Control-Allow-Origin: *');
  header('Access-Control-Allow-Methods: GET, POST');  
  ini_set('display_errors', 1);
  ini_set('display_startup_errors', 1); 
  
   
  /*
   * Example PHP implementation used for the index.html example
   */
   
  // DataTables PHP library
  include( "DataTables.php" );
   
  // Alias Editor classes so they are easy to use
  use
      DataTables\Editor,
      DataTables\Editor\Field,
      DataTables\Editor\Format,
      DataTables\Editor\Mjoin,
      DataTables\Editor\Options,
      DataTables\Editor\Upload,
      DataTables\Editor\Validate,
      DataTables\Editor\ValidateOptions;
   
  // Build our Editor instance and process the data coming from _POST
  Editor::inst( $db, 'anims' )
      ->fields(
  
          Field::inst( 'id' ),
          Field::inst( 'title' ),
          Field::inst( 'url' ),
          Field::inst( 'status' ),
          Field::inst( 'thumbnail' ),
          Field::inst( 'type' )
         
      )
      ->process( $_POST )
      ->json();
  
  

  config for the table attached.

  I have the following manually entered into the field

  
  <video controls="controls" width="100%"  name="Video Name"  src="http://www.aceoftoons.com/imageAssets/garyBarlow1.mov"></video>
  
  

  When viewed in the editor ( set to CKEditor) I see the video okay.

  When I update via the editor the following is stored in the table.

  
  <p>
  &lt;video controls="controls" name="Video Name" src="http://www.aceoftoons.com/imageAssets/garyBarlow1.mov" width="100%"&gt;&nbsp;&lt;/video&gt;
  </p>
  
  

  As a work around I create what I need using editor & CKEditor then select the source code and manually paste into the table.

  What am I not understanding or missing here ?

  Cheers

  Steve Warby

  Screen Shot 2018-08-25 at 15.37.58.png 159K
• allan Posts: 61,667Questions: 1Answers: 10,096 Site admin

  August 2018

  Right - that's a different issue. Its encoded HTML Entities for XSS protection. See this section of the Editor manual for details and how to turn it off.

  Allan