The size is much lower for MySQL keys. MySQL (as I've been told) can
only have 1000 bytes in a primary key. The harder part is with UTF-8
MySQL uses 3 bytes per character which means we would have to
significantly reduce the column widths in the table to only fit about
333 characters total.
C
While we're on the subject, I was curious if it might be useful to apply a
primary key definition to the UP_PERMISSION table? I see that there is an
index defined (UPPERM_IDX), but didn't know if there was a good reason for not
defining a primary key. The only condition I can think of is if so
ounce-6917425-15797...@lists.wisc.edu] On Behalf Of Conan Cook
Sent: 10 March 2009 12:09
To: uportal-dev@lists.ja-sig.org
Subject: [uportal-dev] SQLServer & uPortal 3.1 RC1 Tables.xml
Dear uPortal Developers,
I've successfully installed uPortal 3.1 RC1 using MySQL and HSQL, but
when I tr
01173 281 053
-Original Message-
From: bounce-6917425-15797...@lists.wisc.edu
[mailto:bounce-6917425-15797...@lists.wisc.edu] On Behalf Of Conan Cook
Sent: 10 March 2009 12:09
To: uportal-dev@lists.ja-sig.org
Subject: [uportal-dev] SQLServer & uPortal 3.1 RC1 Tables.xml
Dear uPortal D
Dear uPortal Developers,
I've successfully installed uPortal 3.1 RC1 using MySQL and HSQL, but
when I tried to run the initdb ANT target against an SQL Server
database, it failed complaining that primary keys cannot be created on
nullable columns (SQL Server can't handle primary keys being set to
