Re: Java String saving as unicode in database - Mailing list pgsql-jdbc

Hello,

Example:

private void testInsertUTF(Connection con)
    {
       // Method Instances
       String sqlStatementString;
       Statement sqlStatement;
       PreparedStatement pstmt;
       ResultSet rs;

       try
       {
          // Setup a connection statement.
          sqlStatement = con.createStatement();

          // Create table.
          sqlStatementString = "DROP TABLE IF EXISTS jdbc_demo";
          System.out.println(sqlStatementString);
          sqlStatement.execute(sqlStatementString);

          sqlStatementString = "Create Table jdbc_demo (col VARCHAR(30))";
          System.out.println(sqlStatementString);
          sqlStatement.execute(sqlStatementString);

          // Insert data.
          System.out.println("Inserting Data");
          pstmt = con.prepareStatement("INSERT INTO jdbc_demo VALUES (?)");
          pstmt.setString(1,
"*Sample\u0020\u0061\u0074\u0020\u0032\u0032\u0042\u0020 text*");
          pstmt.execute();

          // View data.
          sqlStatementString = "SELECT * FROM jdbc_demo";
          System.out.println(sqlStatementString);
          sqlStatement.execute(sqlStatementString);

          rs = sqlStatement.executeQuery(sqlStatementString);

          JPanel panel = new JPanel();

          while (rs.next())
          {
             String dataString = rs.getString("col");
             System.out.println("col:" + dataString);
             panel.add(new JLabel(dataString));
          }
          rs.close();

          JFrame frame = new JFrame();
          frame.getContentPane().add(panel);
          frame.setSize(200, 200);
          frame.setVisible(true);

          // Clean up.
          sqlStatementString = "DROP TABLE IF EXISTS jdbc_demo";
          System.out.println(sqlStatementString);
          sqlStatement.execute(sqlStatementString);

          sqlStatement.close();
          pstmt.close();
       }
       catch (SQLException sqle)
       {
          System.out.println("SQL Exeception" + sqle);
       }
    }

saisantoshi wrote:
> Hi,
>
> I want to store java string as a unicode string in the database. Please let
> me know if this is possible?
>
> For example :
>
>   String columnValue="*Sample
> \u0020\u0061\u0074\u0020\u0032\u0032\u0042\u0020 text*";
>
> I want to save the above exactly (as it is which is bolded) into the
> database and retreive it.
>
> DB column should store as :
>
> ColumnA
> ---------
> Sample \u0020\u0061\u0074\u0020\u0032\u0032\u0042\u0020 text    ( with
> unicode string value)
>
>
> When  read it back from java, it should display:
> Sample  at 22B  text
>
> --
> View this message in context:
http://postgresql.1045698.n5.nabble.com/Java-String-saving-as-unicode-in-database-tp5774370.html
> Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.