+- 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: MySQL and collations (/showthread.php?tid=15188)
MySQL and collations - El Forum - 01-28-2009
[eluser]RS71[/eluser]
Hey
I'm having some troubles with this. I'm trying to display characters like 'ã' but MySQL is outputting as one collation and I think PHP is doing another and they keep crapping out.
I'm currently trying to work with UTF8
Could anybody possibly help me?
These are the settings that I believe I have (from phpmyadmin)
Code:
character set client utf8
(Global value) latin1
character set connection utf8
(Global value) latin1
character set database latin1
character set filesystem binary
character set results utf8
(Global value) latin1
character set server latin1
character set system utf8
character sets dir C:\xampp\mysql\share\charsets\
collation connection utf8_general_ci
(Global value) latin1_swedish_ci
collation database latin1_swedish_ci
collation server latin1_swedish_ciMySQL and collations - El Forum - 01-28-2009
[eluser]RS71[/eluser]
Could somebody please assist me with this?
From what the Firefox page info and from the utf8 meta tag I set at the top of the html, I believe the page is currently set to UTF-8.
I think the MySQL is currently outputting to UTF8 but I'm not sure how to fully check this other than make sure the fields and database is set to utf8. I say I think it is because the query is currently returning 'ã' and not 'ã'.
The thing is, whenever I set the utf8 meta tag on top of the view, the words that contain 'ã' that come from the language file display some block characters with letters in them and the query will display correctly.
MySQL and collations - El Forum - 01-30-2009
[eluser]libnac[/eluser]
Hi RS71,
What language would you like to show characters from?
May be UTF-8 is not valid. Try with another charset like ISO-8859-5 in your browser and change $config['charset'] = "ISO-8859-5"; on the config.php file