The Joomla! Forum ™






Post new topic Reply to topic  [ 11 posts ] 
Author Message
PostPosted: Mon Oct 12, 2009 2:36 pm 
User avatar
Joomla! Apprentice
Joomla! Apprentice

Joined: Wed Oct 04, 2006 1:54 pm
Posts: 13
Location: Cairo
Hi , i am sorry but i can't speak Latvian so i couldn't search forum topics for my problem.
I have a joomla website that i am making for a Latvian friend, but i have a problem with the characters encoding. I don't know but the original Latvian lang. pack is working right. But when i submit any article or category it goes insane!
URL: http://ilze.kordy.info


thanks in advance


Top
 Profile  
 
PostPosted: Tue Oct 13, 2009 7:01 pm 
User avatar
Joomla! Explorer
Joomla! Explorer

Joined: Sat Feb 11, 2006 9:43 pm
Posts: 292
Location: Birmingham, USA
Make sure you tables in the database is in utf8 encoding, otherwise they will truncate the data.

When you installed Joomla, did you select language option "Latvian"?

_________________
The key to your life is how well you deal with plan "B".
Latvian Project http://joomlacode.org/gf/project/joomla_latvian/ | http://www.joomlalv.org


Top
 Profile  
 
PostPosted: Tue Oct 13, 2009 7:33 pm 
User avatar
Joomla! Apprentice
Joomla! Apprentice

Joined: Wed Oct 04, 2006 1:54 pm
Posts: 13
Location: Cairo
OK, that makes sense. i will take a look at the database and will tell you what happened.
thanks for replying.


Top
 Profile  
 
PostPosted: Wed Oct 28, 2009 11:09 am 
User avatar
Joomla! Apprentice
Joomla! Apprentice

Joined: Wed Oct 04, 2006 1:54 pm
Posts: 13
Location: Cairo
that really solved the problem, i was using a jomstart for that template and it hadn't the language option in its installer. So i got to change it from the database (utf8_latvian_ci) and it worked like a charm.
Thanks again

_________________
Best Regards,


Top
 Profile  
 
PostPosted: Wed Oct 28, 2009 2:32 pm 
User avatar
Joomla! Explorer
Joomla! Explorer

Joined: Sat Feb 11, 2006 9:43 pm
Posts: 292
Location: Birmingham, USA
You are very welcome.

I like the 'eco' template your friend is using. I think I will use it for an adventure website, it fits the look. 8)

_________________
The key to your life is how well you deal with plan "B".
Latvian Project http://joomlacode.org/gf/project/joomla_latvian/ | http://www.joomlalv.org


Top
 Profile  
 
PostPosted: Wed Oct 28, 2009 4:46 pm 
User avatar
Joomla! Explorer
Joomla! Explorer

Joined: Tue Oct 11, 2005 5:43 pm
Posts: 293
Location: Latvia
I am not realy sure if selection of install language makes sense in database collation.
Anyway all fields in database that can contain latvian texts must be in utf8, otherwise there will be ? instead of ā and other caracters.

_________________
Member of the Latvian Joomla Translation Team
Latvian project in JoomlaCode- http://joomlacode.org/gf/project/joomla_latvian/
Latvian Joomla! team  - http://www.joomlalv.org


Top
 Profile  
 
PostPosted: Sat Jan 09, 2010 9:01 pm 
User avatar
Joomla! Explorer
Joomla! Explorer

Joined: Tue Oct 11, 2005 5:43 pm
Posts: 293
Location: Latvia
sinatheme wrote:
How to change tables Unicode To UTF-8 in phpmyadmin?


Look in table structure and change aproriate fields.
As I have experienced change of table encoding does not make sense, if encoding of fields is different (for ex latin1).

_________________
Member of the Latvian Joomla Translation Team
Latvian project in JoomlaCode- http://joomlacode.org/gf/project/joomla_latvian/
Latvian Joomla! team  - http://www.joomlalv.org


Top
 Profile  
 
PostPosted: Sat Jan 09, 2010 9:22 pm 
User avatar
Joomla! Apprentice
Joomla! Apprentice

Joined: Wed Oct 04, 2006 1:54 pm
Posts: 13
Location: Cairo
zuze wrote:
You are very welcome.

I like the 'eco' template your friend is using. I think I will use it for an adventure website, it fits the look. 8)


But it's pain using it :(, i know it looks great but it has many bugs (big images sizes, fonts, conflicts with some extensions,...) and do not expect a manual neither a support. except that they got a lot of great looking themes and the rest is on your own.

_________________
Best Regards,


Top
 Profile  
 
PostPosted: Sat Jan 09, 2010 9:26 pm 
User avatar
Joomla! Apprentice
Joomla! Apprentice

Joined: Wed Oct 04, 2006 1:54 pm
Posts: 13
Location: Cairo
lemings wrote:
Look in table structure and change aproriate fields.
As I have experienced change of table encoding does not make sense, if encoding of fields is different (for ex latin1).


but it solved my encoding problem by changing the Collation from latin1_swedish_ci to utf8_general

Quote:
How to change tables Unicode To UTF-8 in phpmyadmin?


in phpmyadmin --> choose yhe database --> operations tab --> Collation

_________________
Best Regards,


Top
 Profile  
 
PostPosted: Sun Jan 10, 2010 9:02 am 
User avatar
Joomla! Explorer
Joomla! Explorer

Joined: Tue Oct 11, 2005 5:43 pm
Posts: 293
Location: Latvia
I thought collation is already set. Some components still are not using utf8 encoding for text fields. I encountered that few times.

It is great if problem once is soloved. ;)

_________________
Member of the Latvian Joomla Translation Team
Latvian project in JoomlaCode- http://joomlacode.org/gf/project/joomla_latvian/
Latvian Joomla! team  - http://www.joomlalv.org


Top
 Profile  
 
PostPosted: Wed Feb 03, 2010 8:12 pm 
User avatar
Joomla! Explorer
Joomla! Explorer

Joined: Sat Feb 11, 2006 9:43 pm
Posts: 292
Location: Birmingham, USA
deebocean wrote:

But it's pain using it :(, i know it looks great but it has many bugs (big images sizes, fonts, conflicts with some extensions,...) and do not expect a manual neither a support. except that they got a lot of great looking themes and the rest is on your own.

I have to agree with you 100% on the template being a pain - I'm feeling it. I got it for one of the adventure projects, and it is like you said, full of bugs.
Template developer's support is non-existent. :(

_________________
The key to your life is how well you deal with plan "B".
Latvian Project http://joomlacode.org/gf/project/joomla_latvian/ | http://www.joomlalv.org


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 11 posts ] 



Who is online

Users browsing this forum: No registered users and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group