character encoding problem

deebocean · Post by **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

zuze · Post by **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"?

deebocean · Post by **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.

deebocean · Post by **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

zuze · Post by **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.

Post by **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.

Post by **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).

deebocean · Post by **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.

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.

deebocean · Post by **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

Post by **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.

zuze · Post by **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.

cyberredvette · Post by **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,

The Joomla! Forum™

character encoding problem

character encoding problem

Re: character encoding problem

Re: character encoding problem

Re: character encoding problem

Re: character encoding problem

Re: character encoding problem

Re: character encoding problem

Re: character encoding problem

Re: character encoding problem

Re: character encoding problem

Re: character encoding problem

Re: character encoding problem