Weird Characters for Punctuation after Upgrade

1beb · 2006-10-12 04:29:54

Greetings All,

I couldn’t really think of what to search for, but I really did try before posting!

So, if you’ll notice on my website punctuation marks are now showing up as � in Firefox and as a “?” in IE. Does anyone have any suggestions for a quick way to remedy this problem. Does it have something to do with character encoding?

Thanks in Advance txp’ers!

ruud · 2006-10-12 06:34:54

What did you upgrade, TXP or MySQL… and what are the old and new versions you use(d)?

1beb · 2006-10-12 14:19:06

Excuse me for the ambiguity of my original statement. I upgraded Textpattern from 4.0.2 to 4.0.3

Thanks!

Last edited by 1beb (2006-10-12 14:20:03)

zem · 2006-10-12 23:11:49

So, if you’ll notice on my website punctuation marks are now showing up as � in Firefox and as a ”?” in IE.

Please be specific. What punctuation marks? Can you link to an example?

1beb · 2006-10-13 02:11:46

It looks to be just apostrophe’s and quotation marks

zem · 2006-10-13 03:30:00

It looks like you’ve somehow entered ISO-8859-1 or Windows cp-1252 apostrophe and quotation marks in your articles. These aren’t valid UTF-8 characters. Copy-paste from MS Word is a common cause.

Why it changed from 4.0.2 to 4.0.3, I couldn’t say. Textpattern doesn’t alter the content of your articles during an upgrade. Probably it was working only by accident earlier.

Last edited by zem (2006-10-13 03:34:58)

1beb · 2006-10-13 04:23:54

Probably it was working only by accident earlier.

Awesome!

1beb · 2006-10-15 21:06:51

I don’t ever use MS-Word to copy paste my articles. It happened in the comments as well it is primarily from my 2005 entries. Could it have something to do with the character encoding of my database? I just noticed that it is latin1_swedish_ci

zem · 2006-10-15 21:49:35

I don’t ever use MS-Word to copy paste my articles. It happened in the comments as well it is primarily from my 2005 entries. Could it have something to do with the character encoding of my database? I just noticed that it is latin1_swedish_ci

Possible, though unlikely – that usually only happens if MySQL is upgraded without following the proper procedures for fixing UTF-8 data.

Try editing and re-saving an article that exhibits the problem. If it fixes it, the problem is probably related to the database character encoding. If it doesn’t, it means cp-1252 or other invalid characters were entered when the article was written (if not by copy-paste, then some other method – fancy textarea editor? clever keyboard driver? modified backup?)

1beb · 2006-10-15 22:19:26

Try editing and re-saving an article that exhibits the problem. If it fixes it, the problem is probably related to the database character encoding.

Nope, that didn’t work :(

If it doesn’t, it means cp-1252 or other invalid characters were entered when the article was written (if not by copy-paste, then some other method – fancy textarea editor? clever keyboard driver? modified backup?)

None of those are true either although, I’m going to look into the “keyboard driver” as I have a laptop and it could be outputting something funky.

And I’ve also discovered the extent of the changes: it happened to the following characters: – ‘ “ š dž and ć

If I could figure out a way to view my sql dump without all the /r/nr/r/r/r/r/r etc characters I would be able to copy paste into a text file and then copy over into txp again.

1beb · 2006-10-16 07:50:37

I thought it was an unrelated issue to the second post I made but now I found something that would tell me differently.

In the admin section->advanced options “Send “Last-Modified�? header?” I see that.

1beb · 2006-10-17 00:08:44

Resolved Here

Textpattern CMS

Textpattern CMS support forum

#1 2006-10-12 04:29:54

Weird Characters for Punctuation after Upgrade

#2 2006-10-12 06:34:54

Re: Weird Characters for Punctuation after Upgrade

#3 2006-10-12 14:19:06

Re: Weird Characters for Punctuation after Upgrade

#4 2006-10-12 23:11:49

Re: Weird Characters for Punctuation after Upgrade

#5 2006-10-13 02:11:46

Re: Weird Characters for Punctuation after Upgrade

#6 2006-10-13 03:30:00

Re: Weird Characters for Punctuation after Upgrade

#7 2006-10-13 04:23:54

Re: Weird Characters for Punctuation after Upgrade

#8 2006-10-15 21:06:51

Re: Weird Characters for Punctuation after Upgrade

#9 2006-10-15 21:49:35

Re: Weird Characters for Punctuation after Upgrade

#10 2006-10-15 22:19:26

Re: Weird Characters for Punctuation after Upgrade

#11 2006-10-16 07:50:37

Re: Weird Characters for Punctuation after Upgrade

#12 2006-10-17 00:08:44

Re: Weird Characters for Punctuation after Upgrade

Board footer