Store and retrieve Chinese characters using Coldfusion MX7 and MySQL5.0

'Inputting Chinese Text to MySQL Database in UTF-8' tutorial was cited in an Experts Exchange forum post in 2008.

The Inputting Chinese Text to MySQL Database in UTF-8 tutorial was cited in an Experts Exchange forum post in 2008.

Subject: How to store and retrieve Chinese and other foreign 
   characters using Coldfusion MX7 and MySQL5.0?
Date: Sep 11, 2008
Author: ramesh_ayyanar
Source: http://www.experts-exchange.com/Database/MySQL/Q_23725448.html

My client needs to convert their survey questions and answers in
different foreign languages mainly Chinese and Russian. Currently all
are working well in English. If I try to store the chinese characters
by using CFQUERY, I got the following error:

Error Executing Database Query.
General error: Incorrect string value: '\x82\x08' for column
'String_UTF8' at row 1
...

I was frustrated with the output. I write this script by using the 
following PHP script. But PHP script works fine with same Mysql 
Database.

<?php #MySQL-Input-Chinese-UTF8.php
# Copyright (c) 2007 by Dr. Herong Yang, http://www.herongyang.com/
#
  print('<html><head>');
  print('<meta http-equiv="Content-Type"'.
    ' content="text/html; charset=utf-8"/>');
  print('</head><body>'."\n");
...

Table of Contents

 About This Book

 Reference Citations in 2017

 Reference Citations in 2016

 Reference Citations in 2015

 Reference Citations in 2014

 Reference Citations in 2013

 Reference Citations in 2012

 Reference Citations in 2011

 Reference Citations in 2010

 Reference Citations in 2009

Reference Citations in 2008

 QaTraq Pro API

 Service Oriented Computing for Dynamic Virtual Learning Environments

 Inverted ?

 Migrating files to new computer

 mswsock.dll!WSPStartup +0x102b

 edu.uiuc.ncsa.soap.SOAPUtil.java

 MSSQL binary data

 Correct Character Encoding

 Put icons on bookmarks sidebar folders

 Blob Storage via REST from Java?

 java.lang.OutOfMemoryError: unable to create new native thread

 Obróbka filmów VOB

 ASP Search Function

 SSLHandshakeException unable to find valid certification...

 Using response.setContentType to switch HTML to Word

 Automatic Creation of Different Types of Test Subjects

 ISM 6121 Information Systems Implementation

 JVMSTAT[JSTAT]

 Time out bei Aufruf von WebService (php-Script)

Store and retrieve Chinese characters using Coldfusion MX7 and MySQL5.0

 converting VCD player to DVD player

 tomcat中配置https

 αρχειο .pl

 Using ASP.Net c# To add/edit/delete data (ms access)

 regarding JDBC

 A UML/SPT Model Analysis Methodology

 Creation d'un nouvel utilisateur sous SQL Server 2000

 No Suitable Driver connecting jdk1.5 with javaDB derby

 Page in Chinese

 Acessar MSAccess com Hibernate

 SiLu – Riktlinjer för spelmotor

 [WebService] come fare?

 JDBC help needed; java.lang.NoClassDefFoundError

 CSV export of tickets has wrong encoding

 MapGuide Manual - Active selections

 Reference Citations in 2007

 Reference Citations in 2006

 Reference Citations in 2005

 Reference Citations in 2004

 Reference Citations in 2003

 PDF Printing Version