Skip to content

Instantly share code, notes, and snippets.

@joni
Created June 12, 2012 16:56
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save joni/2918685 to your computer and use it in GitHub Desktop.
Save joni/2918685 to your computer and use it in GitHub Desktop.
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();
}
}
@peterkellydev
Copy link

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