±Û¾´ÀÌ :ÀÌÁöÈÆ 2000³â 2¿ù 25ÀÏ 19:01:23
Java Servlet°ü·Ã Áú¹®ÀÔ´Ï´Ù.
ȯ°æ:
OS: WinNT4.0
Webserver: JavaWebserver2.0 (jre 1.1.7)
Database: MS-SQL7.0
Driver Type: jdbc-odbc bridge (sun.jdbc.odbc.JdbcOdbcDriver)
ȯ°æÀÌ ÀÌ·¡¼
¸Å¹ø queryÇÒ¶§
String szSQL = "insert into ...";
szSQL = new String(szSQL.getBytes(), "KSC5601");
szSQL = new String(szSQL.getBytes(), "iso-8859-1");
con.executeUpdate(szSQL);
Áï KSC5601 -> iso-8859-1 ·Î convertingÇؼ
Äõ¸®¸¦ ½ÇÇàÇÏ°í ÀÖ½À´Ï´Ù.
±Ùµ¥ Á¦°¡ À̹ø¿¡ ÀüÀÚ¸ÞÀÏÀ» ±¸ÇöÇÏ´Ù°¡
iso-2022-kr ·Î ÀÎÄÚµùÇÑ ¸ÞÀÏÀ» ¹Þ¾Æº¸°Ô µÇ¾ú´Âµ¥¿ä,
Subject: =?ISO-2022-KR?B?GyQpQw5AfEFWP3k1ZURFMGYxYkBlMHw3QyBGREBPPFs6Tg8=?=
À̶ó°í µÇ¾î ÀÖ¾î¼
RFC1557(iso-2022-kr¿¡ °üÇÑ ¹®¼)¿¡ µû¶ó¼
ÇѱÛÀ» ÃßÃâÇß½À´Ï´Ù.
´ëÃæ ÇѱÛÀ̸é MSB¸¦ 1·Î set ½ÃÅ°´Â°Ô ¾Ë°í¸®ÁòÀÇ ÀüºÎ´õ±º¿ä..
System.out.println(subject:" + subject);
Çϸé Á¦´ë·Î ÂïÈü´Ï´Ù.
ÇÏÁö¸¸ DB¿¡ ³ÖÀ»¶§¿¡´Â
String szSQL = "insert into ..." + subject + ".."
szSQL = new String(szSQL.getBytes(), "KSC5601");
szSQL = new String(szSQL.getBytes(), "iso-8859-1");
con.executeUpdate(szSQL);
ÇÏ°í ³ÖÀ¸¸é
ÇѱÛÀÌ ±úÁ®¹ö¸®±â ¶§¹®¿¡
ÀÚ²Ù SQLExceptionÀÌ ¹ß»ýÇÕ´Ï´Ù.
¿¡·¯ ¸Þ½ÃÁö´Â
unclosed quotation mark before ...
subject ºÎºÐÀÌ '?'·Î¸¸ ÂïÈü´Ï´Ù.
MSB°¡ Àß·ÁÁ® ³ª°¡´Â°Å °°½À´Ï´Ù.
¾î¶»°Ô Çϸé Á¦´ë·Î ³ÖÀ»¼ö°¡ ÀÖÀ»±î¿ä?