Am Freitag, 20. November 2015 18:56:56 UTC+1 schrieb Thomas Mueller: > > Hi, > > What problem do you want to solve? > > The "\uxxxx" 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, did you shrink the database using "shutdown defrag"? >
This actually worked :-) DB size after SHUTDOWN DEFRAG is 20 MB. > > Is there a way to get also a UTF8 db dump instead of replacements > > No, right now creating a SQL script in that way is not supported. However, > you could use CSVWRITE, create your own export, or convert the SQL script. > But why would you need it? > > I can import a SQL-dump with UTF-8 chars in it (without \u syntax). When i export it again, the \u syntax is used. This makes the dump unreadable and raises the file size to more than 50%. So I don't really need it without the \u syntax. But I also can't see any advantage in it. Have you planned to get this feature working for the future (SCRIPT TO '<filename>' CHARSET 'UTF8')? Thx for your help :-) -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
