hi herbert On Fri, Aug 14, 2009 at 11:35 AM, herbert<[email protected]> wrote: > > Hi, > > we've integrated Jackrabbit into JBoss-Portal with MySQL as the underlying > database. > > The default-charset of MySQL is set to UTF-8. > > During first startup jackrabbit creates its tables in the MySQL-Database. > > These tables are generated with the character set UTF-8: > datastore, default_bundle, default_names, default_refs, version_binval, > version_bundle, version_names, version_refs. > > These tables are generated with the character set Latin1: > default_fsentry, repo_fsentry, version_fsentry. > > I wonder, why the *_fsentry-tables get the character set Latin1? (Btw, this > happens on windows-systems and also on linux-systems) > > Can anyone explain the latin1-encoding?
please see http://issues.apache.org/jira/browse/JCR-1049 > Is there a way to set the encoding of these tables to UTF-8? you could perhaps change the encoding with an "alter table..." statement. alternatively, you could create your own .ddl script. please keep in mind that latin1 has been chosen on purpose as utf-8 leads to the issue described in JCR-1049. why do you want to change the encoding? cheers stefan > > Regards, Herbert > > > > > -- > View this message in context: > http://www.nabble.com/Generation-of-Jackrabbit-tables-in-MySQL-tp24968945p24968945.html > Sent from the Jackrabbit - Users mailing list archive at Nabble.com. > >
