Strange thing with database filling of text with accented characters (àèìòù)

[add]

Hello,

i created a field content in link table and added this to suggest-link.php


$link['content'] = "alchimia web design milano progettazione realizzazione siti web alchimia web design milano alchimia web design realizzazione siti internet servizi internet portfolio news contatti alchimia web design web agency con sede a milano è specializzata nello studio progettazione sviluppo e realizzazione di siti internet";


But scripts inserts only a part before 'è' ("alchimia web design milano progettazione realizzazione siti web alchimia web design milano alchimia web design realizzazione siti internet servizi internet portfolio news contatti alchimia web design web agency con sede a milano ") so if i move any accented character at the start of text it will insert only small piece of text and the end will be the word before accented character.

Any idea why this may happen? Maybe db encodings, maybe some controls on inserting routines? Try it by yourself and you will see..
It's so frustrating.. Any suggestion is really appreciated because i'm trying to figure this out by hours with no success..

P.S.: field content in db is a longtext type

[Bakyt N.]

add
Hello!
eSyndiCat fully supports UTF8. There were no problems with accented characters.

What kind of changes did you make in your database schema or in scripts?

also what is your MySQL version?

There is no any longtext typed field also nor in manage listings field you can create such field.

[add]

Hello Jason and thanks for your reply!

I solved this issue by encoding a string with accented characters with utf8_encode()

Example:


$link['content'] = utf8_encode($str);


Now works like a charm!

:good:

[Bakyt N.]

ok add :)

It seems you're coder. Please note that
utf8_encode — Encodes an ISO-8859-1 (only) string to UTF-8