My SQL in sumniki iz jave...

[valencic at e-tree.com]

Ok pa mi je le uspelo spokati sumnike v bazo..

- Na zacetku je potrebno prijaviti Encoding in pa useUnicode na TRUE....

(upam da bo komu pomagalo).....



torej naredil sem sledece:
-----------------------------------------------------
...
.
.

    Properties pr = new Properties();
    pr.put("characterEncoding", "Cp1250");
    pr.put("useUnicode", "TRUE");

    Class.forName("org.gjt.mm.mysql.Driver").newInstance();
    Connection connection = DriverManager.getConnection("jdbc:mysql://192.168.80.12:3306/pero",pr);
    Statement statement = connection.createStatement();
    ResultSet resultset = statement.executeQuery("SELECT * FROM tabelca");
    String update = "update tabelca set name='tle pridejo sumniki' where id=1";

       Statement st = connection.createStatement();
       int poda = st.executeUpdate(new String(update.getBytes(),"Cp1250"));

     while( resultset.next() )
     {
           System.out.println( resultset.getString(2) + " " );
           byte[] pod = resultset.getBytes(2);
           System.out.println("-> "+ new String(pod,"Cp1250"));


     }
         resultset.close();
         statement.close();
         connection.close();

-------------------------------------------------------------------------------

lp
Peter Valencic