Forums / Cotonti / Bugs / entering special chars in profile

urlkiller
#1 2009-04-17 19:40
got a small prob i think.

if i change my profile and entering at location something with an: ä ö ü or ß it only saving the letters without the special chars.

is this already reported? or not a bug? special char security?
URL shortener: <a href="http://bbm.li/!7AD5C7">http://bbm.li/!7AD5C7</a>
pieter
#2 2009-04-17 19:44
You need to check your database. It needs to be UTF8 I believe.
There are some topics about it in the forum.
... can we help you ...
urlkiller
#3 2009-06-06 21:00
my db is utf8 unicode as well as the settings on the webpage.7both utf8 but nothing is working with special chars..

any solutions?
URL shortener: <a href="http://bbm.li/!7AD5C7">http://bbm.li/!7AD5C7</a>
Trustmaster
#4 2009-06-07 16:16
That's quite weird because it is known to save national characters without any problems. E.g. if I type location in Russian, it saves fine. There's nothing in code that could cause it, because it is simply imported as TXT
$ruserlocation = sed_import('ruserlocation','P','TXT');
and then escaped for MySQL query
user_location='".sed_sql_prep($ruserlocation)."',
Have you tried it on some other server?
May the Source be with you!
urlkiller
#5 2009-06-07 23:25
found the mistake.

indeed the problem did not arose from the special chars.
it was more a problem about the conversion of database and given input.

i had entered something that was outputted wrong later on and saved again in the new format.
this was causing the false var to get not converted in utf not from the site itself nor the database.

after i changed it manually in the database it worked fine. dont know, somehow it missed this char only... was kinda frustating searching for the problem. because it wasnt really one.

;)
URL shortener: <a href="http://bbm.li/!7AD5C7">http://bbm.li/!7AD5C7</a>