Display Russian data from mysql with coldfusion

2
votes

I have a mysql database set up with the Character Set as utf8 and the Collection set as utf8_general_ci.

I can see the Russian text in the database is all fine.

I have added a <cfprocessingdirective pageEncoding="utf-8"> in the coldfusion pages. If I type in russian text directly in the cfm page, it displays fine in the browser.

However, If I us a cfquery to pull in the data to display it in the browser, it displays incorrectly i.e. ЎБÐ.

my cfquery is a very simple...

<cfquery name="getStatic" datasource="#session.odbcname#">
SELECT  *
FROM    static_id
WHERE   static_displayname = 'home'
AND     static_status = 'online'
</cfquery>

and then use a cfoutput to display the data #getStatic.data#.

any ideas on how to get the data pulled in to display correctly?

Thanks

2
mysqlutf-8coldfusion
cfprocessingdirective doesn't affect dynamic queries. 1) Did you try specifying character set in the dsn url? stackoverflow.com/a/29595897/8895292 2) You said "I have a mysql database set up with..." double check the actual table and column inherited the correct settings. - SOS
Did you try my 2 suggestions above? If you're not getting the right output, then 1 or more of those settings probably isn't what you think they are... If you haven't already, double check the column settings first SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'static_id'. - SOS
Hi Ageax, thanks for your input. Sadly no joy, I have added various connection strings form your suggested link and others with no joy. I have also created new tables in mySQL with Character Sets utf8 and utf8mb4 and also with a Collection of utf8_general_ci and utf8mb4_general_ci and sadly no joy. :-( - elixireu
That is very odd.. Maybe it is something specific to the hosting environ? I tried those settings for grins ... and outputting Russian text works no problem. Aside from asking your host, have you tried it on another machine? Easy enough to spin up a dev instance and try it there. - SOS
Hi Ageax, many thanks for your help, it looks like your idea of trying another machine works - it looks like the machine I was using was inputting the Russian text fine but for what ever reason it was not importing into the mySQL correctly. Even thou I could view Russian text in my mySQL client. - elixireu

2 Answers

1
votes

Add this to the top of your page.

<cfprocessingdirective pageencoding = "utf-8">

Or better yet, add it to the onRequest() event of your application.cfc if you need it on every page.

https://helpx.adobe.com/coldfusion/cfml-reference/coldfusion-tags/tags-p-q/cfprocessingdirective.html

1
votes

ЎБ is 'Mojibake' for ЎБ

In UTF-8, the hex is D08E D091. If that is treated as latin1, hex D0 8E D0 91 means ЎБ.

But, it could also be "double-encoding", and the hex in the table is C390 C5BD C390 E28098. Please do SELECT HEX(col) ... to see which you have.

Double-encoding is a silent error -- usually everything looks ok, while the stored value is wrong.

Look for 'Mojibake' in here for a list of things to check in your code.

(For Cyrillic, CHARACTER SET utf8 and utf8mb4 act identically. They differ primarily for Emoji and Chinese.)

My skimpy notes on ColdFusion say

<cfprocessingdirective pageEncoding="utf-8">

<cffile
action="read"
file="#settings.csvfile#"
variable="autodata"
charset="utf-8">

(Ugh. I counted them. I have notes on 45 3rd-party packages such as ColdFusion. Forgive me if I don't speak authoritatively on one of them.)