Create a gist now

Instantly share code, notes, and snippets.

MySQL stored procedure with UTF-8 parameters and a JDBC client
CREATE PROCEDURE hello(str varchar(20) character set utf8)
BEGIN
select concat('Hello ', str);
END
import java.sql.*;
class Test {
public static void main(String [] args) throws Exception {
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection(
"jdbc:mysql://localhost/test?characterEncoding=utf8", "user", "pass");
Statement s = conn.createStatement();
s.execute("call hello('겠겠지만');");
ResultSet rs = s.getResultSet();
rs.next();
System.out.println(rs.getString(1));
s.close();
conn.close();
}
}
@peterkellyonline

Great, really helped. I am using org.springframework.jdbc.core classes rather than java.sql - must be the version of the driver spring is using...

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment