asked on Character Set in CF for German Umlaut Characters
What character set should I be using when trying to display German Umlaut characters (ä ö ü ß)? I'm using utf-8 throughout the site. I'm using CF 9 with SQL 2012.
Sometimes if I place the umlaut character inside a cfinput or cftextarea, etc. all I get is the ä instead of ä. I have the umlaut characters as values in SQL DB but that info not displaying properly either. Also...within some ajax areas of the site, the umlaut characters are replaced with a box.
I've seen some posts throughout the web referring to using ISO-8859-1. Not sure if this is a fix all and if it's going to affect and mess up the rest of the site.
Ideas on how to resolve is greatly appreciated at this point. Thank you.
Sometimes if I place the umlaut character inside a cfinput or cftextarea, etc. all I get is the ä instead of ä. I have the umlaut characters as values in SQL DB but that info not displaying properly either. Also...within some ajax areas of the site, the umlaut characters are replaced with a box.
I've seen some posts throughout the web referring to using ISO-8859-1. Not sure if this is a fix all and if it's going to affect and mess up the rest of the site.
Ideas on how to resolve is greatly appreciated at this point. Thank you.
ColdFusion Language
Last Comment
_agx_
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
No go cathal...didn't work. Still get the entity code showing on the page. Actually I got a CF error first because it was confused with the single #.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
1) The database column type is set as qn_nm (nvarchar(255),not null)
2) Example, Möchten Sie an der Umfrage teilnehmen?
3) select * from rfd_svy_dt x, rfd_qn y where x.qn_id = y.qn_id and x.svy_id = #arguments.svy_id# and svy_qn_seq_n = #arguments.qnum#
4) #qn_nm1# within a cfloop
Pages are set for <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
2) Example, Möchten Sie an der Umfrage teilnehmen?
3) select * from rfd_svy_dt x, rfd_qn y where x.qn_id = y.qn_id and x.svy_id = #arguments.svy_id# and svy_qn_seq_n = #arguments.qnum#
4) #qn_nm1# within a cfloop
Pages are set for <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
ASKER
I've now tried to change the DB collation, replaced all utf-8 references to UTF-8, and made sure every page reference showed charset='UTF-8'. I have yet to find anything that works. Still searching...deadline approaching March 27.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
We ended up resolving this within our code and database values. We found an issue with our translation code that was not processing on the cf page correctly. Once we corrected that, the umlauts were displaying properly within the pages.
I awarded points to all who took the time to respond. Thank you!
I awarded points to all who took the time to respond. Thank you!
> translation code
Glad to hear you were able to solve it! If you get a chance - do you know what code/encoding specifically caused the problem? (I was not clear on that) Might help the next guy that runs into it.
Glad to hear you were able to solve it! If you get a chance - do you know what code/encoding specifically caused the problem? (I was not clear on that) Might help the next guy that runs into it.