Universal Data Exporter PHP Support Product Page

In progress

Strange characters

Reported 19 Aug 2011 00:46:17
has this problem
19 Aug 2011 00:46:17 manuel pinto posted:
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


Replied 29 Aug 2011 13:00:34
29 Aug 2011 13:00:34 Miroslav Zografski replied:
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.
Replied 30 Aug 2011 23:07:09
30 Aug 2011 23:07:09 manuel pinto replied:
Yes, it's right, but my data base has also all the fields with utf8 collation .. really don't understand why this happen.
Replied 01 Sep 2011 10:19:46
01 Sep 2011 10:19:46 Miroslav Zografski replied:
Hello Manuel,

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

Replied 02 Sep 2011 19:15:59
02 Sep 2011 19:15:59 manuel pinto replied:
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
Replied 07 Sep 2011 09:52:32
07 Sep 2011 09:52:32 Miroslav Zografski replied:
Hello manuel,

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


Replied 08 Sep 2011 01:24:34
08 Sep 2011 01:24:34 manuel pinto replied:
No, it's not there. The first line begins this way:

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 ..."

Replied 05 Dec 2011 14:11:12
05 Dec 2011 14:11:12 Miroslav Zografski replied:
Hello manuel,

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

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

Replied 05 Dec 2011 19:32:52
05 Dec 2011 19:32:52 manuel pinto replied:
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 ?

Reply to this topic