Zen Cart Logo
Forums / General Questions / Keep getting question marks ? and Capital A characters

Keep getting question marks ? and Capital A characters

Views: 1,406

Results 1 to 4 of 4
26 Jan 2012, 6:38 PM
#1
seanscully avatar

seanscully

Zen Follower

Join Date:
Apr 2006
Location:
Largo, Florida USA
Posts:
99
Plugin Contributions:
0

Keep getting question marks ? and Capital A characters

I just updated to 1.3.9h and now most of my 4,000 items have weird formatting issues. I get an Upper Case A all over the place. When I go in and remove the Upper Case A characters, if I do not remove the space in fornt and behind it I get a question mark ? after I save revision. All my quotes and aposthrers are messed up along with the degree symbol and trade marks.
Any way to fix this? It is frustrating and time consuming fixing each one.

Example
-Ash® is
-to screen. Please call
-Temp Min (°C)** :** -10°C
-Item W72?-?Ash?Pole?Mount with?Acc Groove for Battery?-

26 Jan 2012, 10:10 PM
#2
website_rob avatar

website_rob

Inactive

Join Date:
Oct 2006
Location:
Alberta, Canada
Posts:
4,572
Plugin Contributions:
0

Re: Keep getting question marks ? and Capital A characters

I presume these are happening on pages you've editted within the Admin section, either by doing copy & paste of text from another program and/or from the HTML Editor within Zen Cart. Sorry to say but unless someone can provide a better method, you will probably need to Export each Table with the problem, open in a Text Editor on your Computer, do a Search & Replace for all instances, Save and Import the changed Table. I'm not a Database guy so that's the way I would do it.

You will be able to fix future entries by installing TinyMCE or CKEditor, both available from the Add Ons section. Make sure to remove the HTMLarea Editor... and never use it again. :wink:

The learning is in the doing.

Potent Products

26 Jan 2012, 10:41 PM
#3
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Keep getting question marks ? and Capital A characters

Or, you've switched yourself partly to UTF8 when your site's really ISO-8859-1

https://www.zen-cart.com/tutorials/index.php?article=414

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

6 Jan 2013, 2:36 AM
#4
kartune avatar

kartune

New Zenner

Join Date:
Nov 2012
Posts:
8
Plugin Contributions:
0

Re: Keep getting question marks ? and Capital A characters

DrByte:

Or, you've switched yourself partly to UTF8 when your site's really ISO-8859-1

https://www.zen-cart.com/tutorials/index.php?article=414

I don't quite understand what it is saying I should change? My database is set at utf8_unicode_ci, but there are also instances of latin1_swedish_ci that I see. I just upgraded from 3.9 to 5.1 of Zen Cart. And am having the same issues of the description disappearing and now thos odd charcters showing up all over. **The product name and price have stayed intact however, no problems there. I'm just really confused. Please llet me know if there's anything else I need to let you know to be able to pin point my issue. Thanks.