Index: lams_build/common.properties
===================================================================
RCS file: /usr/local/cvsroot/lams_build/common.properties,v
diff -u -r1.14 -r1.15
--- lams_build/common.properties	10 Jul 2006 07:13:56 -0000	1.14
+++ lams_build/common.properties	14 Aug 2006 11:39:30 -0000	1.15
@@ -38,7 +38,8 @@
 #database access
 db.name=lams
 db.driver=com.mysql.jdbc.Driver
-db.url=jdbc:mysql://localhost/${db.name}?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&autoReconnect=true
+db.url=jdbc:mysql://localhost/${db.name}?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&autoReconnect=true&useUnicode=true
+db.encoding=utf8
 db.username=lams
 db.password=lamsdemo
 db.driver.jar=${sharedlib}/mysql/mysql-connector-java-3.1.12-bin.jar
Index: lams_common/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_common/build.xml,v
diff -u -r1.48 -r1.49
--- lams_common/build.xml	10 Aug 2006 00:41:58 -0000	1.48
+++ lams_common/build.xml	14 Aug 2006 11:47:15 -0000	1.49
@@ -265,33 +265,21 @@
 	<target name="rebuild-db"
 		description="rebuild LAMS database and clean out content repository. Mysql has to be running first">
 		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
-				password="${db.password}">
+				password="${db.password}" encoding="${db.encoding}">
 			<classpath>
 				<pathelement location="${db.driver.jar}"/>
 			</classpath>
 			<transaction src="${db.scripts}/create_lams_11_db.sql"/>
 			<transaction src="${db.scripts}/drop_lams_11_tables.sql"/>
 			<transaction src="${db.scripts}/create_lams_11_tables.sql"/>
 			<transaction src="${db.scripts}/insert_types_data.sql"/>
-			<transaction src="${db.scripts}/insert_users.sql"/>
+			<transaction src="${db.scripts}/insert_users.sql"/> 
 			<!-- Create Quartz table --> 
 	    	<transaction src="${db.scripts}/create_quartz_table.sql"/>
 			<!-- Create tables for Core Notebook Service -->
 			<transaction src="${db.scripts}/create_notebook_tables.sql"/>
-			<!-- Test the scripts for shaun 
-            <transaction src="${db.scripts}/shaun/lams_user_swedish.sql"/>
-            <transaction src="${db.scripts}/shaun/lams_user_french.sql"/>
-            <transaction src="${db.scripts}/shaun/lams_user_bulgarian.sql"/>
-            <transaction src="${db.scripts}/shaun/lams_user_chinese.sql"/>
-            <transaction src="${db.scripts}/shaun/lams_user_german.sql"/>
-            <transaction src="${db.scripts}/shaun/lams_user_norwegian.sql"/>
-            <transaction src="${db.scripts}/shaun/lams_user_portbr.sql"/>
-            <transaction src="${db.scripts}/shaun/lams_user_italian.sql"/>
-            <transaction src="${db.scripts}/shaun/lams_user_polish.sql"/>
-            <transaction src="${db.scripts}/shaun/lams_user_korean.sql"/>
-            <transaction src="${db.scripts}/shaun/lams_user_spanish.sql"/>
-            <transaction src="${db.scripts}/shaun/lams_user_maori.sql"/>
-            <transaction src="${db.scripts}/shaun/lams_user_hungarian.sql"/>
+			<!-- Test the scripts for translations
+            <transaction src="${db.scripts}/shaun/all.sql"/>
             -->
 		</sql>
 		
@@ -304,7 +292,7 @@
 	<target name="insert-test-data" depends="rebuild-db"
 		description="insert test data to lams database">
 		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
-				password="${db.password}">
+				password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
 				<pathelement location="${db.driver.jar}"/>
 			</classpath>
Index: lams_tool_chat/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_chat/build.xml,v
diff -u -r1.10 -r1.11
--- lams_tool_chat/build.xml	6 Jul 2006 05:00:22 -0000	1.10
+++ lams_tool_chat/build.xml	14 Aug 2006 11:42:46 -0000	1.11
@@ -130,7 +130,7 @@
 	<!-- Database Tasks                                             -->
 	<!-- =================================================================== -->
 	<target name="clean-db" description="Deletes the Tool Tables">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}" password="${db.password}">
+		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}" password="${db.password}" encoding="${db.encoding}">
 			<classpath>
 				<pathelement location="${db.driver.jar}" />
 			</classpath>
