Hi, H2 uses the JDBC driver of the target database, and doesn't normally do any conversion itself (from byte array to string), as it uses ResultSet.getString() and so on. So if you got encoding problems, it most likely happens before H2 is involved.
Regards, Thomas On Wed, Aug 8, 2012 at 1:43 PM, Peter Dahm <[email protected]>wrote: > Hi, > > I'm trying to migrate data from an access database to a h2 database. > > Up to know I created a in memory database and linked the access source > table and the destination h2 table. With this both linked tables I'm able > to copy the data with an "insert into select from" statement from one > database to another. > > In the first place everything works pretty good. It's fast and I have no > memory problems. > > Unfornately the source table has an CP1252 encoding an the h2 destination > table is utf-8. For this reason I'm loosing some special character like ä,ü > ... > > Does someone has any idea how to solve this problem ? I did not find any > parameter to define a character set while creating the linked table. > > Thanks > > Peter > > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
