Support Forums

jonten123 + · 12-31-2009, 06:14 PM

Using: V4.1.6 Designer with deepsea template

The letter å, ä and ö is not displayed correctly. I followed the guide here UTF-8 - 68 Classifieds but was not able to include the code in the mysql.php file. I got an Fatal error on my page when including the code. Exactly where shall I put this code? $this->query("set names utf8");

Thanks!

Eric Barnes · 01-01-2010, 01:31 PM

Are you running the designer or developer edition?

jonten123 + · 01-01-2010, 02:12 PM

Hi,

I´m using the designer version! It´s the language file I´m having problem with. ÅÄÖ works fine for the locations I added in the acp!

Eric Barnes · 01-01-2010, 02:55 PM

I have seen this before. The easiest fix is to be sure you are saving the language file in UTF-8 format from your text editor. I know textmate has this option and others. So you may want to refer to the user guide of the editor.

Also you can use the html entities for those characters:

Code:

Å = &Aring;
Ä = &Auml;
Ö = &Ouml;

jonten123 + · 01-01-2010, 04:08 PM

I saved the file through a texteditor in the UTF-8 format and now it displays as it should!

Thank you!

jonten123 + · 01-03-2010, 12:29 PM

Hi,

I have a sort order problem with the characters ÅÄÖ in my categories and my locations. Locations and categories that begins with ÅÄÖ ends up in the wrong place. I have edited class_categories and class_states in phpmyadmin so it uses utf8_swedish_ci but it did not help. How can I solve this?

Thanks!

Eric Barnes · 01-03-2010, 03:42 PM

I am sorry but you may need to elaborate more. What do you mean by they end up the wrong locations?

jonten123 + · 01-03-2010, 05:09 PM

Ok!

The letters åäö comes after z in the swedish alphabet. So its xyzåäö. But for my locations and categories they don´t. Locations that starts with ö and ä ends up between locations that starts with a and b for example. They should end up last. Same for categories..

seymourjames + · 01-03-2010, 07:43 PM

Why not use the 68C admin control panel to weight your categories. There is a box provided. You can then make them appear in any order you wish. Click on the little i to see how it works.

jonten123 + · 01-03-2010, 08:13 PM

Oh, I did not know that. That fixes my categories, but the locations still looks a little messed up..

12-31-2009, 06:14 PM	#1
jonten123 + Member Join Date: Dec 2009 Posts: 53 Rep Power: 10	UTF-8 support Using: V4.1.6 Designer with deepsea template The letter å, ä and ö is not displayed correctly. I followed the guide here UTF-8 - 68 Classifieds but was not able to include the code in the mysql.php file. I got an Fatal error on my page when including the code. Exactly where shall I put this code? $this->query("set names utf8"); Thanks!

01-01-2010, 01:31 PM	#2
Eric Barnes 68 Classifieds Staff Join Date: Mar 2006 Location: Belmont, NC Posts: 5,489 Rep Power: 136	Are you running the designer or developer edition? __________________ Eric Barnes 68 Classifieds Developer Customer Area \| Issue Tracker \| Documentation \| 68C Mods \| 68 @ Twitter \| My Modules

01-01-2010, 02:12 PM	#3
jonten123 + Member Join Date: Dec 2009 Posts: 53 Rep Power: 10	Hi, I´m using the designer version! It´s the language file I´m having problem with. ÅÄÖ works fine for the locations I added in the acp! Last edited by jonten123; 01-01-2010 at 02:22 PM.

01-01-2010, 02:55 PM	#4
Eric Barnes 68 Classifieds Staff Join Date: Mar 2006 Location: Belmont, NC Posts: 5,489 Rep Power: 136	I have seen this before. The easiest fix is to be sure you are saving the language file in UTF-8 format from your text editor. I know textmate has this option and others. So you may want to refer to the user guide of the editor. Also you can use the html entities for those characters: Code: Å = Å Ä = Ä Ö = Ö __________________ Eric Barnes 68 Classifieds Developer Customer Area \| Issue Tracker \| Documentation \| 68C Mods \| 68 @ Twitter \| My Modules

01-03-2010, 12:29 PM	#6
jonten123 + Member Join Date: Dec 2009 Posts: 53 Rep Power: 10	Hi, I have a sort order problem with the characters ÅÄÖ in my categories and my locations. Locations and categories that begins with ÅÄÖ ends up in the wrong place. I have edited class_categories and class_states in phpmyadmin so it uses utf8_swedish_ci but it did not help. How can I solve this? Thanks! Last edited by jonten123; 01-03-2010 at 12:32 PM.

01-01-2010, 04:08 PM	#5
jonten123 + Member Join Date: Dec 2009 Posts: 53 Rep Power: 10	I saved the file through a texteditor in the UTF-8 format and now it displays as it should! Thank you!

01-03-2010, 03:42 PM	#7
Eric Barnes 68 Classifieds Staff Join Date: Mar 2006 Location: Belmont, NC Posts: 5,489 Rep Power: 136	I am sorry but you may need to elaborate more. What do you mean by they end up the wrong locations? __________________ Eric Barnes 68 Classifieds Developer Customer Area \| Issue Tracker \| Documentation \| 68C Mods \| 68 @ Twitter \| My Modules

01-03-2010, 05:09 PM	#8
jonten123 + Member Join Date: Dec 2009 Posts: 53 Rep Power: 10	Ok! The letters åäö comes after z in the swedish alphabet. So its xyzåäö. But for my locations and categories they don´t. Locations that starts with ö and ä ends up between locations that starts with a and b for example. They should end up last. Same for categories..

01-03-2010, 07:43 PM	#9
seymourjames + All Hands On Deck Join Date: Mar 2008 Posts: 3,524 Rep Power: 89	Why not use the 68C admin control panel to weight your categories. There is a box provided. You can then make them appear in any order you wish. Click on the little i to see how it works. __________________ "The fool doth think he is wise, but the wise man knows himself to be a fool.". TemplateCodes.com for 68C

01-03-2010, 08:13 PM	#10
jonten123 + Member Join Date: Dec 2009 Posts: 53 Rep Power: 10	Oh, I did not know that. That fixes my categories, but the locations still looks a little messed up..

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Support and Upgrades	ksuralta	Pre Sales Questions	1	10-23-2007 10:53 AM
Brilliant Support	freemls	Off Topic	1	05-21-2007 09:06 PM
Support Second to NONE! Thank You!	zman78	Testimonials	3	04-04-2006 09:35 AM

Support Forums

UTF-8 support