@@ -139,7 +139,7 @@
 	</target>
 
 	<target name="build-db" depends="" description="Deletes and Creates the Tool tables and inserts default content">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}" password="${db.password}">
+		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}" password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
 				<pathelement location="${db.driver.jar}" />
 			</classpath>
Index: lams_tool_forum/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_forum/build.xml,v
diff -u -r1.40 -r1.41
--- lams_tool_forum/build.xml	8 Jun 2006 07:37:34 -0000	1.40
+++ lams_tool_forum/build.xml	14 Aug 2006 11:44:36 -0000	1.41
@@ -150,7 +150,7 @@
 	<!-- =================================================================== -->
 	<target name="clean-db"	description="clean forum database.">
 		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
-				password="${db.password}">
+				password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
 				<pathelement location="${db.driver.jar}"/>
 			</classpath>
@@ -160,7 +160,7 @@
 	
 	<target name="init-db"	description="drop and create forum database.">
 		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
-				password="${db.password}">
+				password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
 				<pathelement location="${db.driver.jar}"/>
 			</classpath>
@@ -172,7 +172,7 @@
 	<target name="build-db"	depends="init-db" 
 							description="build qa tool database.">
 		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
-				password="${db.password}">
+				password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
 				<pathelement location="${db.driver.name}"/>
 			</classpath>
Index: lams_tool_lamc/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_lamc/build.xml,v
diff -u -r1.27 -r1.28
--- lams_tool_lamc/build.xml	29 Jun 2006 00:44:45 -0000	1.27
+++ lams_tool_lamc/build.xml	14 Aug 2006 11:44:52 -0000	1.28
@@ -279,7 +279,7 @@
 		<target name="rebuild-db"
 			description="rebuild MCQ tables">
 			<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
-					password="${db.password}">
+					password="${db.password}"  encoding="${db.encoding}">
 				<classpath>
 					<pathelement location="${db.driver.jar}"/>
 				</classpath>
@@ -295,7 +295,7 @@
 		<target name="clean-tool-db"
 			description="rebuild Mc tables">
 			<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
-					password="${db.password}">
+					password="${db.password}"  encoding="${db.encoding}">
 				<classpath>
 					<pathelement location="${db.driver.jar}"/>
 				</classpath>
Index: lams_tool_laqa/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_laqa/build.xml,v
diff -u -r1.29 -r1.30
--- lams_tool_laqa/build.xml	29 Jun 2006 00:41:25 -0000	1.29
+++ lams_tool_laqa/build.xml	14 Aug 2006 11:45:07 -0000	1.30
@@ -278,7 +278,7 @@
 		<target name="rebuild-db"
 			description="rebuild QA tables">
 			<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
-					password="${db.password}">
+					password="${db.password}"  encoding="${db.encoding}">
 				<classpath>
 					<pathelement location="${db.driver.jar}"/>
 				</classpath>
@@ -294,7 +294,7 @@
 		<target name="clean-tool-db"
 			description="rebuild qa tables">
 			<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
-					password="${db.password}">
+					password="${db.password}"  encoding="${db.encoding}">
 				<classpath>
 					<pathelement location="${db.driver.jar}"/>
 				</classpath>
Index: lams_tool_larsrc/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_larsrc/build.xml,v
diff -u -r1.10 -r1.11
--- lams_tool_larsrc/build.xml	14 Apr 2006 06:19:40 -0000	1.10
+++ lams_tool_larsrc/build.xml	14 Aug 2006 11:45:25 -0000	1.11
@@ -153,7 +153,7 @@
 	<!-- =================================================================== -->
 	<target name="clean-db"	description="clean share resources database.">
 		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
-				password="${db.password}">
+				password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
 				<pathelement location="${db.driver.jar}"/>
 			</classpath>
@@ -163,7 +163,7 @@
 	
 	<target name="init-db"	description="drop and create forum database.">
 		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
-				password="${db.password}">
+				password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
 				<pathelement location="${db.driver.jar}"/>
 			</classpath>
@@ -175,7 +175,7 @@
 	<target name="build-db"	depends="init-db" 
 							description="build qa tool database.">
 		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
-				password="${db.password}">
+				password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
 				<pathelement location="${db.driver.name}"/>
 			</classpath>
