ColdFusion 7.x和MySQL 4.1.x连接

debian:~# nmap localhost

Starting nmap 3.81 ( http://www.insecure.org/nmap/ ) at 2006-01-14 11:22 CET
Interesting ports on localhost.localdomain (127.0.0.1):
(The 1654 ports scanned but not shown below are in state: closed)
PORT     STATE SERVICE
21/tcp   open  ftp
22/tcp   open  ssh
25/tcp   open  smtp
53/tcp   open  domain
80/tcp   open  http
110/tcp  open  pop3
143/tcp  open  imap
953/tcp  open  rndc
3306/tcp open  mysql

Nmap finished: 1 IP address (1 host up) scanned in 0.809 seconds
debian:~# 
debian:~# netstat -a | grep mysql 
tcp        0      0 localhost.localdo:mysql *:*                     LISTEN     
unix  2      [ ACC ]     STREAM     LISTENING     4245     /var/run/mysqld/mysqld.sock
debian:~#

use unicodetest;

CREATE TABLE `turkce` (
  `id` int(4) NOT NULL auto_increment,
  `testfield` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

insert  into turkce values 
(1, 'Türkçe Test ğĞ üÜ ıİ şŞ öÖ çÇ'), 
(2, '�것� 한국어 �다');

<cfset request.mydsn = "unicodetest">
<strong>Unicode Test</strong>
<br />
<br />
<cfoutput>
<a href="#script_name#">List</a>
<br />
<br />
<form action="#script_name#" method="post">
        <input name="testfield" type="text" value="Türkçe Test ğĞ üÜ ıİ şŞ öÖ çÇ" />
        <br />
        <input name="AddNewRecord" type="submit" value="Add" />
</form>
</cfoutput>
<cfif IsDefined("AddNewRecord")>
        <cfquery name="AddNewRecord" datasource="#request.mydsn#">
                INSERT INTO        turkce
                        (testfield)
                VALUES
                        ('#trim(testfield)#')
        </cfquery>
</cfif>
<br />
<br />
<cfquery name="GetResults" datasource="#request.mydsn#">
        SELECT        id, testfield
        FROM        turkce
</cfquery>
<cfoutput query="GetResults">
        #testfield# <br />
</cfoutput>