jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stefan Guggisberg <stefan.guggisb...@gmail.com>
Subject Re: Generation of Jackrabbit-tables in MySQL
Date Fri, 14 Aug 2009 09:52:18 GMT
hi herbert

On Fri, Aug 14, 2009 at 11:35 AM, herbert<iops@gmx.de> 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?


> 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.

View raw message