Notes on Reference Citations - Version 2.71, by Dr. Herong Yang
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