search

chenster / php-excel-reader

Automatically exported from code.google.com/p/php-excel-reader
0 stars 0 forks source link

Defect Character Encoding in utf-8 #39

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. the â character is not displayed correctly if it's the only special
character in that line (or if there are more like it).
2. if it's accompanied by other similar characters is displayed correctly
(like ăîşţ)
3.

What is the expected output? What do you see instead?

Please provide any additional information below.
in exaple there are 4 lines (rows)...that exeplifies the ouput (lines 1-3
contain only the problematic character; lines 2-4 contain another special
characther in addition to lines 1-3). 1,2 are lowercase, 3,4 are uppercase.

Original issue reported on code.google.com by adite...@gmail.com on 27 Jul 2009 at 12:56

Attachments:

GoogleCodeExporter commented 9 years ago 
don't think that the problem is caused by php-excel-reader and seems to me that 
it 
is related to the browser. I used a small program to interpret the characters 
(if 
you want it, have uploaded it under issue 36) and i see that the value returned 
is 
correct. The only problem is what i see on the screen but this changes 
completely in 
the moment i add (or remove) the 'content="text/html; charset=utf-16"' from the 
html 
meta tag. Test has been done on two cells. In one i had the ã together with 
other 
characters from many languages (arabic, latin, japanese) and in the other cell 
i had 
only the ã.

Original comment by vve...@hotmail.it on 29 Jul 2009 at 3:18

Attachments:

GoogleCodeExporter commented 9 years ago 
hello.....i do not believe it's from browser...this is used in a background 
upload
..processed and inserted into the database. During the excel read, the info is 
never
show n in browser........

Original comment by adite...@gmail.com on 31 Mar 2010 at 9:22

GoogleCodeExporter commented 9 years ago 
hey, I have the same problem here with the "ø" character.. What can I do?

Original comment by mail.dav...@gmail.com on 25 Jul 2010 at 2:00

GoogleCodeExporter commented 9 years ago 
I just found the solution: Just wrap your output with utf8_encode ;-)

Original comment by mail.dav...@gmail.com on 26 Jul 2010 at 9:26

GoogleCodeExporter commented 9 years ago 
well i do not have output....i just enter them in a database....whish is utf-8 
collated (and the connection too)...

will try your solution.

Original comment by adite...@gmail.com on 26 Jul 2010 at 4:22

GoogleCodeExporter commented 9 years ago 
Hi, I am having the same problem. However , utf8_encode() breaks the string if 
it has more then 1 "special" char and helps only in case of a single special 
char in a string

Original comment by rossen.z...@gmail.com on 2 Nov 2010 at 5:02

GoogleCodeExporter commented 9 years ago 
Hi again, I used the patch provided here 
http://code.google.com/p/php-excel-reader/issues/detail?id=31 and it fixed all 
the problems !

Original comment by rossen.z...@gmail.com on 2 Nov 2010 at 5:09

GoogleCodeExporter commented 9 years ago 
When Yen sign was used
The whole cell left out in html.

I already use patch in 
http://code.google.com/p/php-excel-reader/issues/detail?id=31

Still no progress
I call this in my page too .
$exdata0 = new Spreadsheet_Excel_Reader("csv/type0.xls");
$exdata1 = new Spreadsheet_Excel_Reader("csv/type1.xls");

Thank you

Original comment by pyinyein...@gmail.com on 8 Nov 2012 at 8:07

Attachments: