Re: Import XLS file with UTF-8

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



i change the UTF-8 by windows-1250 and it works well.

But what will happen if after i use UTF-8 in the rest of this PHP page ?
everytime  some characters will not be correctly displayed...

moreover my database is in UTF-8.

So i must expect some issue during copy data from CSv to database, no ?

Al.

On 8/10/07, Stut <stuttle@xxxxxxxxx> wrote:
>
> Alain Roger wrote:
> > Hi,
> >
> > So now i know how to import the content of the CSV file to database,
> > however, before to import to database i do a simple test.
> > in fact, i display in my browser all content of my CSV file.
> >
> > unfortunately, not all characters are displayed correctly.
> > in PHP page include <meta http-equiv="Content-Type" content="text/html;
> > charset=UTF-8"> but it does not help to display the Slovak Characters
> which
> > are correctly display in EXCEL when i open the CSV file with it.
> > i tried to display a standar slovak web page in my browser and it works
> > perfectly well.
> >
> > So where could be the problem ?
>
> The Content-Type needs to match the file type, so if the file is not
> UTF-8 extended characters will not be displayed correctly when it's
> displayed as UTF-8.
>
> Try removing that meta tag and see what the browser makes of the file by
> guessing.
>
> -Stut
>
> --
> http://stut.net/
>



-- 
Alain
------------------------------------
Windows XP SP2
PostgreSQL 8.1.4
Apache 2.2.4
PHP 5.2.1

[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux