character encoding problem
- deebocean
- Joomla! Apprentice
- Posts: 13
- Joined: Wed Oct 04, 2006 1:54 pm
- Location: Cairo
character encoding problem
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
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
- zuze
- Joomla! Explorer
- Posts: 290
- Joined: Sat Feb 11, 2006 9:43 pm
- Location: Birmingham, USA
- Contact:
Re: character encoding problem
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"?
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
Latvian Project http://joomlacode.org/gf/project/joomla_latvian/ | http://www.joomlalv.org
- deebocean
- Joomla! Apprentice
- Posts: 13
- Joined: Wed Oct 04, 2006 1:54 pm
- Location: Cairo
Re: character encoding problem
OK, that makes sense. i will take a look at the database and will tell you what happened.
thanks for replying.
thanks for replying.
- deebocean
- Joomla! Apprentice
- Posts: 13
- Joined: Wed Oct 04, 2006 1:54 pm
- Location: Cairo
Re: character encoding problem
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
Thanks again
Best Regards,
- zuze
- Joomla! Explorer
- Posts: 290
- Joined: Sat Feb 11, 2006 9:43 pm
- Location: Birmingham, USA
- Contact:
Re: character encoding problem
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.
I like the 'eco' template your friend is using. I think I will use it for an adventure website, it fits the look.
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
Latvian Project http://joomlacode.org/gf/project/joomla_latvian/ | http://www.joomlalv.org
- lemings
- Joomla! Explorer
- Posts: 317
- Joined: Tue Oct 11, 2005 5:43 pm
- Location: Latvia
- Contact:
Re: character encoding problem
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.
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
Latvian project in JoomlaCode- http://joomlacode.org/gf/project/joomla_latvian/
Latvian Joomla! team - http://www.joomlalv.org
- lemings
- Joomla! Explorer
- Posts: 317
- Joined: Tue Oct 11, 2005 5:43 pm
- Location: Latvia
- Contact:
Re: character encoding problem
Look in table structure and change aproriate fields.sinatheme wrote:How to change tables Unicode To UTF-8 in phpmyadmin?
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
Latvian project in JoomlaCode- http://joomlacode.org/gf/project/joomla_latvian/
Latvian Joomla! team - http://www.joomlalv.org
- deebocean
- Joomla! Apprentice
- Posts: 13
- Joined: Wed Oct 04, 2006 1:54 pm
- Location: Cairo
Re: character encoding problem
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.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.
Best Regards,
- deebocean
- Joomla! Apprentice
- Posts: 13
- Joined: Wed Oct 04, 2006 1:54 pm
- Location: Cairo
Re: character encoding problem
but it solved my encoding problem by changing the Collation from latin1_swedish_ci to utf8_generallemings 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).
in phpmyadmin --> choose yhe database --> operations tab --> CollationHow to change tables Unicode To UTF-8 in phpmyadmin?
Best Regards,
- lemings
- Joomla! Explorer
- Posts: 317
- Joined: Tue Oct 11, 2005 5:43 pm
- Location: Latvia
- Contact:
Re: character encoding problem
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.
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
Latvian project in JoomlaCode- http://joomlacode.org/gf/project/joomla_latvian/
Latvian Joomla! team - http://www.joomlalv.org
- zuze
- Joomla! Explorer
- Posts: 290
- Joined: Sat Feb 11, 2006 9:43 pm
- Location: Birmingham, USA
- Contact:
Re: character encoding problem
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.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.
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
Latvian Project http://joomlacode.org/gf/project/joomla_latvian/ | http://www.joomlalv.org
-
- Joomla! Fledgling
- Posts: 1
- Joined: Thu Jun 25, 2015 6:36 pm
Re: character encoding problem
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,
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,