When i export data to excel it shows a character problem on certain words like ´or ç or ~. There's a solution for this kind of subject? I use dreamweaver cs5.5 and windows 7 Home. The collation of database is utf8_general_ci. I work on my local pc and don't have a live sample

Edited by - manuel pinto on 19 Aug 2011  00:46:52

Hello Manuel,
Even if your database and table collations are set to utf8 each text field has a collation of itself. Check those as well.

Yes, it's right, but my data base has also all the fields with utf8 collation .. really don't understand why this happen.

Hello Manuel,

Are the characters displayed correctly on the page from which you are exporting?

hello. Yes, the characters are correct. To visualize i use your datagrid and everything is correct on database, but when i export the data to excel eveything that has special characters (´or ~ etc) become strange

Hello manuel,

In the ExcelWriter file, that is located in ScriptLibrary folder check if the first line is set to:

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>

No, it's not there. The first line begins this way:
<?php

class ExcelWriter
{
var $MAX_RECORD_SIZE = 8224;

var $_byte_order;

var $_encoding;
var $_name;

If i put <%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%> dreamweaver said that "there's a sintax error on line 1 ..."

Hello manuel,

use this line of code
mysql_query('set names utf8', $yourDbConnectionName);

after the
<?php require_once('Connections/yourDbConnectionName.php'); ?>

I try it and it's usefull. I only got is working perfect if i use "binary" instead of html_table format. Do you need a link to check it ?