Page 1 of 1

character encoding problem

Posted: Mon Oct 12, 2009 2:36 pm
by deebocean
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

Re: character encoding problem

Posted: Tue Oct 13, 2009 7:01 pm
by zuze
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"?

Re: character encoding problem

Posted: Tue Oct 13, 2009 7:33 pm
by deebocean
OK, that makes sense. i will take a look at the database and will tell you what happened.
thanks for replying.

Re: character encoding problem

Posted: Wed Oct 28, 2009 11:09 am
by deebocean
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

Re: character encoding problem

Posted: Wed Oct 28, 2009 2:32 pm
by zuze
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)

Re: character encoding problem

Posted: Wed Oct 28, 2009 4:46 pm
by lemings
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.

Re: character encoding problem

Posted: Sat Jan 09, 2010 9:01 pm
by lemings
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).

Re: character encoding problem

Posted: Sat Jan 09, 2010 9:22 pm
by deebocean
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.

Re: character encoding problem

Posted: Sat Jan 09, 2010 9:26 pm
by deebocean
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

Re: character encoding problem

Posted: Sun Jan 10, 2010 9:02 am
by lemings
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. ;)

Re: character encoding problem

Posted: Wed Feb 03, 2010 8:12 pm
by zuze
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. :(

Re: character encoding problem

Posted: Thu Jun 25, 2015 6:39 pm
by cyberredvette
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,