Welcome Guest, Not a member yet? Register   Sign In
Inserted strings get truncated when they contain german "Umlaute" like ä, ü, ö .... [URGENT]
#1

[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
#2

[eluser]pistolPete[/eluser]
Have a look at http://philsturgeon.co.uk/news/2009/08/U...odeIgniter and follow all those instructions.
#3

[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
#4

[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.
#5

[eluser]mradlmaier[/eluser]
Thanks, pistolPete,
It worked exactly as described. Like a breeze...Took a few minutes to fix the problem.




Theme © iAndrew 2016 - Forum software by © MyBB