Support Forums

Special (foreign) characters in "Edit states"

This is a discussion on Special (foreign) characters in "Edit states" within the Technical Support forums, part of the Technical Support Forums category; Hello, I have tried to search the forum for this, but couldnt find any answer - sorry if this has ...


Go Back   68 Classifieds Forums > Technical Support Forums > Technical Support

This topic is resolved.

If you have a similar issue that this thread does not address, open a new related support topic.

 
Thread Tools Display Modes
Old 07-02-2009, 05:28 AM   #1
Junior Member
 
Join Date: Mar 2009
Posts: 12
Rep Power: 12
teggen is on a distinguished road
Default Special (foreign) characters in "Edit states"

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
__________________
Developer version 4.1.6 - TC Fluid template customised

Last edited by teggen; 07-02-2009 at 06:18 AM.
teggen is offline  
Old 07-02-2009, 08:53 AM   #2
Developer & Moderator
 
 
Join Date: Jan 2007
Location: Pennsylvania, USA
Posts: 2,393
Rep Power: 73
Mike-N-Tosh is just really nice Mike-N-Tosh is just really nice
Default

Does it work if you put the HTML entity instead?
Ø
__________________
Mike-N-Tosh
IndianaPC.org - A community website (v3.1.10 Developer - heavily modified & used as the CMS)
Sandbox [localhost(v3.1.10, v4.0.9, 4.1.10,4.2,5.0)] for development and customization
Visit My blog: reviews, tips, tricks, tutorials and my store with Templates, Mods & Docs
Web Hosting | Web Design & Development | 68 Classifieds Customizations
I am not a 68C employee, just a user and try to help out
Mike-N-Tosh is offline  
Old 07-02-2009, 07:59 PM   #3
Junior Member
 
Join Date: Mar 2009
Posts: 12
Rep Power: 12
teggen is on a distinguished road
Default

Quote:
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
__________________
Developer version 4.1.6 - TC Fluid template customised
teggen is offline  
Old 07-02-2009, 09:07 PM   #4
Developer & Moderator
 
 
Join Date: Jan 2007
Location: Pennsylvania, USA
Posts: 2,393
Rep Power: 73
Mike-N-Tosh is just really nice Mike-N-Tosh is just really nice
Default

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.
__________________
Mike-N-Tosh
IndianaPC.org - A community website (v3.1.10 Developer - heavily modified & used as the CMS)
Sandbox [localhost(v3.1.10, v4.0.9, 4.1.10,4.2,5.0)] for development and customization
Visit My blog: reviews, tips, tricks, tutorials and my store with Templates, Mods & Docs
Web Hosting | Web Design & Development | 68 Classifieds Customizations
I am not a 68C employee, just a user and try to help out
Mike-N-Tosh is offline  
Old 07-03-2009, 04:07 AM   #5
Junior Member
 
Join Date: Mar 2009
Posts: 12
Rep Power: 12
teggen is on a distinguished road
Default

Quote:
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!



__________________
Developer version 4.1.6 - TC Fluid template customised
teggen is offline  
Closed Thread

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to edit "Sell your Classified" text art Templates, HTML, CSS, and Design Help 4 07-18-2006 01:03 AM


All times are GMT -4. The time now is 06:40 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2011, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0