csv problem encoding utf-8

Next topic

Author	Message
Amine BETARI	Monday 24 January 2011 1:44:18 am Hello, I generate csv files via a module, my problem is the encoding: for example civility displayed Civility © when I open the csv file directly with double click. by cons when I open the csv file with notepad ++ or via Excel (Data -> External Data -> Import data -> select the encoding etc..) it works very well you have an idea?
Frédéric RINALDI	Monday 24 January 2011 2:12:52 am Dear Amine, I suppose you use header functions to export to CSV? header("Content-Disposition: attachment; filename='yourCsvFile.csv" ) ; header("Cache-Control: cache, must-revalidate" ) ; header("Pragma: public" ) ; Do you use a encoding feature? header('Content-Type: text/xml, charset=UTF-8; encoding=UTF-8'); Yours,
Amine BETARI	Monday 24 January 2011 4:05:22 am I use: header('Content-Type: application/csv; utf-8'); header("Content-Type: application/force-download"); header('Content-Disposition: attachment; filename="'.$fileName.'.csv"'); but I tried to use what you offered me but I had the same problem Thank you very much
Frédéric RINALDI	Monday 24 January 2011 8:05:25 am Do you try utf8_encode function? and maybe mb_detect_encoding to get the wrong encoding of your content.
Amine BETARI	Monday 24 January 2011 9:08:53 am which is weird, I used the function utf_decode () for words containing accents and it works well !!!!!!!!!!!!!!!!!

eZ debug

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0071	587.9141	152.6250
Module start 'layout'	0.0071	0.0035	740.5391	39.4531
Module start 'content'	0.0106	0.7433	779.9922	491.7734
Module end 'content'	0.7539	0.0016	1,271.7656	12.1641
Script end	0.7555		1,283.9297

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0034	0.4493	16	0.0002
Check MTime	0.0014	0.1814	16	0.0001
Mysql Total
Database connection	0.0015	0.1927	1	0.0015
Mysqli_queries	0.7042	93.2060	63	0.0112
Looping result	0.0006	0.0787	61	0.0000
Template Total	0.7222	95.6	2	0.3611
Template load	0.0020	0.2704	2	0.0010
Template processing	0.7201	95.3075	2	0.3601
Template load and register function	0.0002	0.0288	1	0.0002
states
state_id_array	0.0010	0.1297	1	0.0010
state_identifier_array	0.0010	0.1353	2	0.0005
Override
Cache load	0.0017	0.2304	33	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0020	0.2648	2	0.0010
Fetch class attribute name	0.0015	0.1956	5	0.0003
XML
Image XML parsing	0.0002	0.0275	2	0.0001
class_abstraction
Instantiating content class attribute	0.0000	0.0014	5	0.0000
General
dbfile	0.0006	0.0857	10	0.0001
String conversion	0.0000	0.0010	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
5	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
6	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
7	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
4	content/datatype/view/ezxmltags/emphasize.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/emphasize.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 24 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs