cotonti.com : entering special chars in profile

urlkiller

Нд, 07 Чер 2009 23:25:23 -0000

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.

;)

Trustmaster

Нд, 07 Чер 2009 16:16:19 -0000

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?

urlkiller

Сб, 06 Чер 2009 21:00:17 -0000

my db is utf8 unicode as well as the settings on the webpage.7both utf8 but nothing is working with special chars..

any solutions?

pieter

Пт, 17 Кві 2009 19:44:00 -0000

You need to check your database. It needs to be UTF8 I believe.
There are some topics about it in the forum.

urlkiller

Пт, 17 Кві 2009 19:40:24 -0000

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?