You have to tell mysql that you want to store the data as unicode. I have attached a draft of the scheme! I have no idea if it work since my 4.1 installation has some personal issues with me.
/jacob ----- Original Message ----- From: "Oliver Zeigermann" <[EMAIL PROTECTED]> To: "Slide Users Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, April 21, 2004 9:12 AM Subject: Re: Slide and multiple languange?? > I had 4.1 running and tested it with the MySql store and it worked. I > have no idea if the UTF-8 thing works. Maybe a change in scheme is needed? > > Oliver > > 陶 京瑞 wrote: > > thx for your email. then do you know how to solve the problem in mySQL? > > > > > >> From: "Jacob Lund" <[EMAIL PROTECTED]> > >> Reply-To: "Slide Users Mailing List" <[EMAIL PROTECTED]> > >> To: "Slide Users Mailing List" <[EMAIL PROTECTED]> > >> Subject: Re: Slide and multiple languange?? > >> Date: Tue, 20 Apr 2004 13:03:11 +0200 > >> > >> MySql 4.0 does not support UTF-8! Mysql 4.1 should, but it is still in > > > > alpha > > > >> and I have not succeeded in getting it to work yet! > >> > >> /jacob > >> > >> ----- Original Message ----- > >> From: "陶 京瑞" <[EMAIL PROTECTED]> > >> To: <[EMAIL PROTECTED]> > >> Sent: Tuesday, April 20, 2004 12:32 PM > >> Subject: Re: Slide and multiple languange?? > >> > >> > >> > I thought the problem maybe lie in mySql, since if I use the same > > > > chinese > > > >> > name to download the file in Slide, it success although the file is > > > > shown > > > >> > as ???.txt. I check the file name in mySql, the file show the same as > >> > ???.txt. But I still don't know how can I solve the problem. > >> > > >> > > >> > >From: "Jacob Lund" <[EMAIL PROTECTED]> > >> > >Reply-To: "Slide Users Mailing List" <[EMAIL PROTECTED]> > >> > >To: "Slide Users Mailing List" <[EMAIL PROTECTED]> > >> > >Subject: Re: Slide and multiple languange?? > >> > >Date: Tue, 20 Apr 2004 11:55:31 +0200 > >> > > > >> > >I don't know anything about jboss! But when I used TC 4.1 i had to use > >> the > >> > >coyoteconnector and apply useURIValidationHack="false" in order to get > >> > UTF-8 > >> > >working properly. > >> > > > >> > >/jacob > >> > > > >> > >----- Original Message ----- > >> > >From: "陶 京瑞" <[EMAIL PROTECTED]> > >> > >To: <[EMAIL PROTECTED]> > >> > >Sent: Tuesday, April 20, 2004 11:43 AM > >> > >Subject: Re: Slide and multiple languange?? > >> > > > >> > > > >> > > > thanks for your reply. > >> > > > > >> > > > I use slide 2RC1 with Jboss3.0.8+tomcat4.1.24. which seems tomcat's > >> > > > server.xml doesnot work when I start the Jboss+tomcat, I have found > >> > that > >> > > > org.apache.slide.urlEncoding=UTF-8 had been set in slide.properties > >> > file. > >> > > > > >> > > > I have follow your words as following: > >> > > > > >> > > > <contentstore > >> > > > classname="org.apache.slide.store.txfile.TxFileContentStore"> > >> > > > <parameter name="rootpath">slide/fileContent</parameter> > >> > > > <parameter name="workpath">slide/workContent</parameter> > >> > > > <parameter name="version">true</parameter> > >> > > > <parameter name="url-encode-path">true</parameter> > >> > > > </contentstore> > >> > > > > >> > > > However, when I successfully upload a file in slide, and use > >> > > > propfindMehtod, the file name still display as ???.txt. the > > > > properties > > > >> > > > shown as following(see <D:href> and <D:displayname>): > >> > > > > >> > > > ------------------------------------------------ > >> > > > > >> > > > <D:response xmlns:D="DAV:"> > >> > > >> > > > > >> > > >> > >> <D:href>/slide/files/testtomcat%C3%A4%C2%B8%C2%AD%C3%A6%C2%96%C2%87.test</D > >> > > > > > >> : > >> > > >> > >href> > >> > > >> > > > <D:propstat> > >> > > >> > > > <D:prop> > >> > > >> > > > <D:displayname>testtomcat??????.test</D:displayname> > >> > > >> > > > <D:source></D:source> > >> > > >> > > > <D:getlastmodified>Tue, 20 Apr 2004 09:32:20 > >> > > > GMT</D:getlastmodified> > >> > > >> > > > <D:getcontentlength>852</D:getcontentlength> > >> > > >> > > > <D:resourcetype></D:resourcetype> > >> > > >> > > > <D:getcontenttype>application/octet-stream</D:getcontenttype> > >> > > >> > > > > >> > > > <D:getcontentlanguage>en</D:getcontentlanguage> > >> > > >> > > > <D:creationdate>2004-04-20T09:17:21Z</D:creationdate> > >> > > >> > > > <D:lockdiscovery></D:lockdiscovery> > >> > > >> > > > <D:supportedlock> > >> > > >> > > > <D:lockentry> > >> > > >> > > > <D:lockscope> > >> > > >> > > > <D:exclusive></D:exclusive> > >> > > >> > > > </D:lockscope> > >> > > >> > > > <D:locktype> > >> > > >> > > > <D:write></D:write> > >> > > >> > > > </D:locktype> > >> > > >> > > > </D:lockentry> > >> > > >> > > > <D:lockentry> > >> > > >> > > > <D:lockscope> > >> > > >> > > > <D:shared></D:shared> > >> > > >> > > > </D:lockscope> > >> > > >> > > > <D:locktype> > >> > > >> > > > <D:write></D:write> > >> > > >> > > > </D:locktype> > >> > > >> > > > </D:lockentry> > >> > > >> > > > </D:supportedlock> > >> > > >> > > > <D:modificationdate>2004-04-20T09:32:20Z</D:modificationdate> > >> > > >> > > > > >> > > > <D:getetag>791b7c7bddf9ae4259e6c8d2a7ad0f1a</D:getetag> > >> > > >> > > > </D:prop> > >> > > >> > > > <D:status>HTTP/1.1 200 OK</D:status> > >> > > >> > > > </D:propstat> > >> > > >> > > > </D:response> > >> > > > > >> > > > >From: "Jacob Lund" <[EMAIL PROTECTED]> > >> > > > >Reply-To: "Slide Users Mailing List" > > > > <[EMAIL PROTECTED]> > > > >> > > > >To: "Slide Users Mailing List" <[EMAIL PROTECTED]> > >> > > > >Subject: Re: Slide and multiple languange?? > >> > > > >Date: Tue, 20 Apr 2004 11:11:24 +0200 > >> > > > > > >> > > > >what version of slide are you using and what servlet engine are > > > > you > > > >> > >using? > >> > > > > > >> > > > >I have slide 2RC1 working fine with utf-8 encoding on a tomcat 5. > >> Here > >> > is > >> > > > >what I did to make it work: > >> > > > >In slide: > >> > > > >Add a parameter url-encode-path in the tx content and descriptors > >> > store > >> > > > and > >> > > > >set it to true. (in domain.xml) > >> > > > >In tomcat 5: > >> > > > >add URIEncoding="UTF-8" as parameter to the connector in > > > > server.xml. > > > >> > > > > > >> > > > >I have not tested it with Chinese but it works with Russian and > >> Danish > >> > on > >> > > > an > >> > > > >English machine. > >> > > > > > >> > > > >Just notice that this requires your client to support UTF-8 > > > > encoding. > > > >> > > > > > >> > > > >/jacob > >> > > > > > >> > > > >----- Original Message ----- > >> > > > >From: "陶 京瑞" <[EMAIL PROTECTED]> > >> > > > >To: <[EMAIL PROTECTED]> > >> > > > >Sent: Tuesday, April 20, 2004 10:48 AM > >> > > > >Subject: Slide and multiple languange?? > >> > > > > > >> > > > > > >> > > > > > hi, > >> > > > > > > >> > > > > > does the Slide support Chinese? if so how to? > >> > > > > > > >> > > > > > I have put a file onto the slide, when I use propfindmethod to > >> > display > >> > > > the > >> > > > > > file name, the file with Chinese name is shown as ???.txt. I > > > > think > > > >> > >some > >> > > > >one > >> > > > > > may also face such multiple language problem, but how to deal > > > > with > > > >> > it? > >> > > > > > > >> > > > > > Thanks for any help. > >> > > > > > > >> > > > > > > > > > _________________________________________________________________ > > > >> > > > > > 与联机的朋友进行交流，请使用 MSN Messenger: > >> > > > http://messenger.msn.com/cn > >> > > > > > > >> > > > > > > >> > > > > > > >> > --------------------------------------------------------------------- > >> > > > > > To unsubscribe, e-mail: > > > > [EMAIL PROTECTED] > > > >> > > > > > For additional commands, e-mail: > >> [EMAIL PROTECTED] > >> > > > > > > >> > > > > > >> > > > > > >> > > > > >> --------------------------------------------------------------------- > >> > > > >To unsubscribe, e-mail: [EMAIL PROTECTED] > >> > > > >For additional commands, e-mail: > > > > [EMAIL PROTECTED] > > > >> > > > > > >> > > > > >> > > > _________________________________________________________________ > >> > > > 免费下载 MSN Explorer: http://explorer.msn.com/lccn > >> > > > > >> > > > > >> > > > > > > > --------------------------------------------------------------------- > > > >> > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > >> > > > For additional commands, e-mail: [EMAIL PROTECTED] > >> > > > > >> > > > >> > > > >> > >--------------------------------------------------------------------- > >> > >To unsubscribe, e-mail: [EMAIL PROTECTED] > >> > >For additional commands, e-mail: [EMAIL PROTECTED] > >> > > > >> > > >> > _________________________________________________________________ > >> > 享用世界上最大的电子邮件系统― MSN Hotmail。 http://www.hotmail.com > >> > > >> > > >> > --------------------------------------------------------------------- > >> > To unsubscribe, e-mail: [EMAIL PROTECTED] > >> > For additional commands, e-mail: [EMAIL PROTECTED] > >> > > >> > >> > >> --------------------------------------------------------------------- > >> To unsubscribe, e-mail: [EMAIL PROTECTED] > >> For additional commands, e-mail: [EMAIL PROTECTED] > >> > > > > _________________________________________________________________ > > 与联机的朋友进行交流，请使用 MSN Messenger: http://messenger.msn.com/cn > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > . > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] >
# -------------------------------------------------------- drop table if exists OBJECT; drop table if exists CHILDREN; drop table if exists BINDING; drop table if exists PARENT_BINDING; drop table if exists LINKS; drop table if exists LOCKS; drop table if exists VERSION_CONTENT; drop table if exists PROPERTIES; drop table if exists PERMISSIONS; drop table if exists VERSION_PREDS; drop table if exists VERSION_LABELS; drop table if exists VERSION_HISTORY; drop table if exists VERSION; drop table if exists BRANCH; drop table if exists LABEL; drop table if exists URI; # -------------------------------------------------------- CREATE TABLE URI ( URI_ID bigint NOT NULL auto_increment, URI_STRING varchar(255) NOT NULL CHARACTER SET uft8 COLLATE utf8_general_ci, PRIMARY KEY (URI_ID), KEY URI_IX2 (URI_STRING) ) TYPE=InnoDB CHARACTER SET utf8; # -------------------------------------------------------- CREATE TABLE OBJECT ( URI_ID bigint NOT NULL, CLASS_NAME varchar(255) NOT NULL CHARACTER SET utf8 COLLATE utf8_general_ci, PRIMARY KEY (URI_ID) ) TYPE=InnoDB CHARACTER SET utf8; ALTER TABLE OBJECT ADD CONSTRAINT OBJECT_FK1 FOREIGN KEY OBJECT_FK1(URI_ID) REFERENCES URI (URI_ID); # -------------------------------------------------------- CREATE TABLE BINDING ( URI_ID bigint NOT NULL, NAME varchar(255) NOT NULL CHARACTER SET utf8 COLLATE utf8_general_ci, CHILD_UURI_ID bigint NOT NULL, PRIMARY KEY (URI_ID, NAME, CHILD_UURI_ID), KEY BINDING_IX (CHILD_UURI_ID) ) TYPE=InnoDB CHARACTER SET utf8; ALTER TABLE BINDING ADD CONSTRAINT BINDING_FK1 FOREIGN KEY BINDING_FK1(URI_ID) REFERENCES URI (URI_ID); ALTER TABLE BINDING ADD CONSTRAINT BINDING_FK2 FOREIGN KEY BINDING_FK2(CHILD_UURI_ID) REFERENCES URI (URI_ID); CREATE TABLE PARENT_BINDING ( URI_ID bigint NOT NULL, NAME varchar(255) NOT NULL CHARACTER SET utf8 COLLATE utf8_general_ci, PARENT_UURI_ID bigint NOT NULL, PRIMARY KEY (URI_ID, NAME, PARENT_UURI_ID), KEY PARENT_BINDING_IX (PARENT_UURI_ID) ) TYPE=InnoDB CHARACTER SET utf8; ALTER TABLE PARENT_BINDING ADD CONSTRAINT PARENT_BINDING_FK1 FOREIGN KEY PARENT_BINDING_FK1(URI_ID) REFERENCES URI (URI_ID); ALTER TABLE PARENT_BINDING ADD CONSTRAINT PARENT_BINDING_FK2 FOREIGN KEY PARENT_BINDING_FK2(PARENT_UURI_ID) REFERENCES URI (URI_ID); # -------------------------------------------------------- CREATE TABLE LINKS ( URI_ID bigint NOT NULL, LINK_TO_ID bigint NOT NULL, PRIMARY KEY (URI_ID,LINK_TO_ID), key LINK_IX2 (LINK_TO_ID) ) TYPE=InnoDB CHARACTER SET utf8; ALTER TABLE LINKS ADD CONSTRAINT LINK_FK1 FOREIGN KEY LINK_FK1(URI_ID) REFERENCES URI (URI_ID); ALTER TABLE LINKS ADD CONSTRAINT LINK_FK2 FOREIGN KEY LINK_FK2(LINK_TO_ID) REFERENCES URI (URI_ID); # -------------------------------------------------------- CREATE TABLE LOCKS ( LOCK_ID bigint NOT NULL, OBJECT_ID bigint NOT NULL, SUBJECT_ID bigint NOT NULL, TYPE_ID bigint NOT NULL, EXPIRATION_DATE bigint NOT NULL, IS_INHERITABLE tinyint(1) NOT NULL, IS_EXCLUSIVE tinyint(1) NOT NULL, OWNER varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci, PRIMARY KEY (LOCK_ID), KEY LOCK_IX2 (OBJECT_ID), KEY LOCK_IX3 (SUBJECT_ID), KEY LOCK_IX4 (TYPE_ID) ) TYPE=InnoDB CHARACTER SET utf8; ALTER TABLE LOCKS ADD CONSTRAINT LOCK_FK1 FOREIGN KEY LOCK_FK1(LOCK_ID) REFERENCES URI (URI_ID); ALTER TABLE LOCKS ADD CONSTRAINT LOCK_FK2 FOREIGN KEY LOCK_FK2(OBJECT_ID) REFERENCES URI (URI_ID); ALTER TABLE LOCKS ADD CONSTRAINT LOCK_FK3 FOREIGN KEY LOCK_FK3(SUBJECT_ID) REFERENCES URI (URI_ID); ALTER TABLE LOCKS ADD CONSTRAINT LOCK_FK4 FOREIGN KEY LOCK_FK4(TYPE_ID) REFERENCES URI (URI_ID); # -------------------------------------------------------- CREATE TABLE BRANCH ( BRANCH_ID bigint NOT NULL auto_increment, BRANCH_STRING varchar(255) NOT NULL CHARACTER SET utf8 COLLATE utf8_general_ci, PRIMARY KEY (BRANCH_ID) ) TYPE=InnoDB CHARACTER SET utf8; # -------------------------------------------------------- CREATE TABLE LABEL ( LABEL_ID bigint NOT NULL auto_increment, LABEL_STRING varchar(255) NOT NULL CHARACTER SET utf8 COLLATE utf8_general_ci, PRIMARY KEY (LABEL_ID) ) TYPE=InnoDB CHARACTER SET utf8; # -------------------------------------------------------- CREATE TABLE VERSION ( URI_ID bigint NOT NULL, IS_VERSIONED tinyint(1) NOT NULL, PRIMARY KEY (URI_ID) ) TYPE=InnoDB CHARACTER SET utf8; ALTER TABLE VERSION ADD CONSTRAINT REVISON_FK1 FOREIGN KEY VERSION_FK1(URI_ID) REFERENCES URI (URI_ID); # -------------------------------------------------------- CREATE TABLE VERSION_HISTORY ( VERSION_ID bigint NOT NULL auto_increment, URI_ID bigint NOT NULL, BRANCH_ID bigint NOT NULL, REVISION_NO varchar(20) NOT NULL CHARACTER SET utf8 COLLATE utf8_general_ci, PRIMARY KEY (VERSION_ID), UNIQUE KEY URI_ID (BRANCH_ID,URI_ID,REVISION_NO), KEY URI_ID_IX3 (URI_ID) ) TYPE=InnoDB CHARACTER SET utf8; ALTER TABLE VERSION_HISTORY ADD CONSTRAINT VERSION_HISTORY_FK1 FOREIGN KEY VERSION_HISTORY_FK1(URI_ID) REFERENCES URI (URI_ID); ALTER TABLE VERSION_HISTORY ADD CONSTRAINT VERSION_HISTORY_FK2 FOREIGN KEY VERSION_HISTORY_FK2(BRANCH_ID) REFERENCES BRANCH (BRANCH_ID); # -------------------------------------------------------- CREATE TABLE VERSION_PREDS ( VERSION_ID bigint NOT NULL, PREDECESSOR_ID bigint NOT NULL, PRIMARY KEY (VERSION_ID,PREDECESSOR_ID), KEY PREDECESSOR_ID_IX2 (PREDECESSOR_ID) ) TYPE=InnoDB CHARACTER SET utf8; ALTER TABLE VERSION_PREDS ADD CONSTRAINT REVISON_PREDS_FK1 FOREIGN KEY VERSION_PREDS_FK1(VERSION_ID) REFERENCES VERSION_HISTORY (VERSION_ID); ALTER TABLE VERSION_PREDS ADD CONSTRAINT REVISON_PREDS_FK2 FOREIGN KEY VERSION_PREDS_FK2(PREDECESSOR_ID) REFERENCES VERSION_HISTORY (VERSION_ID); # -------------------------------------------------------- CREATE TABLE VERSION_LABELS ( VERSION_ID bigint NOT NULL, LABEL_ID bigint NOT NULL, PRIMARY KEY (VERSION_ID,LABEL_ID), KEY LABEL_ID_IX2 (LABEL_ID) ) TYPE=InnoDB CHARACTER SET utf8; ALTER TABLE VERSION_LABELS ADD CONSTRAINT REVISON_LABELS_FK1 FOREIGN KEY VERSION_LABELS_FK1(VERSION_ID) REFERENCES VERSION_HISTORY (VERSION_ID); ALTER TABLE VERSION_LABELS ADD CONSTRAINT REVISON_LABELS_FK2 FOREIGN KEY VERSION_LABELS_FK2(LABEL_ID) REFERENCES LABEL (LABEL_ID); # -------------------------------------------------------- CREATE TABLE VERSION_CONTENT ( VERSION_ID bigint NOT NULL, CONTENT blob NOT NULL, PRIMARY KEY (VERSION_ID) ) TYPE=InnoDB CHARACTER SET utf8; ALTER TABLE VERSION_CONTENT ADD CONSTRAINT REVISON_CONTENT_FK1 FOREIGN KEY VERSION_CONTENT_FK1(VERSION_ID) REFERENCES VERSION_HISTORY (VERSION_ID); # -------------------------------------------------------- CREATE TABLE PROPERTIES ( VERSION_ID bigint NOT NULL, PROPERTY_NAMESPACE varchar(50) NOT NULL CHARACTER SET utf8 COLLATE utf8_general_ci, PROPERTY_NAME varchar(50) NOT NULL CHARACTER SET utf8 COLLATE utf8_general_ci, PROPERTY_VALUE varchar(255) NOT NULL CHARACTER SET utf8 COLLATE utf8_general_ci, PROPERTY_TYPE varchar(50) NOT NULL CHARACTER SET utf8 COLLATE utf8_general_ci, IS_PROTECTED tinyint(1) NOT NULL, PRIMARY KEY (VERSION_ID,PROPERTY_NAMESPACE,PROPERTY_NAME) ) TYPE=InnoDB CHARACTER SET utf8; ALTER TABLE PROPERTIES ADD CONSTRAINT PROPERTIES_FK1 FOREIGN KEY PROPERTIES_FK1(VERSION_ID) REFERENCES VERSION_HISTORY (VERSION_ID); # -------------------------------------------------------- CREATE TABLE PERMISSIONS ( OBJECT_ID bigint NOT NULL, SUBJECT_ID bigint NOT NULL, ACTION_ID bigint NOT NULL, VERSION_NO varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci, IS_INHERITABLE tinyint(1) NOT NULL, IS_NEGATIVE tinyint(1) NOT NULL, SUCCESSION int NOT NULL, PRIMARY KEY (SUBJECT_ID,OBJECT_ID,ACTION_ID), UNIQUE KEY OBJECT_ID_2 (OBJECT_ID,SUCCESSION), KEY ACTION_ID_IX3 (ACTION_ID) ) TYPE=InnoDB CHARACTER SET utf8; ALTER TABLE PERMISSIONS ADD CONSTRAINT PERMISSIONS_FK1 FOREIGN KEY PERMISSIONS_FK1(OBJECT_ID) REFERENCES URI (URI_ID); ALTER TABLE PERMISSIONS ADD CONSTRAINT PERMISSIONS_FK2 FOREIGN KEY PERMISSIONS_FK2(SUBJECT_ID) REFERENCES URI (URI_ID); ALTER TABLE PERMISSIONS ADD CONSTRAINT PERMISSIONS_FK3 FOREIGN KEY PERMISSIONS_FK3(ACTION_ID) REFERENCES URI (URI_ID);
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
