By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,960 Members | 1,142 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,960 IT Pros & Developers. It's quick & easy.

double quotes appear as ? on website

P: n/a
Hi,

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.

Thanks,

Nurddin

Jul 17 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
nu*******@yahoo.ca wrote:
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
Those are "smart quotes" :(

Read http://www.fourmilab.ch/webtools/demoroniser/
and http://brent.epicserve.com/blog.php?id=20

or google for "smart quotes"
Should i be carefull of any other invisible characters in Excel which
can mess up the data.


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 http://www.dodgeit.com/
== ** ## !! ------------------------------------------------ !! ## ** ==
TEXT-ONLY mail to the whole "Reply-To:" address ("My Name" <my@address>)
may bypass my spam filter. If it does, I may reply from another address!
Jul 17 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.