French characters cut off

[eluser]webnology[/eluser]
Hi all,

I'm having an issue saving french characters with CI (or is it non-CI ?). If I save a form filed with value 'Frédéric', then the string seems to be cut off at the Fr... The rest dissapears. Now, my encoding is like this:

in MySQL:

Code:

utf8_general_ci

in database.php :

Code:

$db['default']['char_set'] = "utf8";
$db['default']['dbcollat'] = "utf8_general_ci";

Can anyone help me to solve this, please?

Kind regards,
M

[eluser]puicheng[/eluser]
Hi,

Having the same problem. Any clue?

Clifford

[eluser]n0xie[/eluser]
Do you have the form setup to accept UTF-8 charset?

Code:

<form accept-charset="UTF-8">

[eluser]puicheng[/eluser]
The French characters were loaded from an Excel spreadheet using multipart form upload. The MySql database was set up as utf8_unicode_ci and the same is used in database.php:

$db['default']['char_set'] = "utf8";
$db['default']['dbcollat'] = "utf8_unicode_ci";

The database accepts French characters when hard coding in the test case but got chopped off when read from the spreadsheet and inserted using the Active Record Class. Tried also using <form accept-charset="UTF-8"> as suggested but still doesn't work.

Having been struggling for 2 days. Any help is appreciated.

Clifford