Index: lams_tool_nb/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_nb/build.xml,v
diff -u -r1.27 -r1.28
--- lams_tool_nb/build.xml	14 Apr 2006 10:05:36 -0000	1.27
+++ lams_tool_nb/build.xml	14 Aug 2006 11:45:51 -0000	1.28
@@ -129,7 +129,7 @@
 	<!-- =================================================================== -->
 		<target name="clean-db"	description="Deletes the Noticeboard Tool Tables">
 			<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
-					password="${db.password}">
+					password="${db.password}"  encoding="${db.encoding}">
 				<classpath>
 					<pathelement location="${db.driver.jar}"/>
 				</classpath>
@@ -139,7 +139,7 @@
 		
 		<target name="build-db" depends="" description="Deletes and Creates the Noticeboard Tool tables and inserts default content">
 			<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
-								password="${db.password}">
+								password="${db.password}"  encoding="${db.encoding}">
 							<classpath>
 								<pathelement location="${db.driver.jar}"/>
 							</classpath>
@@ -149,7 +149,7 @@
 	
 	<!--	<target name="insert-test-data" depends="build-db" description="Inserts test data for noticeboard tool in order for test cases to run">
 				<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
-									password="${db.password}">
+									password="${db.password}"  encoding="${db.encoding}">
 								<classpath>
 									<pathelement location="${db.driver.jar}"/>
 								</classpath>
@@ -167,7 +167,7 @@
 			        </filterset>
 			    </copy>
 				<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
-					password="${db.password}">
+					password="${db.password}"  encoding="${db.encoding}">
 				<classpath>
 					<pathelement location="${db.driver.jar}"/>
 				</classpath>
Index: lams_tool_notebook/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_notebook/build.xml,v
diff -u -r1.1 -r1.2
--- lams_tool_notebook/build.xml	20 Jul 2006 01:11:09 -0000	1.1
+++ lams_tool_notebook/build.xml	14 Aug 2006 11:45:55 -0000	1.2
@@ -130,7 +130,7 @@
 	<!-- Database Tasks                                             -->
 	<!-- =================================================================== -->
 	<target name="clean-db" description="Deletes the Tool Tables">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}" password="${db.password}">
+		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}" password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
 				<pathelement location="${db.driver.jar}" />
 			</classpath>
@@ -139,7 +139,7 @@
 	</target>
 
 	<target name="build-db" depends="" description="Deletes and Creates the Tool tables and inserts default content">
-		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}" password="${db.password}">
+		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}" password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
 				<pathelement location="${db.driver.jar}" />
 			</classpath>
Index: lams_tool_sbmt/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_sbmt/build.xml,v
diff -u -r1.32 -r1.33
--- lams_tool_sbmt/build.xml	12 May 2006 06:34:09 -0000	1.32
+++ lams_tool_sbmt/build.xml	14 Aug 2006 11:45:54 -0000	1.33
@@ -294,7 +294,7 @@
 		<target name="rebuild-db"
 			description="rebuild Submit Files tables">
 			<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
-					password="${db.password}">
+					password="${db.password}"  encoding="${db.encoding}">
 				<classpath>
 					<pathelement location="${db.driver.jar}"/>
 				</classpath>
@@ -309,7 +309,7 @@
 	<target name="insert-test-data" depends="rebuild-db"
 		description="Insert some dummy test data. Removes any data that was in the tables first.">
 		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
-				password="${db.password}">
+				password="${db.password}"  encoding="${db.encoding}">
 			<classpath>
 				<pathelement location="${db.driver.jar}"/>
 			</classpath>
Index: lams_tool_vote/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_vote/build.xml,v
diff -u -r1.5 -r1.6
--- lams_tool_vote/build.xml	29 Jun 2006 00:38:11 -0000	1.5
+++ lams_tool_vote/build.xml	14 Aug 2006 11:45:52 -0000	1.6
@@ -298,7 +298,7 @@
 		<target name="rebuild-db"
 			description="rebuild Voting tables">
 			<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
-					password="${db.password}">
+					password="${db.password}"  encoding="${db.encoding}">
 				<classpath>
 					<pathelement location="${db.driver.jar}"/>
 				</classpath>
@@ -314,7 +314,7 @@
 		<target name="clean-tool-db"
 			description="rebuild Voting tables">
 			<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
-					password="${db.password}">
+					password="${db.password}"  encoding="${db.encoding}">
 				<classpath>
 					<pathelement location="${db.driver.jar}"/>
 				</classpath>