Index: lams_build/common.properties
===================================================================
diff -u -re9cb7b12d4dd30b802753c2a7386f5acf997c710 -r3f19251c66a87e5a33e782bee769b7e7992791fd
--- lams_build/common.properties	(.../common.properties)	(revision e9cb7b12d4dd30b802753c2a7386f5acf997c710)
+++ lams_build/common.properties	(.../common.properties)	(revision 3f19251c66a87e5a33e782bee769b7e7992791fd)
@@ -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
===================================================================
diff -u -rbc368754d760a33f55a1c3ba1d899cf8be3953fb -r3f19251c66a87e5a33e782bee769b7e7992791fd
--- lams_common/build.xml	(.../build.xml)	(revision bc368754d760a33f55a1c3ba1d899cf8be3953fb)
+++ lams_common/build.xml	(.../build.xml)	(revision 3f19251c66a87e5a33e782bee769b7e7992791fd)
@@ -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
===================================================================
diff -u -r91ed9bfb8010c507db28282afea81a48df8f7d92 -r3f19251c66a87e5a33e782bee769b7e7992791fd
--- lams_tool_chat/build.xml	(.../build.xml)	(revision 91ed9bfb8010c507db28282afea81a48df8f7d92)
+++ lams_tool_chat/build.xml	(.../build.xml)	(revision 3f19251c66a87e5a33e782bee769b7e7992791fd)
@@ -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
===================================================================
diff -u -r71a37d456ee2d1d277774c125ac645ef7f06fa00 -r3f19251c66a87e5a33e782bee769b7e7992791fd
--- lams_tool_forum/build.xml	(.../build.xml)	(revision 71a37d456ee2d1d277774c125ac645ef7f06fa00)
+++ lams_tool_forum/build.xml	(.../build.xml)	(revision 3f19251c66a87e5a33e782bee769b7e7992791fd)
@@ -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
===================================================================
diff -u -re48a67de27af42221ddce80419f05c1be4680430 -r3f19251c66a87e5a33e782bee769b7e7992791fd
--- lams_tool_lamc/build.xml	(.../build.xml)	(revision e48a67de27af42221ddce80419f05c1be4680430)
+++ lams_tool_lamc/build.xml	(.../build.xml)	(revision 3f19251c66a87e5a33e782bee769b7e7992791fd)
@@ -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
===================================================================
diff -u -re48a67de27af42221ddce80419f05c1be4680430 -r3f19251c66a87e5a33e782bee769b7e7992791fd
--- lams_tool_laqa/build.xml	(.../build.xml)	(revision e48a67de27af42221ddce80419f05c1be4680430)
+++ lams_tool_laqa/build.xml	(.../build.xml)	(revision 3f19251c66a87e5a33e782bee769b7e7992791fd)
@@ -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
===================================================================
diff -u -r477b19dd83e2be0e1b3b2493fb4cdbe68a5cddc1 -r3f19251c66a87e5a33e782bee769b7e7992791fd
--- lams_tool_larsrc/build.xml	(.../build.xml)	(revision 477b19dd83e2be0e1b3b2493fb4cdbe68a5cddc1)
+++ lams_tool_larsrc/build.xml	(.../build.xml)	(revision 3f19251c66a87e5a33e782bee769b7e7992791fd)
@@ -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
===================================================================
diff -u -re263e51e8e1faf1463ea508f5432bcde98a88652 -r3f19251c66a87e5a33e782bee769b7e7992791fd
--- lams_tool_nb/build.xml	(.../build.xml)	(revision e263e51e8e1faf1463ea508f5432bcde98a88652)
+++ lams_tool_nb/build.xml	(.../build.xml)	(revision 3f19251c66a87e5a33e782bee769b7e7992791fd)
@@ -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
===================================================================
diff -u -r5948e17402e1ad574aeddbe55f93dca2f58bbbec -r3f19251c66a87e5a33e782bee769b7e7992791fd
--- lams_tool_notebook/build.xml	(.../build.xml)	(revision 5948e17402e1ad574aeddbe55f93dca2f58bbbec)
+++ lams_tool_notebook/build.xml	(.../build.xml)	(revision 3f19251c66a87e5a33e782bee769b7e7992791fd)
@@ -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
===================================================================
diff -u -r4166df6f6aeb3bf252c4365751108e34b5481f67 -r3f19251c66a87e5a33e782bee769b7e7992791fd
--- lams_tool_sbmt/build.xml	(.../build.xml)	(revision 4166df6f6aeb3bf252c4365751108e34b5481f67)
+++ lams_tool_sbmt/build.xml	(.../build.xml)	(revision 3f19251c66a87e5a33e782bee769b7e7992791fd)
@@ -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
===================================================================
diff -u -re48a67de27af42221ddce80419f05c1be4680430 -r3f19251c66a87e5a33e782bee769b7e7992791fd
--- lams_tool_vote/build.xml	(.../build.xml)	(revision e48a67de27af42221ddce80419f05c1be4680430)
+++ lams_tool_vote/build.xml	(.../build.xml)	(revision 3f19251c66a87e5a33e782bee769b7e7992791fd)
@@ -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>