[Building Sakai] Something about the characterset of datab ase

[zmk]

Maybe installing a new database is the best way for me now.Thanks to all of you! 

Best wishes,
ManKun,Zhao


---------- Origin message ----------
>From："David Adams" <da1 at vt.edu>
>To："Matthew Jones" <matthew at longsight.com>
>Subject：Re: [Building Sakai] Something about the characterset of datab ase
>Date：2013-04-19 23:30:22

I'll just throw in with everyone here that MySQL works better for Sakai
than Oracle, since the majority of institutions and pretty much all the
developers use MySQL. Adding new database support would be a nightmare
unless and until the core data layer services are overhauled and services
requiring outlandish SQL queries (Authz) are reworked. There are far better
ways to manage a database schema over time, as well--not sure about exact
options in the Java world, but look at the database management in Django
and Rails, or the serious approach that software like Mediawiki takes
towards this problem, and Sakai looks pretty sad in comparison.

Once we start cleaning up our act around schema management and centralizing
the database services away from the tools themselves, then it might be
worth the time to look at supporting alternative RDBMSes, but at this
point, it'd just be a neverending distraction.

David Adams
Director, Systems Integration and Support
Virginia Tech Learning Technologies


On Fri, Apr 19, 2013 at 8:11 AM, Matthew Jones <matthew at longsight.com>wrote:

> You can run Sakai on MariaDB (https://mariadb.org/) and not be dependent
> on Oracle. I even think that Rutgers is doing that in production.
>
>
> http://collab.sakaiproject.org/pipermail/production/2013-January/001962.html
>
> Postgres would for sure be nice but Just looking at the effort in trying
> to get DB2 to work (75 jiras if you search for it) which was still
> incomplete and eventually completely removed.
>
>
> On Fri, Apr 19, 2013 at 9:00 AM, Adrian Fish <adrian.r.fish at gmail.com>wrote:
>
>> Seizing an opportunity, I'd like to add that being dependent on Oracle
>> for all of our supported databases makes me nervous.
>>
>> We could really do with supporting Postgresql.
>>
>> Cheers,
>> Adrian.
>>
>>
>> On 19 April 2013 13:35, Kaufmann,Melody-Ann J <safire at ufl.edu> wrote:
>>
>>> Zmk,****
>>>
>>> ** **
>>>
>>> From my limited experience with Oracle the only method to change the
>>> characterset of the database is to reinstall the Oracle DB. The character
>>> set is chosen in your download and installation process.****
>>>
>>> ** **
>>>
>>> If you have other systems relying on the same DB that you have Sakai on
>>> then I would say consider separating it. Take a dump from your current
>>> Sakai tablespace and then use that to build a separate Oracle DB or MySQL
>>> database for Sakai. Obviously if you switch to MySQL it may take a few
>>> extra steps to get the information from the Oracle dump into the new
>>> database but it is still easier than re-writing the portions of code
>>> necessary to avoid using UTF8.****
>>>
>>> ** **
>>>
>>> Just my two cents****
>>>
>>> MJ****
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> *From:* sakai-dev-bounces at collab.sakaiproject.org [mailto:
>>> sakai-dev-bounces at collab.sakaiproject.org] *On Behalf Of *Matthew Jones
>>> *Sent:* Thursday, April 18, 2013 9:28 AM
>>> *To:* John Bush
>>> *Cc:* sakai-dev; zmk
>>> *Subject:* Re: [Building Sakai] Something about the characterset of
>>> datab ase****
>>>
>>> ** **
>>>
>>> I'm not sure you'll get a lot of (any) answers on this list.****
>>>
>>> ** **
>>>
>>> 1) The majority of installations for Sakai are MySQL****
>>>
>>> 2) The ones few that are Oracle are UTF-8 from the start so haven't had
>>> this issue****
>>>
>>> ** **
>>>
>>> If it were me I'd also just figure out how to convert it to MySQL and
>>> use that, if it was impossible to use a different type in Oracle. Otherwise
>>> it seems like you'd be basically writing new special code for many parts of
>>> Sakai to handle this.****
>>>
>>> ** **
>>>
>>> On Thu, Apr 18, 2013 at 3:53 AM, John Bush <john.bush at rsmart.com> wrote:
>>> ****
>>>
>>> You could choose to use mysql.
>>>
>>> Sorry, I've had a few really bad Oracle days as of late, couldn't help
>>> myself.****
>>>
>>>
>>> On Wed, Apr 17, 2013 at 6:45 PM, zmk <zmk at tju.edu.cn> wrote:
>>> > Thank you very much. But the problem is that we use a common oracle
>>> database for many different systems,the change of characterset will affect
>>> other systems. So what can I do if I have no choice to use other
>>> characterset?
>>> > _______________________________________________
>>> > sakai-dev mailing list
>>> > sakai-dev at collab.sakaiproject.org
>>> > http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>> >
>>> > TO UNSUBSCRIBE: send email to
>>> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
>>> "unsubscribe"
>>>
>>>
>>> ****
>>>
>>> --
>>> John Bush
>>> 602-490-0470****
>>>
>>> _______________________________________________
>>> sakai-dev mailing list
>>> sakai-dev at collab.sakaiproject.org
>>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>>
>>> TO UNSUBSCRIBE: send email to
>>> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
>>> "unsubscribe"****
>>>
>>> ** **
>>>
>>> _______________________________________________
>>> sakai-dev mailing list
>>> sakai-dev at collab.sakaiproject.org
>>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>>
>>> TO UNSUBSCRIBE: send email to
>>> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
>>> "unsubscribe"
>>>
>>
>>
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130419/71abdcf0/attachment.html