Hi to everybody, I m using H2 for a project where one of the functions is to store text of a size 100-2000 characters. This text is highly compressible. Hence I have three questions:
1. Is there a way to compact a String within H2. COMPRESS does not seem to reach the desired size. Actually it is getting even larger. 2. When I compress the fields already within my own program resulting in an byte array of unknown size how can I store this byte array into the database? Here is really the size which matters. The text takes around 90% of the complete size requirements. Is it enough to use the BINARY datatype? Or should I use the array datatype? 3. My program supports both Postgresql and H2. One getting data from a server, H2 is rather used for the local machine. Since users want to copy the database without the need of a dump. is it somehow possible to send the database file together with the login parameters to another user (and another machine) who then can open the database (as a kind of a file) via JDBC and work on it. I know this is kind of a stupid question since a database should avoid this manors but the users wish to have this functionality. Thx a lot to everybody who will help me. I m pretty sure you will solve my problems. HJ -- 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.
