double quotes appear as ? on website

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

I have an Excel file (which is converted to csv by a tool and then
uploaded to a   MySQL database) and then php is used to display the
data on the website.

In the Excel file i have text fields which has data containing double
quotes. They end up appearing at ? question mark on the website. Any
idea how to dispaly the quotes

Should i be carefull of any other invisible characters in Excel which
can mess up the data.
Help me will greatly appreciated.



Re: double quotes appear as ? on website wrote:
Quoted text here. Click to load it

Those are "smart quotes" :(

Read /

or google for "smart quotes"

Quoted text here. Click to load it

Try viewing the generated file within a DOS/Command Prompt window:

    C:\> cd wherever
    C:\wherever> type file.csv | more

if I remember correctly.

Mail to my "From:" address is readable by all at /
== ** ## !! ------------------------------------------------ !! ## ** ==
may bypass my spam filter. If it does, I may reply from another address!

Site Timeline