Guest Posted June 13, 2007 Posted June 13, 2007 Does anyone have any idea why characters that we enter into product or category titles and descriptions in the ascii format work fine for a while, then suddenly start showing crazy characters after a while? The main characters that we use are the ampersand, quote, <, >, copyright, trademark, registered, etc... We used to have the registered symbol after this word... now it looks like this: Sunriderô We used the TM symbol after this word... now it also looks like: Belt-Railô We used the copyright symbol afte this word.... now it looks like: HaartzÆ I mean, is it best to use the ascii numbers or the letter versions? Is there something we need to have in our header in our code or something? It's just crazy that it works for a while then messes up without us doing anything to it....
rrrhythm Posted June 14, 2007 Posted June 14, 2007 Does anyone have any idea why characters that we enter into product or category titles and descriptions in the ascii format work fine for a while, then suddenly start showing crazy characters after a while? The main characters that we use are the ampersand, quote, <, >, copyright, trademark, registered, etc... We used to have the registered symbol after this word... now it looks like this: Sunriderô We used the TM symbol after this word... now it also looks like: Belt-Railô We used the copyright symbol afte this word.... now it looks like: HaartzÆ I mean, is it best to use the ascii numbers or the letter versions? Is there something we need to have in our header in our code or something? It's just crazy that it works for a while then messes up without us doing anything to it.... don't know about ascii codes myself, as i usually use unicode (same thing?). anyhoo, things like "& amp ;" only with the spaces removed, to get an ampersand ( i have to insert the spaces here or the forum software will actually give an ampersand). what i have noticed, is that when editing multiple times using the admin panel, things get garbled. so say i insert a product description that has an ampersand in it, and i dutifully enter in the unicode for it. it will go into the database as the unicode and then display correctly in pages, being an actual ampersand on the page, and the unicode "& amp ;" in the source. the problem comes when i go back later in the admin panel and edit that same product description, the admin pulls from the database, and ends up putting in all sorts of escape slashes, and/or giving an actual apersand rather than the unicode, etc, etc., and lord only knows what it actually writes to the database, as you've learned. and the "back" button after you've previewed something is even worse. the long and the short of it, is that i have begun writing things directly to the DB using phpMyAdmin more and more and using the admin panel less and less. i always use phpMyAdmin to edit things, and not the admin panel. it's simply less buggy, and i can be more certain what's getting written to the database (which will then be displayed to my customers). i still use the admin panel to insert things, mostly. it seems like this could all be sorted out fairly easily, and i hope the developers do in future editions. meanwhile, i haven't bothered to do it myself, as i've already spent too much time re-coding the store side. i can't bear the thought of digging into the admin side, and i've been able to get around the problems by using phpMyAdmin does this sound like your problem? rj
Guest Posted June 14, 2007 Posted June 14, 2007 It absolutely does sound like my problem... thanks for the suggestion!
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.