Insert java utf-16 strings into postgres character fields

Question

HI, I have a postgres database with latin1 charset, and a table "user". I need to insert the name of the users using a prepared statement in java

boolean success = false;  
String query = "INSERT INTO public.user (name,email) VALUES(?,?)";  
try {  
  PreparedStatement ps;  
  ps = db.prepareStatement(query);  
  ps.setString(1, user.getName());  
  ps.setString(2, user.getEmail());  
  if (ps.executeUpdate() != 0)  
    success = true;  
  ps.close();  
} catch (SQLException ex) {  
} finally {  
  return success;  
}

The problem is when user.getName() and user.getEmail() contains characters with accents like è,ò, and so on, the table store weird characters. How can save the right characters sequence from java utf-16 to postgres latin1 charset encoding?

jtahlborn · Accepted Answer · 2011-03-15 00:00:16Z

4

you don't need to do anything special, the jdbc driver handles all the conversions for you. the problem, however, is that the latin1 charset cannot encode all available characters (it only supports 256 characters). so, you will lose certain characters if you attempt to put them in your table. if you are serious about storing international data, you must make your tables store some variant of unicode (utf8, utf16, etc). (you would need to fix this at the database level using some postgres specific configuratino).

answered Mar 15, 2011 at 0:00

jtahlborn

53.8k5 gold badges80 silver badges122 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mike Samuel · Accepted Answer · 2011-03-15 00:44:10Z

0

jtahlborn is right about your problem.

Take a look at http://www.postgresql.org/docs/8.2/static/multibyte.html to understand multibyte encodings in postgre.

answered Mar 15, 2011 at 0:44

Mike Samuel

121k30 gold badges230 silver badges255 bronze badges

Collectives™ on Stack Overflow

Insert java utf-16 strings into postgres character fields

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related