Character set conversions in Database
Posted on 1998-07-30
I have created a database in Access, which I access through the JDBC-ODBC bridge from a Java application. I have the following problem: Access seems to store the Greek characters as bytes using the encoding "Cp1253". I have managed to correctly convert these bytes to String and read the contents of the database. But I don't know how to convert the input Strings and store them to the database. I know that String.getBytes("Cp1253") will give me a correctly converted byte array, but how can this array be used in a SQL statement for a field that expects strings?