無垠天際

簡單心得： my.ini [mysqld] ...略 # The default character set that will be used when a new schema or table is # created and no character set is defined #default-character-set=latin1 default-character-set=utf8 注意：是utf8不是utf-8，寫錯將導致MySQL服務無法啟動。 每個table在設定欄位都要指定為utf-8(column charset, column collate) 此圖是MySQL Query Browser的設定畫面。 如果你原本已經設定了其他編碼，要改成utf8，文字內容可不會自行轉碼，你要自己想辦法將文字內容轉換再存進去。

MySQL, JDBC, Eclipse 下載 MySQL JDBC產品 Connector/J 自行解壓到一個自訂目錄 設定Eclipse，匯入此JDBC JAR Project/Properties Libraries/Add External JAR 選擇Connector/J所在的目錄，找到名為 mysql-connector-java- [version] -bin.jar 的JAR檔 測試程式碼 import java.sql.*; public class MysqlConnect { public static void main ( String [] args ) { System.out.println ( "MySQL Connect Example." ) ; Connection conn = null ; String url = "jdbc:mysql://localhost:3306/" ; String dbName = "jdbctutorial" ; String driver = "com.mysql.jdbc.Driver" ; String userName = "root" ; String password = "root" ; try { Class.forName ( driver ) .newInstance () ; conn = DriverManager.getConnection ( url+dbName,userName,password ) ; System.out.println ( "Connected to t...