may I then take over the scheme into Slide, maybe called MySqlScheme4_1.sql or so?
Oliver
Jacob Lund wrote:
According to mysql.com it is a new feature in 4.1!
/jacob
----- Original Message ----- From: "Oliver Zeigermann" <[EMAIL PROTECTED]>
To: "Slide Users Mailing List" <[EMAIL PROTECTED]>
Sent: Wednesday, April 21, 2004 9:32 AM
Subject: Re: Slide and multiple languange??
Does 4.0 understand or at least tolerate this "CHARACTER SET uft8 COLLATE utf8_general_ci" thing? If so we might change the default
scheme...
Oliver
Jacob Lund wrote:
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?
<D:href>/slide/files/testtomcat%C3%A4%C2%B8%C2%AD%C3%A6%C2%96%C2%87.test</DOliver
? ?? 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:modificationdate>2004-04-20T09:32:20Z</D:modificationdate>:
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: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]
--------------------------------------------------------------------- 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]
.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]