Replies

• stepf Posts: 4Questions: 0Answers: 0

  September 2009 edited September 2009

  hmm.. "??" is actually the utf8 inputs
  
  For Testing 1: you may search "Stephanie" & copy the chinese char to test on "search"
  
  For Testing 2: you may copy data (utf8-general-ci) from the 2nd rows, column: platform(s) to test on the "search"
  
  Thanks.
  Regards,
  Stephanie
• allan Posts: 63,407Questions: 1Answers: 10,452 Site admin

  September 2009

  Hi Stephanie,
  
  It might be worth having a look at this thread, which details how ChrisS got UTF8 to work as expected: http://datatables.net/forums/comments.php?DiscussionID=411
  
  Also for debugging the MySQL queries, a good way of going this is using the error-log() function in PHP ( http://uk.php.net/manual/en/function.error-log.php ) and viewing the error log for your host (assuming you are using Apache).
  
  Regards,
  Allan
• stepf Posts: 4Questions: 0Answers: 0

  September 2009 edited September 2009

  Hi Allan
  
  Thanks for the reply.
  
  My hosting is IIS6 and it's quite difficult to request for a change in server setting.
  
  Here's my solution, hope this helps.
  
  You can put the following codes after MySql connections
  
  [code]
  //To send utf8 data to MySql - needed if you need to inject utf8 data for search
  mysql_query("SET character_set_client=utf8", $gaSql['link']);
  mysql_query("SET character_set_connection=utf8", $gaSql['link']);
  
  //To read utf8 data from MySql - needed if your result set contains utf8 data
  mysql_query("SET character_set_results=utf8", $gaSql['link']);
  
  $rResult = mysql_query( $sQuery ) or die(mysql_error());
  [/code]
  
  Since i have no access to the host, therefore, i ouput a file to read my query :)
  
  [code]
  $myFile = "test.txt";
  $fh = fopen($myFile, 'w') or die("can't open file");
  fwrite($fh, $sQuery . "\n\n");
  fclose($fh);
  [/code]
  
  Again, goooood job allan, DataTables is really a fantastic work.
  
  Regards
  Stephanie
• allan Posts: 63,407Questions: 1Answers: 10,452 Site admin

  September 2009

  Hi Stephanie,
  
  Fantastic! Thanks for sharing that with us :-). I can tell this is one of the threads I'll be copying and pasting the url of in future :-)
  
  Regards,
  Allan