[Building Sakai] Something about the characterset of datab ase

[Kaufmann,Melody-Ann J]

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<mailto: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<mailto: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<mailto: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<mailto:sakai-dev-unsubscribe at collab.sakaiproject.org> with a subject of "unsubscribe"


--
John Bush
602-490-0470<tel:602-490-0470>
_______________________________________________
sakai-dev mailing list
sakai-dev at collab.sakaiproject.org<mailto: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<mailto: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/2aaca9e6/attachment.html