[Building Sakai] Something about the characterset of datab ase

[Adrian Fish]

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"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130419/ec9673e1/attachment.html