How to store text and pictures in MySQL

Clob long text type (not supported in MySQL, text is used instead)
Blob binary type

Text long text type TINYTEXT: 256 bytes
  TEXT: 65,535 bytes => ~64kb
  MEDIUMTEXT: 16,777,215 bytes => ~16MB
  LONGTEXT: 4,294,967,295 bytes => ~4GB
Blob binary type

CREATE TABLE test(
   id INT PRIMARY KEY AUTO_INCREMENT,
   content LONGTEXT, -- text field img LONGBLOB -- picture field);

// When storing text, set the parameter to character stream FileReader reader
pstmt.setCharacterStream(1, reader);
// When getting parameters // Method 1:
Reader r = rs.getCharacterStream("content");
// Get long text data, method 2:
System.out.print(rs.getString("content"));
// When storing binary images // Set the parameter to the binary stream InputStream in 
pstmt.setBinaryStream(1, in);
// Get the binary stream InputStream in = rs.getAsciiStream("img");

/**
 * Save Photo* 
 */
@Test
public void test2(){
  String sql = "insert into test(img) values(?)";
  try{
    con = JDBCUtil.getConnection();
    pstmt = con.prepareStatement(sql);
    // Set parameters // Get text File file = new File("f:/a.jpg");
    InputStream in = new FileInputStream(file);
    // Set the parameter to binary stream pstmt.setBinaryStream(1, in);
    // Execute sql
    pstmt.executeUpdate();
    in.close();
  }catch (Exception e) {
    e.printStackTrace();
  }finally{
    try {
      JDBCUtil.close(con, pstmt);
    } catch (Exception e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    }
  }
}
/**
 * Get photos * 
 */
@Test
public void test3(){
  String sql = "select * from test where id=?;";
  try{
    con = JDBCUtil.getConnection();
    pstmt = con.prepareStatement(sql);
    // Set parameters pstmt.setInt(1, 2);
    // Execute query rs = pstmt.executeQuery();
    while(rs.next()){
      byte[] buff = new byte[1024];
      InputStream in = rs.getAsciiStream("img");
      int l=0;
      OutputStream out = new FileOutputStream(new File("f:/1.jpg"));
      while((l=in.read(buff))!=-1){
        out.write(buff, 0, l);
      }
      in.close();
      out.close();
    }
  }catch (Exception e) {
    e.printStackTrace();
  }finally{
    try {
      JDBCUtil.close(con, pstmt);
    } catch (Exception e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    }
  }
}