character probem

[eluser]Speedy`[/eluser]
Hello again.

another problem is bothering me from about 2 hours of searches and nothing.

I have a view with a textarea where I type this text "emoţionant şi visceral"

in another view I print out what I submitet over post and get something like this:

emoţionant şi visceral

Which may be the cause?

my database is utf8

any ideas.. thanx.

[eluser]InsiteFX[/eluser]
I'll bet it is not utf8!

MySQL defaults to latin1_swedish_ci and it will do this everytime you create a new databse!

phpMyAdmin
1) click on your database name
2) click on the operations tab on top
3) go to the bottom of screen and change your collation to utf8_unicode_ci
4) click save or go

But your problem could be an encoding problem!

InsiteFX

[eluser]Speedy`[/eluser]
my database is utf8. I think you are wright about encoding but I do not know where is this done.

I have changed the database.php also but nothing.

[eluser]InsiteFX[/eluser]
MySQL stores its value in local ini file as default-character-set=utf8

You can check this out on php.net htmlentities.

InsiteFX

[eluser]Speedy`[/eluser]
I resolved the last problem but nother apeared.

When I transmit a arameter from link " site/controler/function/actor-tânăr" I recive the sql like this actor-tânăr

have you any Ideas how can I fix this?

thanks.

I have tried with escape strings but it result something like this actor-t�n?r

It is a global config that I omit?

[eluser]Speedy`[/eluser]
I have forgot to show the sql sintax

SELECT * FROM (`table_name`) WHERE `title` = 'actor-tânăr' returns error.

[eluser]InsiteFX[/eluser]
Dealing with Character Sets and Encodings in MySQL

InsiteFX