Re: Import XLS file with UTF-8

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@gmail.com> 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