outputting cyrillic from mysql database
I've tried everything
I've added ?useUnicode=true&characterEncoding=utf8 to my odbc connection string
I've downloaded and tried using the mysql jdbc 5 driver with and without ?useUnicode=true&characterEncoding=utf8
I've added <cfprocessingdirective pageEncoding="utf-8">
I've added <cfcontent type="text/html; charset=UTF-8">
I've added <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
I've added <cfquery name="test" datasource="jdbcTest">
set names 'utf8'
</cfquery>
The characters are in the tables properly because php scripts pull them out properly.
here's the code I'm using to test the functionality
<cfprocessingdirective pageEncoding="utf-8">
<cfcontent type="text/html; charset=UTF-8">
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<cfquery name="test" datasource="jdbcTest">
set names 'utf8'
</cfquery>
<cfquery name="test" datasource="jdbcTest">
select products_name from products_description order by products_name desc;
</cfquery>
<cfoutput>
#test.products_name#<br />
</cfoutput>
</body>
</html>
in the databse: Дослідники Археології Україн
on the page: Лекції з історії української літер
I'm at a loss.
AdChoices