geebo Posted August 24, 2008 Share Posted August 24, 2008 This is so bad, it's now almost funny. MySQL Version 5.0.45. I have a simple MySQL table that I uploaded from a .csv file. When I first uploaded the .csv, MySQL changed all the apostrophes (') and double quotes (") to question marks (?). I was told it might be a "smart quotes" problem, so I made sure all the text was plain text from notepad. That didn't help. I can go into each field and manually change the question mark to an apostrophe one at a time on the server, and that works, but who wants to do that? I read a fix on this forum: I fixed the problem (might not be the best way but it works). I just pasted everything into work and did a find replace for the apostrophes with ‚ After I replaced all the apostrophes (') with "‚" I now get COMMAS (,)!! ??? Is there any way to get my apostrophes to display as apostrophes? And I do this to unwind. Link to comment https://forums.phpfreaks.com/topic/121144-solved-apostrophe-problem-from-to/ Share on other sites More sharing options...
geebo Posted August 25, 2008 Author Share Posted August 25, 2008 Well, I solved this myself. Here's a record for anyone else who has this problem. &sbquo didn't work, so I copied the apostrophe being used and pasted it at http://leftlogic.com/lounge/articles/entity-lookup/ That showed several HTML possibilities, and ’ ended up working. The search query works fine with that as well. Link to comment https://forums.phpfreaks.com/topic/121144-solved-apostrophe-problem-from-to/#findComment-624645 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.