Hi, I just noticed that my backup script created using the SCRIPT command could not be read in by the RUNSCRIPT command since it contained special characters in SQL identifiers (column names). I had to append the option CHARSET 'UTF-8' to the RUNSCRIPT command, which made me check with the SCRIPT command documentation. It turns out that the SCRIPT command does neither have an option for setting the output character set nor does it specify which one is used (UTF-8 I assume, but might also have been the the platform default). This mismatch should be fixed by documenting the character set that gets used by default and maybe also by adding the CHARSET option to the SCRIPT command.
Best regards, Michael -- 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.
