Saddie

Topic: MySQL charset problem

Hello, I have translated jobberbase to spanish succesfully. Just saw some minutes ago that there's already one translation here.  But I will keep my version cause I think suits better my needs big_smile.

Ok, so.... After changing the charset from uft-8 to iso-8859-1 in the header.tpl and made some manual translations here and there in other files the whole site is showing correctly spanish characters and accents. 

My problem is in the job categories created in the Admin.   I have changed the admin/_templates/header.tpl charset to iso-8859-1 too, and in phpmyadmin I have changed to the MySQL conection collation to utf8_spanish_ci.  Same done in the categories/name table too.
But is not working.

Maybe im doing something wrong or I need other configuration dunno. 
I will apreciate any help.
thanks

smile

putypuruty

Re: MySQL charset problem

Hi!

I've tried now to enter some spanish chars in my categories table (utf8 encoded) and it worked just fine. Also all my files have utf8 as encoding - probably you could have left all files with UTF-8 encoding wink

What is the problem in your case? The spanish chars are not displayed correctly? Can you attach here a screenshot?

Saddie

Re: MySQL charset problem

Hi!
Thanks for ur answer smile

Yes the problem is that the chars are not dsplaying correctly.
When I first installed jobberbase and change the translations file I left all the files with uft8.
But the spanish chars were all displaying uncorrectly.  So I change the charset to: iso-8859-1 and problem solved...until I entered the admin and start changing the english job categories to spanish ones. 

I have this categories for jobs: (this is how it should be displayed)

Administración | Oficina , Arte | Diseño Medios , Ciencia | Investigación , Informática | Telecom.

but in the site and admin panel are displayed like this:

Administraci?n | Oficina , Arte | Diseño Medios , Ciencia | Investigaci?n , Inform?tica | Telecom.

BTW, i have changed the charset again to utf8, and so in phpmyadmin.  And nothing.

help! :S

putypuruty

Re: MySQL charset problem

Hmm.

What I do have different from you is a line in config.php: I have SET NAMES UTF8 instead of SET CHARSET UTF8 but don't know if it matters in your case (you can give it a try though).

Did you try to create the categories table with the correct encoding from the beginning? What I'd recommend is that you delete the categories table, create it again with the spanish encoding and then add categories to it via the admin section.

duong minh

Re: MySQL charset problem

I'm have problem with charset too, in VietNamese when i type "Kiểm toán" it became "ki?m to�n", please help me.

bekircem

Re: MySQL charset problem

I have problem with charset too sad