+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: character probem (/showthread.php?tid=39782)
character probem - El Forum - 03-20-2011
[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.
character probem - El Forum - 03-20-2011
[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
character probem - El Forum - 03-21-2011
[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.
character probem - El Forum - 03-21-2011
[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
character probem - El Forum - 03-27-2011
[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?
character probem - El Forum - 03-28-2011
[eluser]Speedy`[/eluser]
I have forgot to show the sql sintax
SELECT * FROM (`table_name`) WHERE `title` = 'actor-tânăr' returns error.
character probem - El Forum - 03-28-2011
[eluser]InsiteFX[/eluser]
Dealing with Character Sets and Encodings in MySQL
InsiteFX