character encoding problem

User avatar
deebocean
Joomla! Apprentice
Joomla! Apprentice
Posts: 13
Joined: Wed Oct 04, 2006 1:54 pm
Location: Cairo

character encoding problem

Postby deebocean » Mon Oct 12, 2009 2:36 pm

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

User avatar
zuze
Joomla! Explorer
Joomla! Explorer
Posts: 290
Joined: Sat Feb 11, 2006 9:43 pm
Location: Birmingham, USA
Contact:

Re: character encoding problem

Postby zuze » Tue Oct 13, 2009 7:01 pm

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

User avatar
deebocean
Joomla! Apprentice
Joomla! Apprentice
Posts: 13
Joined: Wed Oct 04, 2006 1:54 pm
Location: Cairo

Re: character encoding problem

Postby deebocean » Tue Oct 13, 2009 7:33 pm

OK, that makes sense. i will take a look at the database and will tell you what happened.
thanks for replying.

User avatar
deebocean
Joomla! Apprentice
Joomla! Apprentice
Posts: 13
Joined: Wed Oct 04, 2006 1:54 pm
Location: Cairo

Re: character encoding problem

Postby deebocean » Wed Oct 28, 2009 11:09 am

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,

User avatar
zuze
Joomla! Explorer
Joomla! Explorer
Posts: 290
Joined: Sat Feb 11, 2006 9:43 pm
Location: Birmingham, USA
Contact:

Re: character encoding problem

Postby zuze » Wed Oct 28, 2009 2:32 pm

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

User avatar
lemings
Joomla! Explorer
Joomla! Explorer
Posts: 317
Joined: Tue Oct 11, 2005 5:43 pm
Location: Latvia
Contact:

Re: character encoding problem

Postby lemings » Wed Oct 28, 2009 4:46 pm

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

User avatar
lemings
Joomla! Explorer
Joomla! Explorer
Posts: 317
Joined: Tue Oct 11, 2005 5:43 pm
Location: Latvia
Contact:

Re: character encoding problem

Postby lemings » Sat Jan 09, 2010 9:01 pm

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

User avatar
deebocean
Joomla! Apprentice
Joomla! Apprentice
Posts: 13
Joined: Wed Oct 04, 2006 1:54 pm
Location: Cairo

Re: character encoding problem

Postby deebocean » Sat Jan 09, 2010 9:22 pm

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,

User avatar
deebocean
Joomla! Apprentice
Joomla! Apprentice
Posts: 13
Joined: Wed Oct 04, 2006 1:54 pm
Location: Cairo

Re: character encoding problem

Postby deebocean » Sat Jan 09, 2010 9:26 pm

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

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


in phpmyadmin --> choose yhe database --> operations tab --> Collation
Best Regards,

User avatar
lemings
Joomla! Explorer
Joomla! Explorer
Posts: 317
Joined: Tue Oct 11, 2005 5:43 pm
Location: Latvia
Contact:

Re: character encoding problem

Postby lemings » Sun Jan 10, 2010 9:02 am

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

User avatar
zuze
Joomla! Explorer
Joomla! Explorer
Posts: 290
Joined: Sat Feb 11, 2006 9:43 pm
Location: Birmingham, USA
Contact:

Re: character encoding problem

Postby zuze » Wed Feb 03, 2010 8:12 pm

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

cyberredvette
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Thu Jun 25, 2015 6:36 pm

Re: character encoding problem

Postby cyberredvette » Thu Jun 25, 2015 6:39 pm

Hi,

I am having the same issue. I bought a German template. Currently in English. I'm checking the tables and it is setup as follow:
utf8_general_ci

the other options are all language related. which one should I choose? there is another one utf8_unicode_ci

Thanks,


Return to “Latvian Forum”

Who is online

Users browsing this forum: No registered users and 4 guests