• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
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.


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


Users browsing this thread:
1 Guest(s)


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2017 MyBB Group.