Inserted strings get truncated when they contain german "Umlaute" like ä, ü, ö .... [URGENT] |
[eluser]mradlmaier[/eluser]
Hello all, I discovered following strange bug in my app: I have a textfield. I enter a string which contains a german Umlaut (ä, ü, ö, etc.). When inserted in the database, the string is truncated before the germen Umlaut. I am using MySQL and the collation of the column is utf8_general_ci. Does anybody know how to fix that? Thanks for any hints, Michael
[eluser]pistolPete[/eluser]
Have a look at http://philsturgeon.co.uk/news/2009/08/U...odeIgniter and follow all those instructions.
[eluser]mradlmaier[/eluser]
pistolPete, I assume, that i can convert the database with phpAdmin accordingly? You are sure, this will work and fix it? While changing a few lines of code in CI can be reversed easily, messing around with the database is another issue... Michael
[eluser]pistolPete[/eluser]
I can't guarantee that it works, so I would setup a new database and tables and copy any existing data there.
[eluser]mradlmaier[/eluser]
Thanks, pistolPete, It worked exactly as described. Like a breeze...Took a few minutes to fix the problem. |
Welcome Guest, Not a member yet? Register Sign In |