+- 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: Special Characters & Active Record (/showthread.php?tid=41117)
Special Characters & Active Record - El Forum - 04-28-2011
[eluser]BrokenLegGuy[/eluser]
Before starting I just want to say that I've searched around and tried different "solutions" that I've come across but none of them seem to work. I'm using codeigniter 1.x, I'm not sure what specific version it is.
I've changed the collation of the database, table, columns, and application/config/database.php to the same setting. I've tried utf8_unicode_ci, utf8_general_ci, utf8_unicode_ci, and utf8_swedish_ci (apparently this is a settings bug default in phpMyAdmin?)
What happens is when a string is inserted into the database it stops at the first special character and that character is changed to an "รข", which is stored in the database, and that's the end of the string.
The reason for wanting to insert those characters is because I've built an admin panel that has the following functionality.
- pulls data from PubMed.
- user selects an abstract to insert into our database
- abstract populates a form
- user adds additional information from drop downs for our internal sales tool
- user submits form.
Can anyone shed any light on what the heck is going on?
Thanks,
Ed
Special Characters & Active Record - El Forum - 04-28-2011
[eluser]n0xie[/eluser]
Did you take a look at these 2 links?
http://www.haughin.com/2010/02/23/building-utf8-compatible-codeigniter-applications/
http://philsturgeon.co.uk/blog/2009/08/UTF-8-support-for-CodeIgniter
Special Characters & Active Record - El Forum - 04-28-2011
[eluser]BrokenLegGuy[/eluser]
[quote author="n0xie" date="1304027897"]Did you take a look at these 2 links?
http://www.haughin.com/2010/02/23/building-utf8-compatible-codeigniter-applications/
http://philsturgeon.co.uk/blog/2009/08/UTF-8-support-for-CodeIgniter[/quote]
I came across the first one but not the second, I'll look at it right now.
A few threads here that I came across was
http://ellislab.com/forums/viewthread/174539/
http://ellislab.com/forums/viewthread/184337/
http://ellislab.com/forums/viewthread/84802/#426770
*yay! can't post links...*
as well as a some outside site with the same solutions and a bunch that address URI special characters problems.
Thanks,
Ed