if i update my database mysql, the character not correct update in the database:
set vorname = 'Gdańsk'
where id = '1604'
In the database stand: Gda?sk
The character encoding on the site seems ok.
in HTML it shows:
does anybody knows the problem ?
If you are going to use characters like that, you need to change the datatype of the column. I'm assuming you set it for varchar; change it to nvarchar, re-do the update and see if that fixes it.
if i insert it on command line.
the characters are correct.
only if i insert it via web site..
the characters are damaged.
If you are getting the erroneous character replacement by submitting it via a web page, browsers are (by default) set for UTF-8 encoding.
The output on my screen is in the image.
but the characters are not in the database.
in the database is "Gda?sk4"
it seems that the cfquery dont use the correct characters...
Are you using cfqueryparam? Is the field data type nvarchar? You can also check to see if the string format option is ticked in the datasource setup in CF admin.
String Format - Enable High ASCII characters and Unicode for data sources configured for non-Latin characters
Also is your sql db charset UTF8?
i have solved the problem on visitenkarten.com
the solution is very simple.
in the coldfusion administrator i insert the connection string in the database:
in the database fields it is important that the fields are
character set: utf8
and the collation: utf8_gereral_ci
now it works.