Special (foreign) characters in "Edit states"

[teggen +]

Hello,

I have tried to search the forum for this, but couldnt find any answer - sorry if this has been asked before.

I am trying to replace the the US states in <Settings> - <Edit states> with states from my country. I am having problems with one of the states "�stfold", which begins with a character that does not display properly in 68Classifieds. It is only when the special character is the first character in the word that it is an issue. There are several other states that has these characters in them, and they show up just fine.

INPUT:


OUTPUT:


I had a similar problem in the beginning with displaying these characters (�, � and �) in the front-end in the browser, but solved this by opening up the language file and saving it as a Unicode UTF-8 file. However, in this case I am not sure what to do.

Any ideas for a fix?

Thanks for any help,

Terje

[Mike-N-Tosh +]

Does it work if you put the HTML entity instead?
Ø

[teggen +]

Originally Posted by Mike-N-Tosh

Does it work if you put the HTML entity instead?
Ø

Thank you for your reply. I tried putting in the HTML entity you suggested, but no luck. Funny thing is, when it is not capital letters, then it works fine. For example, it will display �stfold correctly - however �stfold turns out as �stfold. Do you have any other ideas what might be causing this?

Also, is your blog and store down? I keep getting the message 403 Forbidden when I click on your links in your signature.

Cheers,

Terje

[Mike-N-Tosh +]

That is odd that it would display the lowercase character correctly, but not the upper case. I find it even more odd that it is replacing the character with a tilde, because normally issues with foreign characters produce garble and/or the infamous "?"

Have you looked in the actual database table itself to see how it is being stored? The reason I'm asking is that this might help determine where the issue is happening. Before it goes to the database or when it gets called back. This might be as simple as setting your layout template in both the front end and the back end to your languages character set.

[teggen +]

Originally Posted by Mike-N-Tosh

That is odd that it would display the lowercase character correctly, but not the upper case. I find it even more odd that it is replacing the character with a tilde, because normally issues with foreign characters produce garble and/or the infamous "?"

Have you looked in the actual database table itself to see how it is being stored? The reason I'm asking is that this might help determine where the issue is happening. Before it goes to the database or when it gets called back. This might be as simple as setting your layout template in both the front end and the back end to your languages character set.

I had a look in the database - please see the screenshots (first entry in the table). The lower case � is displayed with the HTML entity (there are several in the table). However when I in the administration replace it with the capital � - it turns out in the table as a tilde. So I guess it must be somewhere in the communication between 68Classifieds and the DB where the fault lies.

I took my chances and replaced the tilde with the HTML entity in PHPMyAdmin directly, and Voila! - it seems to be working and now displaying correctly! I am a novice in programming - hope it is OK to do it like this and it will not affect the site in unforseen ways.

Thanks for all your help!