Two Spaces Together Causes Question Mark

I am using FCKEDITOR on my website and whenever anyone enters a space twice in a row, the first one shows up as a question mark. I took a look through the database and can see that it's being saved as &nbsp; but shows as a ? on the website. My database is set up to UTF-8 General ci.

Is it possible to make it so that I can accept more than one space in a row? Or is there a known fix for this?

Thanks

Thu, 08/28/2008 - 01:34

a.m.

Joined: 20/04/2008

Posts: 256

Re: Two Spaces Together Causes Question Mark

This could happen if you don't specify the correct encoding in the server-side code. For example, if you set the page charset and the database to UTF-8, but didn't set codepage in ASP, you will receive a non-breakable space encoded in UTF-8 as two bytes - C2 A0 and your server code would interpret it as machine default, which is probably why you see a question mark (e.g. the first byte of the UTF-8 sequence), followed by a space (the second byte).

&nbsp; indicates that your HTML encoding is not done in the right place, unless you HTML-decode when reading from the database. HTML encoding should happen right before you output HTML, if it is done at all (e.g. makes no sense to HTML-encode editor's output in a CMS).

Thu, 08/28/2008 - 04:56

ddashwood10

Joined: 27/08/2008

Posts: 2

Re: Two Spaces Together Causes Question Mark

Ok so I have a script running on my website that runs fckeditor and it is set to UTF-8 and the database is definitely set to UTF-8. You are saying that there needs to be a codepage set up as well?

I am not quite sure how or where this would go. I host with Godaddy and they have a page called gdform.php, that is placed on my server. Could this be where I make a change? Do you have any links to tutorials that could show me how to do this?

Sorry I am new. I usually just buy scripts and all this is done already.

Fri, 08/29/2008 - 16:03

a.m.

Joined: 20/04/2008

Posts: 256

Re: Two Spaces Together Causes Question Mark

UTF-8 is typically used to store or transfer text, but rarely to process it (e.g. Java, C# use UTF-16, JavaScript, VB, C++ use UCS-2). In ASP, you would set the response codepage to match the database and input/output character sets. I don't know how to do this in PHP, but it should be something similar.

Fri, 08/29/2008 - 20:24

a.m.

Joined: 20/04/2008

Posts: 256

Re: Two Spaces Together Causes Question Mark

http://www.phpwact.org/php/i18n/utf-8/mysql