Recent Topics

adding a keyword (tag) with an accent

Started by on Jan 25, 2009 – Contents updated: Jan 25, 2009

Jan 25, 2009 17:41    

If I want to put keywords with accents in the tagline ( Pedro Almodóvar, Javier Cámara, Daniel Giménez Cacho), then I end up with an sql error.
The error states

MySQL error!
Duplicate entry 'pedro almodovar' for key 2(Errno=1062)
Your query: insert new tags

If I then remove the accent, I 'm not helped, because in the database, the tag with accent is inserted.

Jan 25, 2009 23:21

did you configure mysql with UTF8 ?

Jan 25, 2009 23:47

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

Jan 25, 2009 23:52

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!!!

Jan 26, 2009 13:28

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

Jan 26, 2009 17:35

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 ;)

Jan 26, 2009 17:40

Yes, it's wrong ;)

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

I will think about what can we do.

Jan 26, 2009 18:13

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. ;)

Jan 26, 2009 18:15

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 ;)

Jan 26, 2009 18:16

I will try to fix it for 3.0 ;)

Jan 26, 2009 19:33

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

Jan 26, 2009 19:37

2.4.6 is out ;)

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

Jan 26, 2009 19:38

Walter wrote:

2.4.6 is out ;)

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

Jan 26, 2009 19:40

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?

Jan 26, 2009 20:53

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

I'm crap at this foreign stuff ;)

¥

Jan 26, 2009 21:58

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.

Jan 27, 2009 21:32

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:

PHP

$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


Form is loading...

powered by b2evolution free blog software – This forum is powered by b2evolution CMS, a complete engine for your website.