Am Freitag, 20. November 2015 18:56:56 UTC+1 schrieb Thomas Mueller:
>
> Hi,
>
> What problem do you want to solve?
>
> The "\u" you should only see in the SQL script, not in the actual
> database file.
>
> > The mySQL DB has about 15 MB and the migrated H2 DB has about 45 MB.
>
> For H2, di
Am Freitag, 20. November 2015 17:59:21 UTC+1 schrieb Dieter Blerms:
>
>
> So what happens when closing the DB that the file size increases from 29
> MB to 47 MB?
>
> I think i found out what happens:
as the tables are cached tables, the index tables are stored in memory and
Well, the database size increases more an more. For e.g.:
- The dump size is about 33 MB (with escaped utf-8 chars). When i import
this dump in a new, embedded H2 db, the DB-size is about 29 MB.
- When i close the db (via H2 web console), the DB-size is about 47 MB.
So what happens when closing
Am Freitag, 20. November 2015 14:26:10 UTC+1 schrieb Noel Grandin:
>
> http://h2database.com/html/grammar.html#script
>
First of all: thank you Noel Grandin for your help and the quick answers.
I tried the following:
SCRIPT TO '~/backup_test3.sql' CHARSET 'UTF-8'
and this
SCRIPT TO '~/backup
Am Freitag, 20. November 2015 07:34:08 UTC+1 schrieb Noel Grandin:
> H2 internally stores character data in UTF8.
>
Thx for the quick answer.
Is there a way to get also a UTF8 db dump instead of replacements like
STRINGDECODE('\u ...
?
--
You received this message because you are subscribe
Hello,
atm I'm developing a Java-Application with an embedded H2 DB. The DB is
migrated from mySQL (kinda dictionary). The SQL-dump has about 500.000
lines (5 tables). The mySQL DB has about 15 MB and the migrated H2 DB has
about 45 MB.
After exporting the DB, all UTF8 glyphs are escaped with t
