did you configure mysql with UTF8 ?

absolutely no idea what I did 6 years ago when I installed b2evo
How can I see that ?

Okay 6 years ago no one knew to do the database tricks.

A method to UPGRADE an existing database (to UTF8 blah blah blah) without damaging what's there is what Topanga needs.

OT: waffle house for lunch every day while I go to a stupid class that makes my commute be gross. YAY!!!

I think that b2evolution can't handle accents in tags, AFAIK.

Walter wrote:

I think that b2evolution can't handle accents in tags, AFAIK.

Walter, whatever it does, it does it wrong.
And that is a real pitty, since I write a lot in french and french = accents ;)

Yes, it's wrong ;)

I speak portuguese, and we have a lot of accents here..

I will think about what can we do.

I can live with "insert only the 'normal' characters"
I can live with "handle the same word different with accents and no accents"
I can live with everything, but I can not live with SQL-errors ;)

I'm glad you have accents too in you native language, then at least you have the same needs. ;)

My vote is for the second alternative. I had some troubles with it.

But even after I've inserted a tag with a accent, the link generates a http redirect error.. So, there's some things to do ;)

I will try to fix it for 3.0 ;)

Walter wrote:

I will try to fix it for 3.0 ;)

not for 2.4.6??
I have a very heavy production blog, so I will not upgrade to 3,0 until next year I suppose

2.4.6 is out ;)

Well, I will see, as I need this, maybe I can go faster ;)

Walter wrote:

2.4.6 is out ;)

I know it is out, thats why I ask it ;)
as a bugfix ;)

Hum... I can post tags with accents, without SQL error, but they don't work. Do you can post tags with accents? What error happens?

/me grabs popcorn, go walter, go walter :D

I'm crap at this foreign stuff ;)

¥

Walter wrote:

Hum... I can post tags with accents, without SQL error, but they don't work. Do you can post tags with accents? What error happens?

I can post them once, but not twice
like in
I can post them for 1 article
If I post the same tag for another article, I get this error

Duplicate entry 'gérard depardieu' for key 2(Errno=1062)

Your query: insert new tags

INSERT INTO evo_items__tag( tag_name )

VALUES ( 'olivier dahan' ),( 'marion cotillard' ),( 'jean-pierre martins' ),( 'gérard depardieu' ),( 'clotilde courau' ),( 'pascal greggory' ),( 'emmanuelle seigner' ),( 'catherine allégret' ),( 'marc barbé' )

BUT

I think in the main time something changed.
Because if I change the tag witht he correct word (with accents) then it works..
like somebody magically healed the problem.

So I think I must say : it solved itself.

Have you guys tried this http://forums.b2evolution.net/viewtopic.php?t=14904 ?

I'm using accent in tag without problem.

MySQL is using Collation "utf8_general_ci"
Before installing the blog, I edited conf/_advanced.php
and added the entry:

$db_config['table_options'] = ' ENGINE=InnoDB DEFAULT CHARSET=utf8 ';

Demo:
Tag: voiture électrique (it means "electric car")
http://www.seven-passion.com/tag/voiture+%E9lectrique-

You can configure the charset used by b2evolution in conf/_locales.php