os : windows xp
db : mysql 5.0
소스코드 하단에 첨부
utf8에 대한 언급만 보셔도 아시겠지만. 한글외 다국어를 모두표기하려 합니다.
mysql> show variables like 'c%';
+--------------------------+---------------------------------------------------------+
| Variable_name | Value |
+--------------------------+---------------------------------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | C:\Program Files\MySQL\MySQL Server 5.0\share\charsets\ |
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
| completion_type | 0 |
| concurrent_insert | 1 |
| connect_timeout | 5 |
+--------------------------+---------------------------------------------------------+
14 rows in set (0.00 sec)
//
CREATE TABLE `abc` (
`aaa` varchar(1024) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8
1. utf8로 저장은 어떻게 해야 하나요?
insert into table values('좋은하루'); // 데이타를 넣기 위해 어떤게 해야 할까요?
2. utf8로 저장된 데이타를 읽어와서 다시 explorer에 출력하려면 어떻게 해야 할까요?
select aaa from abc;
========================소스코드===========================
<% @LANGUAGE="VBSCRIPT" CODEPAGE="65001" %>
<% Response.Charset = "utf-8"%>
<%
response.write "Sample Data : 가-나-Ğ-Ü-ĥ-ě-ğ-ķ-Ć-Ė-IJ-ʼn-ǽ-Ǿ-ǻ-Ǽ<BR><BR><BR>"
'@@@ Mysql 5.x Test
Dim TED_DB : TED_DB = "DSN=nileblue;UID=;PWD="
Set DbConn = Server.CreateObject("ADODB.Connection")
DbConn.open TED_DB
'DbConn.execute("set names utf8")
if request("gub") = 1 THEN
'@@@ INSERT
Get_Data = "insert into abc values('"&request("ddd")&"') "
response.write Get_Data
DbConn.execute(Get_Data), row
response.write now() & "<BR>"
response.write "SQL:" & Get_Data & "<BR>"
response.write "update rows:" & row & "<BR><BR>"
elseif request("gub") = 2 THEN
'@@@ DELETE
Get_Data = "delete from abc "
DbConn.execute(Get_Data), row
response.write now() & "<BR>"
response.write "SQL:" & Get_Data & "<BR>"
response.write "delete rows:" & row & "<BR><BR>"
end if
%>
<html>
<head>
<title>TEST</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<script>
function selectdata()
{
location.href = "nileblue_test.asp?gub=0";
}
function insertdata()
{
test_from.gub.value=1;
// test_from.ddd.value = escape(test_from.ddd.value);
test_from.submit();
}
function deletedata()
{
location.href = "nileblue_test.asp?gub=2";
}
</script>
<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<style type="text/css">
.shorttitle { width: 280; height: 20; display: inline-block; overflow: hidden;text-overflow:ellipsis; }
td, th { font-size: 9pt; line-height: 160%; }
</style>
<form name="test_from" method="post" action="nileblue_test.asp">
<input type="hidden" name="gub" value="">
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td> </td>
<td width="1024" align="center" valign="top"><table width="1006" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><table width="1006" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="587"><table width="587" border="1" cellspacing="0" cellpadding="0">
<tr>
<td height="26" colspan="2">
<input type="button" name="aaa" value="Select" onclick="selectdata();">
<input type="button" name="bbb" value="Insert" onClick="insertdata();"><input type="text" name="ddd" maxlength="10">
<input type="button" name="ccc" value="Delete" onclick="deletedata();"></td>
</tr>
<%
'@@@ QUERY
SQL = "select aaa from abc"
set rs = DbConn.execute(SQL)
if rs.eof then
%>
<tr><td width="575" align="center" bgcolor="#FFFFFF">No Data!!</td></tr>
<%
'response.write "value:NOTHING<BR>"
else
do until rs.eof
%>
<tr><td width="575" align="center" bgcolor="#FFFFFF"><%=rs(0)%></td></tr>
<%
'response.write "value:"&rs(0)&"<BR>"
rs.movenext
loop
end if
%>
<tr><td width="575" align="center" bgcolor="#FFFFFF">*************************************************</td></tr>
<%
'@@@ character set
SQL = "show variables like 'c%'"
set rs = DbConn.execute(SQL)
if rs.eof then
%>
<tr><td width="575" align="center" bgcolor="#FFFFFF">No Data!!</td></tr>
<%
'response.write "value:NOTHING<BR>"
else
do until rs.eof
%>
<tr><td width="575" align="center" bgcolor="#FFFFFF"><%=rs(0)%> >> <%=rs(1)%></td></tr>
<%
'response.write "value:"&rs(0)&"<BR>"
rs.movenext
loop
end if
DbConn.close
set DbConn = nothing
%>
<tr>
<td height="12" colspan="2"></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table> </td>
<td> </td>
</tr>
</table>
</form>
</body>
</html>
========================소스코드=========================== |