You are viewing a plain text version of this content. The canonical link for it is here.
Posted to slide-user@jakarta.apache.org by Jacob Lund <jl...@qualiware.net> on 2005/05/02 09:02:18 UTC
Re: Non us-ascii character in filenames break. Was: French accent, getting crazy....
I cannot help this - are you sure that you client is using utf8?
I am Danish, and I can store filenames using special Danish letters. I have
also tested with Russian letter in filenames, and it is working fine!
What you describe sound to me like you client is sending non utf8 encoded
data to slide, and that will mess up files it the way you describe! Your
problems are the same as when I tested with windows 2000 and webfolders.
Windows 2000 only worked when I installed office xp with latest servicepack
or office 2003. Windows XP seem to be working fine.
DAVExplorer will corrupt filenames if your slide is set to utf8.
If you put a sniffer on you system and monitor the data transmitted between
client and server, then try following. Upload a file called é.bat and the
header send from the client should look something like this:
PUT /files/%c3%a9.bat HTTP/1.1
Host: localhost:82
That is: the utf8 escaped version of é is %c3%a9. And the unexcaped utf8
version of é would be: é. This is correct behavior.
/jacob
----- Original Message -----
From: "delbd" <de...@oma.be>
To: "Slide Users Mailing List" <sl...@jakarta.apache.org>
Sent: Friday, April 29, 2005 3:19 PM
Subject: Non us-ascii character in filenames break. Was: French accent,
getting crazy....
Submitted a detailed bug report of problem. I hope the slide devels will fix
this fast!
http://issues.apache.org/bugzilla/show_bug.cgi?id=34679
Le Vendredi 29 Avril 2005 12:55, Alexandre Clavaud a écrit :
> Thanks, that will be great.
>
> I have to projects:
> 1. For a customer, using Slide as Document Management repository,
> accessing
> from WebFolder and from Java applications.
>
> 2. For Compiere, an Open Source ERP, using Slide as Document Management
> repository full integrated in the application, with Document and Folder
> types, metadata, workflow, ... If ok, will be part of the core product.
>
> Regards
>
> Alexandre
>
> > Hooow shit!
> > Tried here. Indeed slide mess with the accents when sending it's result
> > to the client. I created a file with accents. Platform encoding is
> > utf-8,
> > slide encoding is utf-8, client is the kde webdav protocol working
> > nicely
> > with accent on other webdav implementations. However, result of a
> > propfind (sniffed with ethereal) send by slide server is like if string
> > was converted to an utf-8 byte array and then converted back to string
> > as
> > an iso8859-1 byte array. (This is the typical round copyright sign
> > followed by another char which we all see when a browser tries to open
> > an
> > utf-8 page as an iso8859 one). This look like it's done before server
> > put
> > it in the propfind result dom. Problem being it's the server doing the
> > messup before url encoding. For information, not only the href is wrong
> > but also the displayname. Clients bear no responsability in problem.
> >
> >
> > I also took a look in database, as we store document on an oracle
> > database, the uri and the displayname are all ok. So seems like it's the
> > servlet on output which mess something. I'll do some step by step
> > analysis and keep you informed if i can find a way around this.
> >
> > Note to slide-dev, this is a real problem big problem as the document
> > becomes unmanageable!
> >
> > Le Vendredi 29 Avril 2005 11:35, Alexandre Clavaud a écrit :
> >> Then, rather than using utf8, should I use ISO8859-1 ?
> >>
> >>> I have slide 2.1 working with utf8. But you should notice that
> >>> windows 2000
> >>> with office 97 and DAVExplorer does not support utf8.
> >>>
> >>> Have a look at:
> >>> http://greenbytes.de/tech/webdav/webfolder-client-list.html
> >>>
> >>>
> >>>
> >>> /jacob
> >>>
> >>>
> >>>
> >>> ----- Original Message -----
> >>> From: "Alexandre Clavaud" <Al...@ilem.ch>
> >>> To: <sl...@jakarta.apache.org>
> >>> Sent: Friday, April 29, 2005 8:48 AM
> >>> Subject: French accent, getting crazy....
> >>>
> >>>> Hello,
> >>>>
> >>>>
> >>>>
> >>>> Does someone managed to make slide (2.1 or more) working with
> >>>> french accent ? using Oracle store (Oracle 10g) ? using File store
> >>>> (linux) ?
> >>>> using Bea Weblogic (v8.1 on linux) ?
> >>>>
> >>>>
> >>>> from DAV Explorer ? from Webfolder on windows 2000 with Office 97 ?
> >>>>
> >>>>
> >>>> I tried differents combinaison of utf8 and iso8859-1 in
> >>>> slide.properties but I still get error when getting the file or when
> >>>> browsing the content of a folder (the file is displayed with '_'
> >>>> instead of accentued characters).
> >>>>
> >>>> I really need help, I'm getting crazy and I've got a big project on
> >>>> which I want to use slide.
> >>>>
> >>>> ----------------------------------------------------
> >>>> Alexandre Clavaud
> >>>> Consultant Technique
> >>>> ILEM S.A
> >>>>
> >>>>
> >>>>
> >>>> Tel: +41 79 773 6888
> >>>> Email : Alexandre.Clavaud@ilem.ch
> >>>> ---------------------------------------------------
> >>>>
> >>>>
> >>>>
> >>>>
> >>>> -------------------------------------------------------------------
> >>>> --
> >>>> To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> >>>> For additional commands, e-mail: slide-user-help@jakarta.apache.org
> >>>
> >>> ---------------------------------------------------------------------
> >>> To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> >>> For additional commands, e-mail: slide-user-help@jakarta.apache.org
> >>
> >> ----------------------------------------------------
> >> Alexandre Clavaud
> >> Consultant Technique
> >> ILEM S.A
> >>
> >>
> >> Tel: +41 79 773 6888
> >> Email : Alexandre.Clavaud@ilem.ch
> >> ---------------------------------------------------
> >>
> >>
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> >> For additional commands, e-mail: slide-user-help@jakarta.apache.org
> >
> > --
> > David Delbecq
> > Royal Meteorological Institute of Belgium
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: slide-user-help@jakarta.apache.org
>
> ----------------------------------------------------
> Alexandre Clavaud
> Consultant Technique
> ILEM S.A
>
> Tel: +41 79 773 6888
> Email : Alexandre.Clavaud@ilem.ch
> ---------------------------------------------------
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: slide-user-help@jakarta.apache.org
--
David Delbecq
Royal Meteorological Institute of Belgium
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org
Re: Non us-ascii character in filenames break. Was: French accent, getting crazy....
Posted by delbd <de...@oma.be>.
I just tried here. It did this:
---------
delbd@CAL-12:~$ telnet localhost 8080
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
PUT /intranet/DAV/files/d0_public/AT%C3%A9%C3%A8st.txt HTTP/1.1
Host: localhost:8080
Cookie: JSESSIONID=8189025AFC93A7C96A797041AA042D01
Authorization: Basic ***hidden ;)***
HTTP/1.1 201 Created
Server: Apache-Coyote/1.1
Pragma: No-cache
Cache-Control: no-cache
Expires: Thu, 01 Jan 1970 01:00:00 CET
ETag: e4f2657596656c1e468fcd473c84cf41
Content-Length: 0
Date: Mon, 02 May 2005 12:09:01 GMT
--------
This should urldecode to/intranet/DAV/files/d0_public/ATéèst.txt and create an
empty document with that url.
I get this in the tomcat console:
http-8080-Processor24, 02-May-2005 14:18:30, admin, PUT, 201 "Created", 744
ms, /files/d0_public/AT????st.txt
Then i do a propfind (PROPFIND /intranet/DAV/files/d0_public/ HTTP/1.1) using
my webdav client, i get this href for the document i just created
(information obtained by sniffing):
<D:response xmlns:D="DAV:">
<D:href>/intranet/DAV/files/d0_public/AT%C3%83%C2%A9%C3%83%C2%A8st.txt</D:href>
<D:propstat>
<D:prop>
Then i click on the document to edit, here is the request my client sends:
HEAD /intranet/DAV/files/d0_public/AT%C3%83%C2%A9%C3%83%C2%A8st.txt HTTP/1.1
to which slide respond 404
Then client issue a
GET /intranet/DAV/files/d0_public/AT%C3%83%C2%A9%C3%83%C2%A8st.txt HTTP/1.1
to which slide respond by a 404 too
In console i get this:
http-8080-Processor25, 02-May-2005 14:21:33, admin, HEAD, 404 "Not Found", 57
ms, /files/d0_public/AT????????st.txt
http-8080-Processor24, 02-May-2005 14:21:33, admin, GET, 404 "Not Found", 46
ms, /files/d0_public/AT????????st.txt
Looking at the database, in the URI table, i see
this: /files/d0_public/ATéèst.txt
Please note that when i use my webdav client to create the file, it does not
use the same url encoding(only one %HH for a é and one %HH for a è). In that
encoding slide interprets it correctly at the PUT and the accents are ok in
database, but result of propfind->href is still unusable as input for a get
or proppatch.
Also, slide.properties contains this:
org.apache.slide.urlEncoding=UTF-8
--
tested with oracle database,
webdav not the default servlet (important as it appear in code the urldecoding
process is different if not default servlet)
slide 2.1
jakarta-tomcat-5.5.7
--
Here is output configuration from slide:
02 May 2005 14:17:08 - org.apache.slide.common.Domain - INFO - Domain
configuration : {org.apache.slide.versioncontrol=true,
org.apache.slide.debug=false, org.apache.slide.search=false,
org.apache.slide.security=true, org.apache.slide.urlEncoding=UTF-8,
org.apache.slide.domain=bin/Domain.xml}
--
David Delbecq
Royal Meteorological Institute of Belgium
Le Lundi 2 Mai 2005 13:20, Jacob Lund a écrit :
> I just uploaded a file with that exact name: téèst.txt to my slide version
> 2.1.
>
> I tried with both windows explorer webfolder and with my own client - it
> worked fine.
>
> Are you testing with the txfilestore? BTW utf8 is broken in 2.2 so you
> should stay with 2.1 for now.
>
> Also you are showing here - could you verify that the put request from your
> client is also encoding utf8!
>
> My problem is that it works fine in my case - for both filestore and for
> the SQLServer store. This makes me conclude that it is a setup issue or and
> oracle store problem. Or am I missing something?
>
> /jacob
>
> ----- Original Message -----
> From: "delbd" <de...@oma.be>
> To: "Slide Users Mailing List" <sl...@jakarta.apache.org>
> Sent: Monday, May 02, 2005 10:57 AM
> Subject: Re: Non us-ascii character in filenames break. Was: French accent,
> getting crazy....
>
>
> The put went without a problem. The data is encoded correctly on the
> database.
> It's an Oracle database and the accents are corrects in it. On propfind,
> slide sends a list of documents with an encoded href. This is the href the
> client should be sending back to slide when it tries any operation on
> document. As detailed in bug report, slide is unable to decode the href it
> has send, this has nothing to do with the client IMO.
>
> For example, a document
> /files/d0_public/téèst.txt
> gets a href in the result of propfind in d0_public like this:
> <D:response xmlns:D="DAV:">
> <D:href>/intranet/DAV/files/d0_public/t%C3%A9%C3%A8st.txt</D:href>
> <D:propstat>
> <D:prop>
> ...blablabla
> however, a GET on this url returns an object not found.
> Problem arise wether slide is configured with utf-8 or another charset. I
> also
> set java.io.encoding to UTF-8 to set the default String encoding to utf-8
> (just to be sure).
>
> See transcript:
>
> delbd@CAL-12:~$ telnet localhost 8080
> Trying 127.0.0.1...
> Connected to localhost.
> Escape character is '^]'.
> GET /intranet/DAV/files/d0_public/t%C3%A9%C3%A8st.txt HTTP/1.1
> Host: localhost:8080
>
> HTTP/1.1 404 Not Found: No object found
> at /files/d0_public/t%C3%A9%C3%A8st.txt
> Server: Apache-Coyote/1.1
> Set-Cookie: JSESSIONID=5C06606B1A4C0A5DC6629178C9009704; Path=/intranet
> Content-Type: text/html;charset=utf-8
> Content-Length: 1148
> Date: Mon, 02 May 2005 08:50:53 GMT
>
> <html><head><title>Apache Tomcat/5.5.7 - Error report</title><style><!--H1
> {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;f
>ont-size:22px;} H2
> {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;f
>ont-size:16px;} H3
> {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;f
>ont-size:14px;} BODY
> {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B
> {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;}
> P
> {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size
>:12px;}A {color : black;}A.name {color : black;}HR {color :
> #525D76;}--></style> </head><body><h1>HTTP Status 404 - Not Found: No
> object found
> at /files/d0_public/t%C3%A9%C3%A8st.txt</h1><HR size="1"
> noshade="noshade"><p><b>type</b> Status report</p><p><b>message</b> <u>Not
> Found: No objectfound
> at /files/d0_public/t%C3%A9%C3%A8st.txt</u></p><p><b>description</b> <u>The
> requested resource (Not Found: No object found
> at /files/d0_public/t%C3%A9%C3%A8st.txt) is not available.</u></p><HR
> size="1" noshade="noshade"><h3>Apache
> Tomcat/5.5.7</h3></body></html>Connection closed by foreign host.
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org
Re: Non us-ascii character in filenames break. Was: French accent, getting crazy....
Posted by delbd <de...@oma.be>.
Well if oracle was to not support unicode currently i wonder how we could
store french character an lots of other strange character thingie. It indeed
does store them without problem. Sure this is not utf-8, but the oracle jdbc
driver does the convertion from java String to native encoding (and this
natvie encoding does support character such as 'é'.
Look what i wrote in other mail, i did a put with your suggested utf-8
encoding, and slide decoded each %HH to a char before storing in database!
I'll check to switch all varchar2 to nvarchar2, but i doubt this will solve
problem, imho, the problem is at uri decode time.
Le Lundi 2 Mai 2005 14:56, Jacob Lund a écrit :
> A very quick browsing through google makes me believe that oracle only
> stores unicode if you use nvarchar2 and nclob etc. Even if database is set
> to utf8 in oracle db. Or am I way off?
>
> Could you try to make a search&replace: from VARCHAR2 to NVARCHAR2 and from
> CLOB to NCLOB in the oracle scheme? And then create the database again?
>
> /jacob
>
>
> ----- Original Message -----
> From: "delbd" <de...@oma.be>
> To: "Slide Users Mailing List" <sl...@jakarta.apache.org>
> Sent: Monday, May 02, 2005 2:27 PM
> Subject: Re: Non us-ascii character in filenames break. Was: French accent,
> getting crazy....
>
>
> Yes oracle database here is configured to use a unicode character set as
> the default charset for all text fields.
>
> Le Lundi 2 Mai 2005 13:26, Jacob Lund a écrit :
> > I just noticed something - is the sql scheme for oracle using Unicode?
> >
> > In order to make SQLServer support utf8 I had to change varchar to
> > nvarchar - otherwise it would react in a way similar to what you
> > describe.
> >
> > If you create a file on you desktop and cut&past some Russian characters
> > into the filename and the upload the file to slide, the it will fail
> > unless
> > the database supports unicode.
> >
> > /jacob
> >
> > ----- Original Message -----
> > From: "Jacob Lund" <jl...@qualiware.net>
> > To: "Slide Users Mailing List" <sl...@jakarta.apache.org>
> > Sent: Monday, May 02, 2005 1:20 PM
> > Subject: Re: Non us-ascii character in filenames break. Was: French
> > accent,
> > getting crazy....
> >
> > >I just uploaded a file with that exact name: téèst.txt to my slide
> > >version
> > >2.1.
> > >
> > > I tried with both windows explorer webfolder and with my own client -
> > > it worked fine.
> > >
> > > Are you testing with the txfilestore? BTW utf8 is broken in 2.2 so you
> > > should stay with 2.1 for now.
> > >
> > > Also you are showing here - could you verify that the put request from
> > > your client is also encoding utf8!
> > >
> > > My problem is that it works fine in my case - for both filestore and
> > > for the SQLServer store. This makes me conclude that it is a setup
> > > issue or and oracle store problem. Or am I missing something?
> > >
> > > /jacob
> > >
> > > ----- Original Message -----
> > > From: "delbd" <de...@oma.be>
> > > To: "Slide Users Mailing List" <sl...@jakarta.apache.org>
> > > Sent: Monday, May 02, 2005 10:57 AM
> > > Subject: Re: Non us-ascii character in filenames break. Was: French
> > > accent, getting crazy....
> > >
> > >
> > > The put went without a problem. The data is encoded correctly on the
> > > database.
> > > It's an Oracle database and the accents are corrects in it. On
> > > propfind, slide sends a list of documents with an encoded href. This is
> > > the href the client should be sending back to slide when it tries any
> > > operation on
> > > document. As detailed in bug report, slide is unable to decode the href
> > > it has send, this has nothing to do with the client IMO.
> > >
> > > For example, a document
> > > /files/d0_public/téèst.txt
> > > gets a href in the result of propfind in d0_public like this:
> > > <D:response xmlns:D="DAV:">
> > > <D:href>/intranet/DAV/files/d0_public/t%C3%A9%C3%A8st.txt</D:href>
> > > <D:propstat>
> > > <D:prop>
> > > ...blablabla
> > > however, a GET on this url returns an object not found.
> > > Problem arise wether slide is configured with utf-8 or another charset.
> > > I
> > > also
> > > set java.io.encoding to UTF-8 to set the default String encoding to
> > > utf-8
> > > (just to be sure).
> > >
> > > See transcript:
> > >
> > > delbd@CAL-12:~$ telnet localhost 8080
> > > Trying 127.0.0.1...
> > > Connected to localhost.
> > > Escape character is '^]'.
> > > GET /intranet/DAV/files/d0_public/t%C3%A9%C3%A8st.txt HTTP/1.1
> > > Host: localhost:8080
> > >
> > > HTTP/1.1 404 Not Found: No object found
> > > at /files/d0_public/t%C3%A9%C3%A8st.txt
> > > Server: Apache-Coyote/1.1
> > > Set-Cookie: JSESSIONID=5C06606B1A4C0A5DC6629178C9009704; Path=/intranet
> > > Content-Type: text/html;charset=utf-8
> > > Content-Length: 1148
> > > Date: Mon, 02 May 2005 08:50:53 GMT
> > >
> > > <html><head><title>Apache Tomcat/5.5.7 - Error
> > > report</title><style><!--H1
> > > {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D
> > >76 ;font-size:22px;} H2
> > > {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D
> > >76 ;font-size:16px;} H3
> > > {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D
> > >76 ;font-size:14px;} BODY
> > > {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white
> > >;} B
> > > {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D
> > >76 ;} P
> > > {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-
> > >si ze:12px;}A {color : black;}A.name {color : black;}HR {color :
> > > #525D76;}--></style> </head><body><h1>HTTP Status 404 - Not Found: No
> > > object found
> > > at /files/d0_public/t%C3%A9%C3%A8st.txt</h1><HR size="1"
> > > noshade="noshade"><p><b>type</b> Status report</p><p><b>message</b>
> > > <u>Not Found: No objectfound
> > > at /files/d0_public/t%C3%A9%C3%A8st.txt</u></p><p><b>description</b>
> > > <u>The
> > > requested resource (Not Found: No object found
> > > at /files/d0_public/t%C3%A9%C3%A8st.txt) is not available.</u></p><HR
> > > size="1" noshade="noshade"><h3>Apache
> > > Tomcat/5.5.7</h3></body></html>Connection closed by foreign host.
> > >
> > > --
> > > David Delbecq
> > > Royal Meteorological Institute of Belgium
> > >
> > > Le Lundi 2 Mai 2005 09:02, Jacob Lund a écrit :
> > >> I cannot help this - are you sure that you client is using utf8?
> > >>
> > >> I am Danish, and I can store filenames using special Danish letters. I
> > >> have
> > >> also tested with Russian letter in filenames, and it is working fine!
> > >>
> > >> What you describe sound to me like you client is sending non utf8
> > >> encoded data to slide, and that will mess up files it the way you
> > >> describe! Your problems are the same as when I tested with windows
> > >> 2000 and webfolders. Windows 2000 only worked when I installed office
> > >> xp with
> > >> latest servicepack
> > >> or office 2003. Windows XP seem to be working fine.
> > >>
> > >> DAVExplorer will corrupt filenames if your slide is set to utf8.
> > >>
> > >> If you put a sniffer on you system and monitor the data transmitted
> > >> between
> > >> client and server, then try following. Upload a file called é.bat and
> > >> the header send from the client should look something like this:
> > >>
> > >> PUT /files/%c3%a9.bat HTTP/1.1
> > >> Host: localhost:82
> > >>
> > >> That is: the utf8 escaped version of é is %c3%a9. And the unexcaped
> > >> utf8
> > >> version of é would be: é. This is correct behavior.
> > >>
> > >> /jacob
> > >>
> > >>
> > >> ----- Original Message -----
> > >> From: "delbd" <de...@oma.be>
> > >> To: "Slide Users Mailing List" <sl...@jakarta.apache.org>
> > >> Sent: Friday, April 29, 2005 3:19 PM
> > >> Subject: Non us-ascii character in filenames break. Was: French
> > >> accent, getting crazy....
> > >>
> > >>
> > >> Submitted a detailed bug report of problem. I hope the slide devels
> > >> will
> > >> fix this fast!
> > >> http://issues.apache.org/bugzilla/show_bug.cgi?id=34679
> > >>
> > >> Le Vendredi 29 Avril 2005 12:55, Alexandre Clavaud a écrit :
> > >> > Thanks, that will be great.
> > >> >
> > >> > I have to projects:
> > >> > 1. For a customer, using Slide as Document Management repository,
> > >> > accessing
> > >> > from WebFolder and from Java applications.
> > >> >
> > >> > 2. For Compiere, an Open Source ERP, using Slide as Document
> > >> > Management repository full integrated in the application, with
> > >> > Document and Folder types, metadata, workflow, ... If ok, will be
> > >> > part
> > >> > of the core product.
> > >> >
> > >> > Regards
> > >> >
> > >> > Alexandre
> > >> >
> > >> > > Hooow shit!
> > >> > > Tried here. Indeed slide mess with the accents when sending it's
> > >> > > result
> > >> > > to the client. I created a file with accents. Platform encoding is
> > >> > > utf-8,
> > >> > > slide encoding is utf-8, client is the kde webdav protocol working
> > >> > > nicely
> > >> > > with accent on other webdav implementations. However, result of a
> > >> > > propfind (sniffed with ethereal) send by slide server is like if
> > >> > > string
> > >> > > was converted to an utf-8 byte array and then converted back to
> > >> > > string
> > >> > > as
> > >> > > an iso8859-1 byte array. (This is the typical round copyright sign
> > >> > > followed by another char which we all see when a browser tries to
> > >> > > open
> > >> > > an
> > >> > > utf-8 page as an iso8859 one). This look like it's done before
> > >> > > server put
> > >> > > it in the propfind result dom. Problem being it's the server doing
> > >> > > the
> > >> > > messup before url encoding. For information, not only the href is
> > >> > > wrong
> > >> > > but also the displayname. Clients bear no responsability in
> > >> > > problem.
> > >> > >
> > >> > >
> > >> > > I also took a look in database, as we store document on an oracle
> > >> > > database, the uri and the displayname are all ok. So seems like
> > >> > > it's
> > >> > > the servlet on output which mess something. I'll do some step by
> > >> > > step analysis and keep you informed if i can find a way around
> > >> > > this.
> > >> > >
> > >> > > Note to slide-dev, this is a real problem big problem as the
> > >> > > document becomes unmanageable!
> > >> > >
> > >> > > Le Vendredi 29 Avril 2005 11:35, Alexandre Clavaud a écrit :
> > >> > >> Then, rather than using utf8, should I use ISO8859-1 ?
> > >> > >>
> > >> > >>> I have slide 2.1 working with utf8. But you should notice that
> > >> > >>> windows 2000
> > >> > >>> with office 97 and DAVExplorer does not support utf8.
> > >> > >>>
> > >> > >>> Have a look at:
> > >> > >>> http://greenbytes.de/tech/webdav/webfolder-client-list.html
> > >> > >>>
> > >> > >>>
> > >> > >>>
> > >> > >>> /jacob
> > >> > >>>
> > >> > >>>
> > >> > >>>
> > >> > >>> ----- Original Message -----
> > >> > >>> From: "Alexandre Clavaud" <Al...@ilem.ch>
> > >> > >>> To: <sl...@jakarta.apache.org>
> > >> > >>> Sent: Friday, April 29, 2005 8:48 AM
> > >> > >>> Subject: French accent, getting crazy....
> > >> > >>>
> > >> > >>>> Hello,
> > >> > >>>>
> > >> > >>>>
> > >> > >>>>
> > >> > >>>> Does someone managed to make slide (2.1 or more) working with
> > >> > >>>> french accent ? using Oracle store (Oracle 10g) ? using File
> > >> > >>>> store (linux) ?
> > >> > >>>> using Bea Weblogic (v8.1 on linux) ?
> > >> > >>>>
> > >> > >>>>
> > >> > >>>> from DAV Explorer ? from Webfolder on windows 2000 with Office
> > >> > >>>> 97
> > >> > >>>> ?
> > >> > >>>>
> > >> > >>>>
> > >> > >>>> I tried differents combinaison of utf8 and iso8859-1 in
> > >> > >>>> slide.properties but I still get error when getting the file or
> > >> > >>>> when
> > >> > >>>> browsing the content of a folder (the file is displayed with
> > >> > >>>> '_'
> > >> > >>>> instead of accentued characters).
> > >> > >>>>
> > >> > >>>> I really need help, I'm getting crazy and I've got a big
> > >> > >>>> project on
> > >> > >>>> which I want to use slide.
> > >> > >>>>
> > >> > >>>> ----------------------------------------------------
> > >> > >>>> Alexandre Clavaud
> > >> > >>>> Consultant Technique
> > >> > >>>> ILEM S.A
> > >> > >>>>
> > >> > >>>>
> > >> > >>>>
> > >> > >>>> Tel: +41 79 773 6888
> > >> > >>>> Email : Alexandre.Clavaud@ilem.ch
> > >> > >>>> ---------------------------------------------------
> > >> > >>>>
> > >> > >>>>
> > >> > >>>>
> > >> > >>>>
> > >> > >>>> ---------------------------------------------------------------
> > >> > >>>>-- -- --
> > >> > >>>> To unsubscribe, e-mail:
> > >> > >>>> slide-user-unsubscribe@jakarta.apache.org
> > >> > >>>> For additional commands, e-mail:
> > >> > >>>> slide-user-help@jakarta.apache.org
> > >> > >>>
> > >> > >>> ----------------------------------------------------------------
> > >> > >>>-- --- To unsubscribe, e-mail:
> > >> > >>> slide-user-unsubscribe@jakarta.apache.org For additional
> > >> > >>> commands,
> > >> > >>> e-mail: slide-user-help@jakarta.apache.org
> > >> > >>
> > >> > >> ----------------------------------------------------
> > >> > >> Alexandre Clavaud
> > >> > >> Consultant Technique
> > >> > >> ILEM S.A
> > >> > >>
> > >> > >>
> > >> > >> Tel: +41 79 773 6888
> > >> > >> Email : Alexandre.Clavaud@ilem.ch
> > >> > >> ---------------------------------------------------
> > >> > >>
> > >> > >>
> > >> > >>
> > >> > >> -----------------------------------------------------------------
> > >> > >>-- -- To unsubscribe, e-mail:
> > >> > >>slide-user-unsubscribe@jakarta.apache.org
> > >> > >> For additional commands, e-mail:
> > >> > >> slide-user-help@jakarta.apache.org
> > >> > >
> > >> > > --
> > >> > > David Delbecq
> > >> > > Royal Meteorological Institute of Belgium
> > >> > >
> > >> > >
> > >> > > ------------------------------------------------------------------
> > >> > >-- - To unsubscribe, e-mail:
> > >> > > slide-user-unsubscribe@jakarta.apache.org For additional commands,
> > >> > > e-mail: slide-user-help@jakarta.apache.org
> > >> >
> > >> > ----------------------------------------------------
> > >> > Alexandre Clavaud
> > >> > Consultant Technique
> > >> > ILEM S.A
> > >> >
> > >> > Tel: +41 79 773 6888
> > >> > Email : Alexandre.Clavaud@ilem.ch
> > >> > ---------------------------------------------------
> > >> >
> > >> >
> > >> > --------------------------------------------------------------------
> > >> >- To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> > >> > For additional commands, e-mail: slide-user-help@jakarta.apache.org
> > >
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> > > For additional commands, e-mail: slide-user-help@jakarta.apache.org
> > >
> > >
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> > > For additional commands, e-mail: slide-user-help@jakarta.apache.org
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: slide-user-help@jakarta.apache.org
--
David Delbecq
Royal Meteorological Institute of Belgium
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org
Re: Non us-ascii character in filenames break. Was: French accent, getting crazy....
Posted by Jacob Lund <jl...@qualiware.net>.
A very quick browsing through google makes me believe that oracle only
stores unicode if you use nvarchar2 and nclob etc. Even if database is set
to utf8 in oracle db. Or am I way off?
Could you try to make a search&replace: from VARCHAR2 to NVARCHAR2 and from
CLOB to NCLOB in the oracle scheme? And then create the database again?
/jacob
----- Original Message -----
From: "delbd" <de...@oma.be>
To: "Slide Users Mailing List" <sl...@jakarta.apache.org>
Sent: Monday, May 02, 2005 2:27 PM
Subject: Re: Non us-ascii character in filenames break. Was: French accent,
getting crazy....
Yes oracle database here is configured to use a unicode character set as the
default charset for all text fields.
Le Lundi 2 Mai 2005 13:26, Jacob Lund a écrit :
> I just noticed something - is the sql scheme for oracle using Unicode?
>
> In order to make SQLServer support utf8 I had to change varchar to
> nvarchar - otherwise it would react in a way similar to what you describe.
>
> If you create a file on you desktop and cut&past some Russian characters
> into the filename and the upload the file to slide, the it will fail
> unless
> the database supports unicode.
>
> /jacob
>
> ----- Original Message -----
> From: "Jacob Lund" <jl...@qualiware.net>
> To: "Slide Users Mailing List" <sl...@jakarta.apache.org>
> Sent: Monday, May 02, 2005 1:20 PM
> Subject: Re: Non us-ascii character in filenames break. Was: French
> accent,
> getting crazy....
>
> >I just uploaded a file with that exact name: téèst.txt to my slide
> >version
> >2.1.
> >
> > I tried with both windows explorer webfolder and with my own client - it
> > worked fine.
> >
> > Are you testing with the txfilestore? BTW utf8 is broken in 2.2 so you
> > should stay with 2.1 for now.
> >
> > Also you are showing here - could you verify that the put request from
> > your client is also encoding utf8!
> >
> > My problem is that it works fine in my case - for both filestore and for
> > the SQLServer store. This makes me conclude that it is a setup issue or
> > and oracle store problem. Or am I missing something?
> >
> > /jacob
> >
> > ----- Original Message -----
> > From: "delbd" <de...@oma.be>
> > To: "Slide Users Mailing List" <sl...@jakarta.apache.org>
> > Sent: Monday, May 02, 2005 10:57 AM
> > Subject: Re: Non us-ascii character in filenames break. Was: French
> > accent, getting crazy....
> >
> >
> > The put went without a problem. The data is encoded correctly on the
> > database.
> > It's an Oracle database and the accents are corrects in it. On propfind,
> > slide sends a list of documents with an encoded href. This is the href
> > the client should be sending back to slide when it tries any operation
> > on
> > document. As detailed in bug report, slide is unable to decode the href
> > it has send, this has nothing to do with the client IMO.
> >
> > For example, a document
> > /files/d0_public/téèst.txt
> > gets a href in the result of propfind in d0_public like this:
> > <D:response xmlns:D="DAV:">
> > <D:href>/intranet/DAV/files/d0_public/t%C3%A9%C3%A8st.txt</D:href>
> > <D:propstat>
> > <D:prop>
> > ...blablabla
> > however, a GET on this url returns an object not found.
> > Problem arise wether slide is configured with utf-8 or another charset.
> > I
> > also
> > set java.io.encoding to UTF-8 to set the default String encoding to
> > utf-8
> > (just to be sure).
> >
> > See transcript:
> >
> > delbd@CAL-12:~$ telnet localhost 8080
> > Trying 127.0.0.1...
> > Connected to localhost.
> > Escape character is '^]'.
> > GET /intranet/DAV/files/d0_public/t%C3%A9%C3%A8st.txt HTTP/1.1
> > Host: localhost:8080
> >
> > HTTP/1.1 404 Not Found: No object found
> > at /files/d0_public/t%C3%A9%C3%A8st.txt
> > Server: Apache-Coyote/1.1
> > Set-Cookie: JSESSIONID=5C06606B1A4C0A5DC6629178C9009704; Path=/intranet
> > Content-Type: text/html;charset=utf-8
> > Content-Length: 1148
> > Date: Mon, 02 May 2005 08:50:53 GMT
> >
> > <html><head><title>Apache Tomcat/5.5.7 - Error
> > report</title><style><!--H1
> > {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76
> >;font-size:22px;} H2
> > {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76
> >;font-size:16px;} H3
> > {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76
> >;font-size:14px;} BODY
> > {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;}
> > B
> > {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76
> >;} P
> > {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-si
> >ze:12px;}A {color : black;}A.name {color : black;}HR {color :
> > #525D76;}--></style> </head><body><h1>HTTP Status 404 - Not Found: No
> > object found
> > at /files/d0_public/t%C3%A9%C3%A8st.txt</h1><HR size="1"
> > noshade="noshade"><p><b>type</b> Status report</p><p><b>message</b>
> > <u>Not Found: No objectfound
> > at /files/d0_public/t%C3%A9%C3%A8st.txt</u></p><p><b>description</b>
> > <u>The
> > requested resource (Not Found: No object found
> > at /files/d0_public/t%C3%A9%C3%A8st.txt) is not available.</u></p><HR
> > size="1" noshade="noshade"><h3>Apache
> > Tomcat/5.5.7</h3></body></html>Connection closed by foreign host.
> >
> > --
> > David Delbecq
> > Royal Meteorological Institute of Belgium
> >
> > Le Lundi 2 Mai 2005 09:02, Jacob Lund a écrit :
> >> I cannot help this - are you sure that you client is using utf8?
> >>
> >> I am Danish, and I can store filenames using special Danish letters. I
> >> have
> >> also tested with Russian letter in filenames, and it is working fine!
> >>
> >> What you describe sound to me like you client is sending non utf8
> >> encoded data to slide, and that will mess up files it the way you
> >> describe! Your problems are the same as when I tested with windows 2000
> >> and webfolders. Windows 2000 only worked when I installed office xp
> >> with
> >> latest servicepack
> >> or office 2003. Windows XP seem to be working fine.
> >>
> >> DAVExplorer will corrupt filenames if your slide is set to utf8.
> >>
> >> If you put a sniffer on you system and monitor the data transmitted
> >> between
> >> client and server, then try following. Upload a file called é.bat and
> >> the header send from the client should look something like this:
> >>
> >> PUT /files/%c3%a9.bat HTTP/1.1
> >> Host: localhost:82
> >>
> >> That is: the utf8 escaped version of é is %c3%a9. And the unexcaped
> >> utf8
> >> version of é would be: é. This is correct behavior.
> >>
> >> /jacob
> >>
> >>
> >> ----- Original Message -----
> >> From: "delbd" <de...@oma.be>
> >> To: "Slide Users Mailing List" <sl...@jakarta.apache.org>
> >> Sent: Friday, April 29, 2005 3:19 PM
> >> Subject: Non us-ascii character in filenames break. Was: French accent,
> >> getting crazy....
> >>
> >>
> >> Submitted a detailed bug report of problem. I hope the slide devels
> >> will
> >> fix this fast!
> >> http://issues.apache.org/bugzilla/show_bug.cgi?id=34679
> >>
> >> Le Vendredi 29 Avril 2005 12:55, Alexandre Clavaud a écrit :
> >> > Thanks, that will be great.
> >> >
> >> > I have to projects:
> >> > 1. For a customer, using Slide as Document Management repository,
> >> > accessing
> >> > from WebFolder and from Java applications.
> >> >
> >> > 2. For Compiere, an Open Source ERP, using Slide as Document
> >> > Management repository full integrated in the application, with
> >> > Document and Folder types, metadata, workflow, ... If ok, will be
> >> > part
> >> > of the core product.
> >> >
> >> > Regards
> >> >
> >> > Alexandre
> >> >
> >> > > Hooow shit!
> >> > > Tried here. Indeed slide mess with the accents when sending it's
> >> > > result
> >> > > to the client. I created a file with accents. Platform encoding is
> >> > > utf-8,
> >> > > slide encoding is utf-8, client is the kde webdav protocol working
> >> > > nicely
> >> > > with accent on other webdav implementations. However, result of a
> >> > > propfind (sniffed with ethereal) send by slide server is like if
> >> > > string
> >> > > was converted to an utf-8 byte array and then converted back to
> >> > > string
> >> > > as
> >> > > an iso8859-1 byte array. (This is the typical round copyright sign
> >> > > followed by another char which we all see when a browser tries to
> >> > > open
> >> > > an
> >> > > utf-8 page as an iso8859 one). This look like it's done before
> >> > > server put
> >> > > it in the propfind result dom. Problem being it's the server doing
> >> > > the
> >> > > messup before url encoding. For information, not only the href is
> >> > > wrong
> >> > > but also the displayname. Clients bear no responsability in
> >> > > problem.
> >> > >
> >> > >
> >> > > I also took a look in database, as we store document on an oracle
> >> > > database, the uri and the displayname are all ok. So seems like
> >> > > it's
> >> > > the servlet on output which mess something. I'll do some step by
> >> > > step analysis and keep you informed if i can find a way around
> >> > > this.
> >> > >
> >> > > Note to slide-dev, this is a real problem big problem as the
> >> > > document becomes unmanageable!
> >> > >
> >> > > Le Vendredi 29 Avril 2005 11:35, Alexandre Clavaud a écrit :
> >> > >> Then, rather than using utf8, should I use ISO8859-1 ?
> >> > >>
> >> > >>> I have slide 2.1 working with utf8. But you should notice that
> >> > >>> windows 2000
> >> > >>> with office 97 and DAVExplorer does not support utf8.
> >> > >>>
> >> > >>> Have a look at:
> >> > >>> http://greenbytes.de/tech/webdav/webfolder-client-list.html
> >> > >>>
> >> > >>>
> >> > >>>
> >> > >>> /jacob
> >> > >>>
> >> > >>>
> >> > >>>
> >> > >>> ----- Original Message -----
> >> > >>> From: "Alexandre Clavaud" <Al...@ilem.ch>
> >> > >>> To: <sl...@jakarta.apache.org>
> >> > >>> Sent: Friday, April 29, 2005 8:48 AM
> >> > >>> Subject: French accent, getting crazy....
> >> > >>>
> >> > >>>> Hello,
> >> > >>>>
> >> > >>>>
> >> > >>>>
> >> > >>>> Does someone managed to make slide (2.1 or more) working with
> >> > >>>> french accent ? using Oracle store (Oracle 10g) ? using File
> >> > >>>> store (linux) ?
> >> > >>>> using Bea Weblogic (v8.1 on linux) ?
> >> > >>>>
> >> > >>>>
> >> > >>>> from DAV Explorer ? from Webfolder on windows 2000 with Office
> >> > >>>> 97
> >> > >>>> ?
> >> > >>>>
> >> > >>>>
> >> > >>>> I tried differents combinaison of utf8 and iso8859-1 in
> >> > >>>> slide.properties but I still get error when getting the file or
> >> > >>>> when
> >> > >>>> browsing the content of a folder (the file is displayed with
> >> > >>>> '_'
> >> > >>>> instead of accentued characters).
> >> > >>>>
> >> > >>>> I really need help, I'm getting crazy and I've got a big project
> >> > >>>> on
> >> > >>>> which I want to use slide.
> >> > >>>>
> >> > >>>> ----------------------------------------------------
> >> > >>>> Alexandre Clavaud
> >> > >>>> Consultant Technique
> >> > >>>> ILEM S.A
> >> > >>>>
> >> > >>>>
> >> > >>>>
> >> > >>>> Tel: +41 79 773 6888
> >> > >>>> Email : Alexandre.Clavaud@ilem.ch
> >> > >>>> ---------------------------------------------------
> >> > >>>>
> >> > >>>>
> >> > >>>>
> >> > >>>>
> >> > >>>> -----------------------------------------------------------------
> >> > >>>>-- --
> >> > >>>> To unsubscribe, e-mail:
> >> > >>>> slide-user-unsubscribe@jakarta.apache.org
> >> > >>>> For additional commands, e-mail:
> >> > >>>> slide-user-help@jakarta.apache.org
> >> > >>>
> >> > >>> ------------------------------------------------------------------
> >> > >>>--- To unsubscribe, e-mail:
> >> > >>> slide-user-unsubscribe@jakarta.apache.org For additional
> >> > >>> commands,
> >> > >>> e-mail: slide-user-help@jakarta.apache.org
> >> > >>
> >> > >> ----------------------------------------------------
> >> > >> Alexandre Clavaud
> >> > >> Consultant Technique
> >> > >> ILEM S.A
> >> > >>
> >> > >>
> >> > >> Tel: +41 79 773 6888
> >> > >> Email : Alexandre.Clavaud@ilem.ch
> >> > >> ---------------------------------------------------
> >> > >>
> >> > >>
> >> > >>
> >> > >> -------------------------------------------------------------------
> >> > >>-- To unsubscribe, e-mail:
> >> > >>slide-user-unsubscribe@jakarta.apache.org
> >> > >> For additional commands, e-mail:
> >> > >> slide-user-help@jakarta.apache.org
> >> > >
> >> > > --
> >> > > David Delbecq
> >> > > Royal Meteorological Institute of Belgium
> >> > >
> >> > >
> >> > > --------------------------------------------------------------------
> >> > >- To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> >> > > For additional commands, e-mail: slide-user-help@jakarta.apache.org
> >> >
> >> > ----------------------------------------------------
> >> > Alexandre Clavaud
> >> > Consultant Technique
> >> > ILEM S.A
> >> >
> >> > Tel: +41 79 773 6888
> >> > Email : Alexandre.Clavaud@ilem.ch
> >> > ---------------------------------------------------
> >> >
> >> >
> >> > ---------------------------------------------------------------------
> >> > To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> >> > For additional commands, e-mail: slide-user-help@jakarta.apache.org
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: slide-user-help@jakarta.apache.org
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: slide-user-help@jakarta.apache.org
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: slide-user-help@jakarta.apache.org
--
David Delbecq
Royal Meteorological Institute of Belgium
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org
Re: Non us-ascii character in filenames break. Was: French accent, getting crazy....
Posted by delbd <de...@oma.be>.
Yes oracle database here is configured to use a unicode character set as the
default charset for all text fields.
Le Lundi 2 Mai 2005 13:26, Jacob Lund a écrit :
> I just noticed something - is the sql scheme for oracle using Unicode?
>
> In order to make SQLServer support utf8 I had to change varchar to
> nvarchar - otherwise it would react in a way similar to what you describe.
>
> If you create a file on you desktop and cut&past some Russian characters
> into the filename and the upload the file to slide, the it will fail unless
> the database supports unicode.
>
> /jacob
>
> ----- Original Message -----
> From: "Jacob Lund" <jl...@qualiware.net>
> To: "Slide Users Mailing List" <sl...@jakarta.apache.org>
> Sent: Monday, May 02, 2005 1:20 PM
> Subject: Re: Non us-ascii character in filenames break. Was: French accent,
> getting crazy....
>
> >I just uploaded a file with that exact name: téèst.txt to my slide version
> >2.1.
> >
> > I tried with both windows explorer webfolder and with my own client - it
> > worked fine.
> >
> > Are you testing with the txfilestore? BTW utf8 is broken in 2.2 so you
> > should stay with 2.1 for now.
> >
> > Also you are showing here - could you verify that the put request from
> > your client is also encoding utf8!
> >
> > My problem is that it works fine in my case - for both filestore and for
> > the SQLServer store. This makes me conclude that it is a setup issue or
> > and oracle store problem. Or am I missing something?
> >
> > /jacob
> >
> > ----- Original Message -----
> > From: "delbd" <de...@oma.be>
> > To: "Slide Users Mailing List" <sl...@jakarta.apache.org>
> > Sent: Monday, May 02, 2005 10:57 AM
> > Subject: Re: Non us-ascii character in filenames break. Was: French
> > accent, getting crazy....
> >
> >
> > The put went without a problem. The data is encoded correctly on the
> > database.
> > It's an Oracle database and the accents are corrects in it. On propfind,
> > slide sends a list of documents with an encoded href. This is the href
> > the client should be sending back to slide when it tries any operation on
> > document. As detailed in bug report, slide is unable to decode the href
> > it has send, this has nothing to do with the client IMO.
> >
> > For example, a document
> > /files/d0_public/téèst.txt
> > gets a href in the result of propfind in d0_public like this:
> > <D:response xmlns:D="DAV:">
> > <D:href>/intranet/DAV/files/d0_public/t%C3%A9%C3%A8st.txt</D:href>
> > <D:propstat>
> > <D:prop>
> > ...blablabla
> > however, a GET on this url returns an object not found.
> > Problem arise wether slide is configured with utf-8 or another charset. I
> > also
> > set java.io.encoding to UTF-8 to set the default String encoding to utf-8
> > (just to be sure).
> >
> > See transcript:
> >
> > delbd@CAL-12:~$ telnet localhost 8080
> > Trying 127.0.0.1...
> > Connected to localhost.
> > Escape character is '^]'.
> > GET /intranet/DAV/files/d0_public/t%C3%A9%C3%A8st.txt HTTP/1.1
> > Host: localhost:8080
> >
> > HTTP/1.1 404 Not Found: No object found
> > at /files/d0_public/t%C3%A9%C3%A8st.txt
> > Server: Apache-Coyote/1.1
> > Set-Cookie: JSESSIONID=5C06606B1A4C0A5DC6629178C9009704; Path=/intranet
> > Content-Type: text/html;charset=utf-8
> > Content-Length: 1148
> > Date: Mon, 02 May 2005 08:50:53 GMT
> >
> > <html><head><title>Apache Tomcat/5.5.7 - Error
> > report</title><style><!--H1
> > {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76
> >;font-size:22px;} H2
> > {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76
> >;font-size:16px;} H3
> > {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76
> >;font-size:14px;} BODY
> > {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;}
> > B
> > {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76
> >;} P
> > {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-si
> >ze:12px;}A {color : black;}A.name {color : black;}HR {color :
> > #525D76;}--></style> </head><body><h1>HTTP Status 404 - Not Found: No
> > object found
> > at /files/d0_public/t%C3%A9%C3%A8st.txt</h1><HR size="1"
> > noshade="noshade"><p><b>type</b> Status report</p><p><b>message</b>
> > <u>Not Found: No objectfound
> > at /files/d0_public/t%C3%A9%C3%A8st.txt</u></p><p><b>description</b>
> > <u>The
> > requested resource (Not Found: No object found
> > at /files/d0_public/t%C3%A9%C3%A8st.txt) is not available.</u></p><HR
> > size="1" noshade="noshade"><h3>Apache
> > Tomcat/5.5.7</h3></body></html>Connection closed by foreign host.
> >
> > --
> > David Delbecq
> > Royal Meteorological Institute of Belgium
> >
> > Le Lundi 2 Mai 2005 09:02, Jacob Lund a écrit :
> >> I cannot help this - are you sure that you client is using utf8?
> >>
> >> I am Danish, and I can store filenames using special Danish letters. I
> >> have
> >> also tested with Russian letter in filenames, and it is working fine!
> >>
> >> What you describe sound to me like you client is sending non utf8
> >> encoded data to slide, and that will mess up files it the way you
> >> describe! Your problems are the same as when I tested with windows 2000
> >> and webfolders. Windows 2000 only worked when I installed office xp with
> >> latest servicepack
> >> or office 2003. Windows XP seem to be working fine.
> >>
> >> DAVExplorer will corrupt filenames if your slide is set to utf8.
> >>
> >> If you put a sniffer on you system and monitor the data transmitted
> >> between
> >> client and server, then try following. Upload a file called é.bat and
> >> the header send from the client should look something like this:
> >>
> >> PUT /files/%c3%a9.bat HTTP/1.1
> >> Host: localhost:82
> >>
> >> That is: the utf8 escaped version of é is %c3%a9. And the unexcaped utf8
> >> version of é would be: é. This is correct behavior.
> >>
> >> /jacob
> >>
> >>
> >> ----- Original Message -----
> >> From: "delbd" <de...@oma.be>
> >> To: "Slide Users Mailing List" <sl...@jakarta.apache.org>
> >> Sent: Friday, April 29, 2005 3:19 PM
> >> Subject: Non us-ascii character in filenames break. Was: French accent,
> >> getting crazy....
> >>
> >>
> >> Submitted a detailed bug report of problem. I hope the slide devels will
> >> fix this fast!
> >> http://issues.apache.org/bugzilla/show_bug.cgi?id=34679
> >>
> >> Le Vendredi 29 Avril 2005 12:55, Alexandre Clavaud a écrit :
> >> > Thanks, that will be great.
> >> >
> >> > I have to projects:
> >> > 1. For a customer, using Slide as Document Management repository,
> >> > accessing
> >> > from WebFolder and from Java applications.
> >> >
> >> > 2. For Compiere, an Open Source ERP, using Slide as Document
> >> > Management repository full integrated in the application, with
> >> > Document and Folder types, metadata, workflow, ... If ok, will be part
> >> > of the core product.
> >> >
> >> > Regards
> >> >
> >> > Alexandre
> >> >
> >> > > Hooow shit!
> >> > > Tried here. Indeed slide mess with the accents when sending it's
> >> > > result
> >> > > to the client. I created a file with accents. Platform encoding is
> >> > > utf-8,
> >> > > slide encoding is utf-8, client is the kde webdav protocol working
> >> > > nicely
> >> > > with accent on other webdav implementations. However, result of a
> >> > > propfind (sniffed with ethereal) send by slide server is like if
> >> > > string
> >> > > was converted to an utf-8 byte array and then converted back to
> >> > > string
> >> > > as
> >> > > an iso8859-1 byte array. (This is the typical round copyright sign
> >> > > followed by another char which we all see when a browser tries to
> >> > > open
> >> > > an
> >> > > utf-8 page as an iso8859 one). This look like it's done before
> >> > > server put
> >> > > it in the propfind result dom. Problem being it's the server doing
> >> > > the
> >> > > messup before url encoding. For information, not only the href is
> >> > > wrong
> >> > > but also the displayname. Clients bear no responsability in problem.
> >> > >
> >> > >
> >> > > I also took a look in database, as we store document on an oracle
> >> > > database, the uri and the displayname are all ok. So seems like it's
> >> > > the servlet on output which mess something. I'll do some step by
> >> > > step analysis and keep you informed if i can find a way around this.
> >> > >
> >> > > Note to slide-dev, this is a real problem big problem as the
> >> > > document becomes unmanageable!
> >> > >
> >> > > Le Vendredi 29 Avril 2005 11:35, Alexandre Clavaud a écrit :
> >> > >> Then, rather than using utf8, should I use ISO8859-1 ?
> >> > >>
> >> > >>> I have slide 2.1 working with utf8. But you should notice that
> >> > >>> windows 2000
> >> > >>> with office 97 and DAVExplorer does not support utf8.
> >> > >>>
> >> > >>> Have a look at:
> >> > >>> http://greenbytes.de/tech/webdav/webfolder-client-list.html
> >> > >>>
> >> > >>>
> >> > >>>
> >> > >>> /jacob
> >> > >>>
> >> > >>>
> >> > >>>
> >> > >>> ----- Original Message -----
> >> > >>> From: "Alexandre Clavaud" <Al...@ilem.ch>
> >> > >>> To: <sl...@jakarta.apache.org>
> >> > >>> Sent: Friday, April 29, 2005 8:48 AM
> >> > >>> Subject: French accent, getting crazy....
> >> > >>>
> >> > >>>> Hello,
> >> > >>>>
> >> > >>>>
> >> > >>>>
> >> > >>>> Does someone managed to make slide (2.1 or more) working with
> >> > >>>> french accent ? using Oracle store (Oracle 10g) ? using File
> >> > >>>> store (linux) ?
> >> > >>>> using Bea Weblogic (v8.1 on linux) ?
> >> > >>>>
> >> > >>>>
> >> > >>>> from DAV Explorer ? from Webfolder on windows 2000 with Office 97
> >> > >>>> ?
> >> > >>>>
> >> > >>>>
> >> > >>>> I tried differents combinaison of utf8 and iso8859-1 in
> >> > >>>> slide.properties but I still get error when getting the file or
> >> > >>>> when
> >> > >>>> browsing the content of a folder (the file is displayed with '_'
> >> > >>>> instead of accentued characters).
> >> > >>>>
> >> > >>>> I really need help, I'm getting crazy and I've got a big project
> >> > >>>> on
> >> > >>>> which I want to use slide.
> >> > >>>>
> >> > >>>> ----------------------------------------------------
> >> > >>>> Alexandre Clavaud
> >> > >>>> Consultant Technique
> >> > >>>> ILEM S.A
> >> > >>>>
> >> > >>>>
> >> > >>>>
> >> > >>>> Tel: +41 79 773 6888
> >> > >>>> Email : Alexandre.Clavaud@ilem.ch
> >> > >>>> ---------------------------------------------------
> >> > >>>>
> >> > >>>>
> >> > >>>>
> >> > >>>>
> >> > >>>> -----------------------------------------------------------------
> >> > >>>>-- --
> >> > >>>> To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> >> > >>>> For additional commands, e-mail:
> >> > >>>> slide-user-help@jakarta.apache.org
> >> > >>>
> >> > >>> ------------------------------------------------------------------
> >> > >>>--- To unsubscribe, e-mail:
> >> > >>> slide-user-unsubscribe@jakarta.apache.org For additional commands,
> >> > >>> e-mail: slide-user-help@jakarta.apache.org
> >> > >>
> >> > >> ----------------------------------------------------
> >> > >> Alexandre Clavaud
> >> > >> Consultant Technique
> >> > >> ILEM S.A
> >> > >>
> >> > >>
> >> > >> Tel: +41 79 773 6888
> >> > >> Email : Alexandre.Clavaud@ilem.ch
> >> > >> ---------------------------------------------------
> >> > >>
> >> > >>
> >> > >>
> >> > >> -------------------------------------------------------------------
> >> > >>-- To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> >> > >> For additional commands, e-mail: slide-user-help@jakarta.apache.org
> >> > >
> >> > > --
> >> > > David Delbecq
> >> > > Royal Meteorological Institute of Belgium
> >> > >
> >> > >
> >> > > --------------------------------------------------------------------
> >> > >- To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> >> > > For additional commands, e-mail: slide-user-help@jakarta.apache.org
> >> >
> >> > ----------------------------------------------------
> >> > Alexandre Clavaud
> >> > Consultant Technique
> >> > ILEM S.A
> >> >
> >> > Tel: +41 79 773 6888
> >> > Email : Alexandre.Clavaud@ilem.ch
> >> > ---------------------------------------------------
> >> >
> >> >
> >> > ---------------------------------------------------------------------
> >> > To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> >> > For additional commands, e-mail: slide-user-help@jakarta.apache.org
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: slide-user-help@jakarta.apache.org
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: slide-user-help@jakarta.apache.org
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: slide-user-help@jakarta.apache.org
--
David Delbecq
Royal Meteorological Institute of Belgium
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org
Re: Non us-ascii character in filenames break. Was: French accent, getting crazy....
Posted by Jacob Lund <jl...@qualiware.net>.
I just noticed something - is the sql scheme for oracle using Unicode?
In order to make SQLServer support utf8 I had to change varchar to
nvarchar - otherwise it would react in a way similar to what you describe.
If you create a file on you desktop and cut&past some Russian characters
into the filename and the upload the file to slide, the it will fail unless
the database supports unicode.
/jacob
----- Original Message -----
From: "Jacob Lund" <jl...@qualiware.net>
To: "Slide Users Mailing List" <sl...@jakarta.apache.org>
Sent: Monday, May 02, 2005 1:20 PM
Subject: Re: Non us-ascii character in filenames break. Was: French accent,
getting crazy....
>I just uploaded a file with that exact name: téèst.txt to my slide version
>2.1.
>
> I tried with both windows explorer webfolder and with my own client - it
> worked fine.
>
> Are you testing with the txfilestore? BTW utf8 is broken in 2.2 so you
> should stay with 2.1 for now.
>
> Also you are showing here - could you verify that the put request from
> your client is also encoding utf8!
>
> My problem is that it works fine in my case - for both filestore and for
> the SQLServer store. This makes me conclude that it is a setup issue or
> and oracle store problem. Or am I missing something?
>
> /jacob
>
> ----- Original Message -----
> From: "delbd" <de...@oma.be>
> To: "Slide Users Mailing List" <sl...@jakarta.apache.org>
> Sent: Monday, May 02, 2005 10:57 AM
> Subject: Re: Non us-ascii character in filenames break. Was: French
> accent, getting crazy....
>
>
> The put went without a problem. The data is encoded correctly on the
> database.
> It's an Oracle database and the accents are corrects in it. On propfind,
> slide sends a list of documents with an encoded href. This is the href the
> client should be sending back to slide when it tries any operation on
> document. As detailed in bug report, slide is unable to decode the href it
> has send, this has nothing to do with the client IMO.
>
> For example, a document
> /files/d0_public/téèst.txt
> gets a href in the result of propfind in d0_public like this:
> <D:response xmlns:D="DAV:">
> <D:href>/intranet/DAV/files/d0_public/t%C3%A9%C3%A8st.txt</D:href>
> <D:propstat>
> <D:prop>
> ...blablabla
> however, a GET on this url returns an object not found.
> Problem arise wether slide is configured with utf-8 or another charset. I
> also
> set java.io.encoding to UTF-8 to set the default String encoding to utf-8
> (just to be sure).
>
> See transcript:
>
> delbd@CAL-12:~$ telnet localhost 8080
> Trying 127.0.0.1...
> Connected to localhost.
> Escape character is '^]'.
> GET /intranet/DAV/files/d0_public/t%C3%A9%C3%A8st.txt HTTP/1.1
> Host: localhost:8080
>
> HTTP/1.1 404 Not Found: No object found
> at /files/d0_public/t%C3%A9%C3%A8st.txt
> Server: Apache-Coyote/1.1
> Set-Cookie: JSESSIONID=5C06606B1A4C0A5DC6629178C9009704; Path=/intranet
> Content-Type: text/html;charset=utf-8
> Content-Length: 1148
> Date: Mon, 02 May 2005 08:50:53 GMT
>
> <html><head><title>Apache Tomcat/5.5.7 - Error report</title><style><!--H1
> {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;}
> H2
> {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;}
> H3
> {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;}
> BODY
> {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;}
> B
> {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;}
> P
> {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A
> {color : black;}A.name {color : black;}HR {color : #525D76;}--></style>
> </head><body><h1>HTTP Status 404 - Not Found: No object found
> at /files/d0_public/t%C3%A9%C3%A8st.txt</h1><HR size="1"
> noshade="noshade"><p><b>type</b> Status report</p><p><b>message</b> <u>Not
> Found: No objectfound
> at /files/d0_public/t%C3%A9%C3%A8st.txt</u></p><p><b>description</b>
> <u>The
> requested resource (Not Found: No object found
> at /files/d0_public/t%C3%A9%C3%A8st.txt) is not available.</u></p><HR
> size="1" noshade="noshade"><h3>Apache
> Tomcat/5.5.7</h3></body></html>Connection closed by foreign host.
>
> --
> David Delbecq
> Royal Meteorological Institute of Belgium
>
> Le Lundi 2 Mai 2005 09:02, Jacob Lund a écrit :
>> I cannot help this - are you sure that you client is using utf8?
>>
>> I am Danish, and I can store filenames using special Danish letters. I
>> have
>> also tested with Russian letter in filenames, and it is working fine!
>>
>> What you describe sound to me like you client is sending non utf8 encoded
>> data to slide, and that will mess up files it the way you describe! Your
>> problems are the same as when I tested with windows 2000 and webfolders.
>> Windows 2000 only worked when I installed office xp with latest
>> servicepack
>> or office 2003. Windows XP seem to be working fine.
>>
>> DAVExplorer will corrupt filenames if your slide is set to utf8.
>>
>> If you put a sniffer on you system and monitor the data transmitted
>> between
>> client and server, then try following. Upload a file called é.bat and the
>> header send from the client should look something like this:
>>
>> PUT /files/%c3%a9.bat HTTP/1.1
>> Host: localhost:82
>>
>> That is: the utf8 escaped version of é is %c3%a9. And the unexcaped utf8
>> version of é would be: é. This is correct behavior.
>>
>> /jacob
>>
>>
>> ----- Original Message -----
>> From: "delbd" <de...@oma.be>
>> To: "Slide Users Mailing List" <sl...@jakarta.apache.org>
>> Sent: Friday, April 29, 2005 3:19 PM
>> Subject: Non us-ascii character in filenames break. Was: French accent,
>> getting crazy....
>>
>>
>> Submitted a detailed bug report of problem. I hope the slide devels will
>> fix this fast!
>> http://issues.apache.org/bugzilla/show_bug.cgi?id=34679
>>
>> Le Vendredi 29 Avril 2005 12:55, Alexandre Clavaud a écrit :
>> > Thanks, that will be great.
>> >
>> > I have to projects:
>> > 1. For a customer, using Slide as Document Management repository,
>> > accessing
>> > from WebFolder and from Java applications.
>> >
>> > 2. For Compiere, an Open Source ERP, using Slide as Document Management
>> > repository full integrated in the application, with Document and Folder
>> > types, metadata, workflow, ... If ok, will be part of the core product.
>> >
>> > Regards
>> >
>> > Alexandre
>> >
>> > > Hooow shit!
>> > > Tried here. Indeed slide mess with the accents when sending it's
>> > > result
>> > > to the client. I created a file with accents. Platform encoding is
>> > > utf-8,
>> > > slide encoding is utf-8, client is the kde webdav protocol working
>> > > nicely
>> > > with accent on other webdav implementations. However, result of a
>> > > propfind (sniffed with ethereal) send by slide server is like if
>> > > string
>> > > was converted to an utf-8 byte array and then converted back to
>> > > string
>> > > as
>> > > an iso8859-1 byte array. (This is the typical round copyright sign
>> > > followed by another char which we all see when a browser tries to
>> > > open
>> > > an
>> > > utf-8 page as an iso8859 one). This look like it's done before server
>> > > put
>> > > it in the propfind result dom. Problem being it's the server doing
>> > > the
>> > > messup before url encoding. For information, not only the href is
>> > > wrong
>> > > but also the displayname. Clients bear no responsability in problem.
>> > >
>> > >
>> > > I also took a look in database, as we store document on an oracle
>> > > database, the uri and the displayname are all ok. So seems like it's
>> > > the servlet on output which mess something. I'll do some step by step
>> > > analysis and keep you informed if i can find a way around this.
>> > >
>> > > Note to slide-dev, this is a real problem big problem as the document
>> > > becomes unmanageable!
>> > >
>> > > Le Vendredi 29 Avril 2005 11:35, Alexandre Clavaud a écrit :
>> > >> Then, rather than using utf8, should I use ISO8859-1 ?
>> > >>
>> > >>> I have slide 2.1 working with utf8. But you should notice that
>> > >>> windows 2000
>> > >>> with office 97 and DAVExplorer does not support utf8.
>> > >>>
>> > >>> Have a look at:
>> > >>> http://greenbytes.de/tech/webdav/webfolder-client-list.html
>> > >>>
>> > >>>
>> > >>>
>> > >>> /jacob
>> > >>>
>> > >>>
>> > >>>
>> > >>> ----- Original Message -----
>> > >>> From: "Alexandre Clavaud" <Al...@ilem.ch>
>> > >>> To: <sl...@jakarta.apache.org>
>> > >>> Sent: Friday, April 29, 2005 8:48 AM
>> > >>> Subject: French accent, getting crazy....
>> > >>>
>> > >>>> Hello,
>> > >>>>
>> > >>>>
>> > >>>>
>> > >>>> Does someone managed to make slide (2.1 or more) working with
>> > >>>> french accent ? using Oracle store (Oracle 10g) ? using File store
>> > >>>> (linux) ?
>> > >>>> using Bea Weblogic (v8.1 on linux) ?
>> > >>>>
>> > >>>>
>> > >>>> from DAV Explorer ? from Webfolder on windows 2000 with Office 97
>> > >>>> ?
>> > >>>>
>> > >>>>
>> > >>>> I tried differents combinaison of utf8 and iso8859-1 in
>> > >>>> slide.properties but I still get error when getting the file or
>> > >>>> when
>> > >>>> browsing the content of a folder (the file is displayed with '_'
>> > >>>> instead of accentued characters).
>> > >>>>
>> > >>>> I really need help, I'm getting crazy and I've got a big project
>> > >>>> on
>> > >>>> which I want to use slide.
>> > >>>>
>> > >>>> ----------------------------------------------------
>> > >>>> Alexandre Clavaud
>> > >>>> Consultant Technique
>> > >>>> ILEM S.A
>> > >>>>
>> > >>>>
>> > >>>>
>> > >>>> Tel: +41 79 773 6888
>> > >>>> Email : Alexandre.Clavaud@ilem.ch
>> > >>>> ---------------------------------------------------
>> > >>>>
>> > >>>>
>> > >>>>
>> > >>>>
>> > >>>> -------------------------------------------------------------------
>> > >>>> --
>> > >>>> To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
>> > >>>> For additional commands, e-mail:
>> > >>>> slide-user-help@jakarta.apache.org
>> > >>>
>> > >>> ---------------------------------------------------------------------
>> > >>> To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
>> > >>> For additional commands, e-mail: slide-user-help@jakarta.apache.org
>> > >>
>> > >> ----------------------------------------------------
>> > >> Alexandre Clavaud
>> > >> Consultant Technique
>> > >> ILEM S.A
>> > >>
>> > >>
>> > >> Tel: +41 79 773 6888
>> > >> Email : Alexandre.Clavaud@ilem.ch
>> > >> ---------------------------------------------------
>> > >>
>> > >>
>> > >>
>> > >> ---------------------------------------------------------------------
>> > >> To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
>> > >> For additional commands, e-mail: slide-user-help@jakarta.apache.org
>> > >
>> > > --
>> > > David Delbecq
>> > > Royal Meteorological Institute of Belgium
>> > >
>> > >
>> > > ---------------------------------------------------------------------
>> > > To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
>> > > For additional commands, e-mail: slide-user-help@jakarta.apache.org
>> >
>> > ----------------------------------------------------
>> > Alexandre Clavaud
>> > Consultant Technique
>> > ILEM S.A
>> >
>> > Tel: +41 79 773 6888
>> > Email : Alexandre.Clavaud@ilem.ch
>> > ---------------------------------------------------
>> >
>> >
>> > ---------------------------------------------------------------------
>> > To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
>> > For additional commands, e-mail: slide-user-help@jakarta.apache.org
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: slide-user-help@jakarta.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: slide-user-help@jakarta.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org
Re: Non us-ascii character in filenames break. Was: French accent, getting crazy....
Posted by Jacob Lund <jl...@qualiware.net>.
I just uploaded a file with that exact name: téèst.txt to my slide version
2.1.
I tried with both windows explorer webfolder and with my own client - it
worked fine.
Are you testing with the txfilestore? BTW utf8 is broken in 2.2 so you
should stay with 2.1 for now.
Also you are showing here - could you verify that the put request from your
client is also encoding utf8!
My problem is that it works fine in my case - for both filestore and for the
SQLServer store. This makes me conclude that it is a setup issue or and
oracle store problem. Or am I missing something?
/jacob
----- Original Message -----
From: "delbd" <de...@oma.be>
To: "Slide Users Mailing List" <sl...@jakarta.apache.org>
Sent: Monday, May 02, 2005 10:57 AM
Subject: Re: Non us-ascii character in filenames break. Was: French accent,
getting crazy....
The put went without a problem. The data is encoded correctly on the
database.
It's an Oracle database and the accents are corrects in it. On propfind,
slide sends a list of documents with an encoded href. This is the href the
client should be sending back to slide when it tries any operation on
document. As detailed in bug report, slide is unable to decode the href it
has send, this has nothing to do with the client IMO.
For example, a document
/files/d0_public/téèst.txt
gets a href in the result of propfind in d0_public like this:
<D:response xmlns:D="DAV:">
<D:href>/intranet/DAV/files/d0_public/t%C3%A9%C3%A8st.txt</D:href>
<D:propstat>
<D:prop>
...blablabla
however, a GET on this url returns an object not found.
Problem arise wether slide is configured with utf-8 or another charset. I
also
set java.io.encoding to UTF-8 to set the default String encoding to utf-8
(just to be sure).
See transcript:
delbd@CAL-12:~$ telnet localhost 8080
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
GET /intranet/DAV/files/d0_public/t%C3%A9%C3%A8st.txt HTTP/1.1
Host: localhost:8080
HTTP/1.1 404 Not Found: No object found
at /files/d0_public/t%C3%A9%C3%A8st.txt
Server: Apache-Coyote/1.1
Set-Cookie: JSESSIONID=5C06606B1A4C0A5DC6629178C9009704; Path=/intranet
Content-Type: text/html;charset=utf-8
Content-Length: 1148
Date: Mon, 02 May 2005 08:50:53 GMT
<html><head><title>Apache Tomcat/5.5.7 - Error report</title><style><!--H1
{font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;}
H2
{font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;}
H3
{font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;}
BODY
{font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B
{font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;}
P
{font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A
{color : black;}A.name {color : black;}HR {color : #525D76;}--></style>
</head><body><h1>HTTP Status 404 - Not Found: No object found
at /files/d0_public/t%C3%A9%C3%A8st.txt</h1><HR size="1"
noshade="noshade"><p><b>type</b> Status report</p><p><b>message</b> <u>Not
Found: No objectfound
at /files/d0_public/t%C3%A9%C3%A8st.txt</u></p><p><b>description</b> <u>The
requested resource (Not Found: No object found
at /files/d0_public/t%C3%A9%C3%A8st.txt) is not available.</u></p><HR
size="1" noshade="noshade"><h3>Apache
Tomcat/5.5.7</h3></body></html>Connection closed by foreign host.
--
David Delbecq
Royal Meteorological Institute of Belgium
Le Lundi 2 Mai 2005 09:02, Jacob Lund a écrit :
> I cannot help this - are you sure that you client is using utf8?
>
> I am Danish, and I can store filenames using special Danish letters. I
> have
> also tested with Russian letter in filenames, and it is working fine!
>
> What you describe sound to me like you client is sending non utf8 encoded
> data to slide, and that will mess up files it the way you describe! Your
> problems are the same as when I tested with windows 2000 and webfolders.
> Windows 2000 only worked when I installed office xp with latest
> servicepack
> or office 2003. Windows XP seem to be working fine.
>
> DAVExplorer will corrupt filenames if your slide is set to utf8.
>
> If you put a sniffer on you system and monitor the data transmitted
> between
> client and server, then try following. Upload a file called é.bat and the
> header send from the client should look something like this:
>
> PUT /files/%c3%a9.bat HTTP/1.1
> Host: localhost:82
>
> That is: the utf8 escaped version of é is %c3%a9. And the unexcaped utf8
> version of é would be: é. This is correct behavior.
>
> /jacob
>
>
> ----- Original Message -----
> From: "delbd" <de...@oma.be>
> To: "Slide Users Mailing List" <sl...@jakarta.apache.org>
> Sent: Friday, April 29, 2005 3:19 PM
> Subject: Non us-ascii character in filenames break. Was: French accent,
> getting crazy....
>
>
> Submitted a detailed bug report of problem. I hope the slide devels will
> fix this fast!
> http://issues.apache.org/bugzilla/show_bug.cgi?id=34679
>
> Le Vendredi 29 Avril 2005 12:55, Alexandre Clavaud a écrit :
> > Thanks, that will be great.
> >
> > I have to projects:
> > 1. For a customer, using Slide as Document Management repository,
> > accessing
> > from WebFolder and from Java applications.
> >
> > 2. For Compiere, an Open Source ERP, using Slide as Document Management
> > repository full integrated in the application, with Document and Folder
> > types, metadata, workflow, ... If ok, will be part of the core product.
> >
> > Regards
> >
> > Alexandre
> >
> > > Hooow shit!
> > > Tried here. Indeed slide mess with the accents when sending it's
> > > result
> > > to the client. I created a file with accents. Platform encoding is
> > > utf-8,
> > > slide encoding is utf-8, client is the kde webdav protocol working
> > > nicely
> > > with accent on other webdav implementations. However, result of a
> > > propfind (sniffed with ethereal) send by slide server is like if
> > > string
> > > was converted to an utf-8 byte array and then converted back to string
> > > as
> > > an iso8859-1 byte array. (This is the typical round copyright sign
> > > followed by another char which we all see when a browser tries to open
> > > an
> > > utf-8 page as an iso8859 one). This look like it's done before server
> > > put
> > > it in the propfind result dom. Problem being it's the server doing the
> > > messup before url encoding. For information, not only the href is
> > > wrong
> > > but also the displayname. Clients bear no responsability in problem.
> > >
> > >
> > > I also took a look in database, as we store document on an oracle
> > > database, the uri and the displayname are all ok. So seems like it's
> > > the servlet on output which mess something. I'll do some step by step
> > > analysis and keep you informed if i can find a way around this.
> > >
> > > Note to slide-dev, this is a real problem big problem as the document
> > > becomes unmanageable!
> > >
> > > Le Vendredi 29 Avril 2005 11:35, Alexandre Clavaud a écrit :
> > >> Then, rather than using utf8, should I use ISO8859-1 ?
> > >>
> > >>> I have slide 2.1 working with utf8. But you should notice that
> > >>> windows 2000
> > >>> with office 97 and DAVExplorer does not support utf8.
> > >>>
> > >>> Have a look at:
> > >>> http://greenbytes.de/tech/webdav/webfolder-client-list.html
> > >>>
> > >>>
> > >>>
> > >>> /jacob
> > >>>
> > >>>
> > >>>
> > >>> ----- Original Message -----
> > >>> From: "Alexandre Clavaud" <Al...@ilem.ch>
> > >>> To: <sl...@jakarta.apache.org>
> > >>> Sent: Friday, April 29, 2005 8:48 AM
> > >>> Subject: French accent, getting crazy....
> > >>>
> > >>>> Hello,
> > >>>>
> > >>>>
> > >>>>
> > >>>> Does someone managed to make slide (2.1 or more) working with
> > >>>> french accent ? using Oracle store (Oracle 10g) ? using File store
> > >>>> (linux) ?
> > >>>> using Bea Weblogic (v8.1 on linux) ?
> > >>>>
> > >>>>
> > >>>> from DAV Explorer ? from Webfolder on windows 2000 with Office 97 ?
> > >>>>
> > >>>>
> > >>>> I tried differents combinaison of utf8 and iso8859-1 in
> > >>>> slide.properties but I still get error when getting the file or
> > >>>> when
> > >>>> browsing the content of a folder (the file is displayed with '_'
> > >>>> instead of accentued characters).
> > >>>>
> > >>>> I really need help, I'm getting crazy and I've got a big project on
> > >>>> which I want to use slide.
> > >>>>
> > >>>> ----------------------------------------------------
> > >>>> Alexandre Clavaud
> > >>>> Consultant Technique
> > >>>> ILEM S.A
> > >>>>
> > >>>>
> > >>>>
> > >>>> Tel: +41 79 773 6888
> > >>>> Email : Alexandre.Clavaud@ilem.ch
> > >>>> ---------------------------------------------------
> > >>>>
> > >>>>
> > >>>>
> > >>>>
> > >>>> -------------------------------------------------------------------
> > >>>> --
> > >>>> To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> > >>>> For additional commands, e-mail: slide-user-help@jakarta.apache.org
> > >>>
> > >>> ---------------------------------------------------------------------
> > >>> To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> > >>> For additional commands, e-mail: slide-user-help@jakarta.apache.org
> > >>
> > >> ----------------------------------------------------
> > >> Alexandre Clavaud
> > >> Consultant Technique
> > >> ILEM S.A
> > >>
> > >>
> > >> Tel: +41 79 773 6888
> > >> Email : Alexandre.Clavaud@ilem.ch
> > >> ---------------------------------------------------
> > >>
> > >>
> > >>
> > >> ---------------------------------------------------------------------
> > >> To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> > >> For additional commands, e-mail: slide-user-help@jakarta.apache.org
> > >
> > > --
> > > David Delbecq
> > > Royal Meteorological Institute of Belgium
> > >
> > >
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> > > For additional commands, e-mail: slide-user-help@jakarta.apache.org
> >
> > ----------------------------------------------------
> > Alexandre Clavaud
> > Consultant Technique
> > ILEM S.A
> >
> > Tel: +41 79 773 6888
> > Email : Alexandre.Clavaud@ilem.ch
> > ---------------------------------------------------
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: slide-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org
Re: Non us-ascii character in filenames break. Was: French accent, getting crazy....
Posted by delbd <de...@oma.be>.
The put went without a problem. The data is encoded correctly on the database.
It's an Oracle database and the accents are corrects in it. On propfind,
slide sends a list of documents with an encoded href. This is the href the
client should be sending back to slide when it tries any operation on
document. As detailed in bug report, slide is unable to decode the href it
has send, this has nothing to do with the client IMO.
For example, a document
/files/d0_public/téèst.txt
gets a href in the result of propfind in d0_public like this:
<D:response xmlns:D="DAV:">
<D:href>/intranet/DAV/files/d0_public/t%C3%A9%C3%A8st.txt</D:href>
<D:propstat>
<D:prop>
...blablabla
however, a GET on this url returns an object not found.
Problem arise wether slide is configured with utf-8 or another charset. I also
set java.io.encoding to UTF-8 to set the default String encoding to utf-8
(just to be sure).
See transcript:
delbd@CAL-12:~$ telnet localhost 8080
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
GET /intranet/DAV/files/d0_public/t%C3%A9%C3%A8st.txt HTTP/1.1
Host: localhost:8080
HTTP/1.1 404 Not Found: No object found
at /files/d0_public/t%C3%A9%C3%A8st.txt
Server: Apache-Coyote/1.1
Set-Cookie: JSESSIONID=5C06606B1A4C0A5DC6629178C9009704; Path=/intranet
Content-Type: text/html;charset=utf-8
Content-Length: 1148
Date: Mon, 02 May 2005 08:50:53 GMT
<html><head><title>Apache Tomcat/5.5.7 - Error report</title><style><!--H1
{font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;}
H2
{font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;}
H3
{font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;}
BODY
{font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B
{font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} P
{font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A
{color : black;}A.name {color : black;}HR {color : #525D76;}--></style>
</head><body><h1>HTTP Status 404 - Not Found: No object found
at /files/d0_public/t%C3%A9%C3%A8st.txt</h1><HR size="1"
noshade="noshade"><p><b>type</b> Status report</p><p><b>message</b> <u>Not
Found: No objectfound
at /files/d0_public/t%C3%A9%C3%A8st.txt</u></p><p><b>description</b> <u>The
requested resource (Not Found: No object found
at /files/d0_public/t%C3%A9%C3%A8st.txt) is not available.</u></p><HR
size="1" noshade="noshade"><h3>Apache
Tomcat/5.5.7</h3></body></html>Connection closed by foreign host.
--
David Delbecq
Royal Meteorological Institute of Belgium
Le Lundi 2 Mai 2005 09:02, Jacob Lund a écrit :
> I cannot help this - are you sure that you client is using utf8?
>
> I am Danish, and I can store filenames using special Danish letters. I have
> also tested with Russian letter in filenames, and it is working fine!
>
> What you describe sound to me like you client is sending non utf8 encoded
> data to slide, and that will mess up files it the way you describe! Your
> problems are the same as when I tested with windows 2000 and webfolders.
> Windows 2000 only worked when I installed office xp with latest servicepack
> or office 2003. Windows XP seem to be working fine.
>
> DAVExplorer will corrupt filenames if your slide is set to utf8.
>
> If you put a sniffer on you system and monitor the data transmitted between
> client and server, then try following. Upload a file called é.bat and the
> header send from the client should look something like this:
>
> PUT /files/%c3%a9.bat HTTP/1.1
> Host: localhost:82
>
> That is: the utf8 escaped version of é is %c3%a9. And the unexcaped utf8
> version of é would be: é. This is correct behavior.
>
> /jacob
>
>
> ----- Original Message -----
> From: "delbd" <de...@oma.be>
> To: "Slide Users Mailing List" <sl...@jakarta.apache.org>
> Sent: Friday, April 29, 2005 3:19 PM
> Subject: Non us-ascii character in filenames break. Was: French accent,
> getting crazy....
>
>
> Submitted a detailed bug report of problem. I hope the slide devels will
> fix this fast!
> http://issues.apache.org/bugzilla/show_bug.cgi?id=34679
>
> Le Vendredi 29 Avril 2005 12:55, Alexandre Clavaud a écrit :
> > Thanks, that will be great.
> >
> > I have to projects:
> > 1. For a customer, using Slide as Document Management repository,
> > accessing
> > from WebFolder and from Java applications.
> >
> > 2. For Compiere, an Open Source ERP, using Slide as Document Management
> > repository full integrated in the application, with Document and Folder
> > types, metadata, workflow, ... If ok, will be part of the core product.
> >
> > Regards
> >
> > Alexandre
> >
> > > Hooow shit!
> > > Tried here. Indeed slide mess with the accents when sending it's result
> > > to the client. I created a file with accents. Platform encoding is
> > > utf-8,
> > > slide encoding is utf-8, client is the kde webdav protocol working
> > > nicely
> > > with accent on other webdav implementations. However, result of a
> > > propfind (sniffed with ethereal) send by slide server is like if string
> > > was converted to an utf-8 byte array and then converted back to string
> > > as
> > > an iso8859-1 byte array. (This is the typical round copyright sign
> > > followed by another char which we all see when a browser tries to open
> > > an
> > > utf-8 page as an iso8859 one). This look like it's done before server
> > > put
> > > it in the propfind result dom. Problem being it's the server doing the
> > > messup before url encoding. For information, not only the href is wrong
> > > but also the displayname. Clients bear no responsability in problem.
> > >
> > >
> > > I also took a look in database, as we store document on an oracle
> > > database, the uri and the displayname are all ok. So seems like it's
> > > the servlet on output which mess something. I'll do some step by step
> > > analysis and keep you informed if i can find a way around this.
> > >
> > > Note to slide-dev, this is a real problem big problem as the document
> > > becomes unmanageable!
> > >
> > > Le Vendredi 29 Avril 2005 11:35, Alexandre Clavaud a écrit :
> > >> Then, rather than using utf8, should I use ISO8859-1 ?
> > >>
> > >>> I have slide 2.1 working with utf8. But you should notice that
> > >>> windows 2000
> > >>> with office 97 and DAVExplorer does not support utf8.
> > >>>
> > >>> Have a look at:
> > >>> http://greenbytes.de/tech/webdav/webfolder-client-list.html
> > >>>
> > >>>
> > >>>
> > >>> /jacob
> > >>>
> > >>>
> > >>>
> > >>> ----- Original Message -----
> > >>> From: "Alexandre Clavaud" <Al...@ilem.ch>
> > >>> To: <sl...@jakarta.apache.org>
> > >>> Sent: Friday, April 29, 2005 8:48 AM
> > >>> Subject: French accent, getting crazy....
> > >>>
> > >>>> Hello,
> > >>>>
> > >>>>
> > >>>>
> > >>>> Does someone managed to make slide (2.1 or more) working with
> > >>>> french accent ? using Oracle store (Oracle 10g) ? using File store
> > >>>> (linux) ?
> > >>>> using Bea Weblogic (v8.1 on linux) ?
> > >>>>
> > >>>>
> > >>>> from DAV Explorer ? from Webfolder on windows 2000 with Office 97 ?
> > >>>>
> > >>>>
> > >>>> I tried differents combinaison of utf8 and iso8859-1 in
> > >>>> slide.properties but I still get error when getting the file or when
> > >>>> browsing the content of a folder (the file is displayed with '_'
> > >>>> instead of accentued characters).
> > >>>>
> > >>>> I really need help, I'm getting crazy and I've got a big project on
> > >>>> which I want to use slide.
> > >>>>
> > >>>> ----------------------------------------------------
> > >>>> Alexandre Clavaud
> > >>>> Consultant Technique
> > >>>> ILEM S.A
> > >>>>
> > >>>>
> > >>>>
> > >>>> Tel: +41 79 773 6888
> > >>>> Email : Alexandre.Clavaud@ilem.ch
> > >>>> ---------------------------------------------------
> > >>>>
> > >>>>
> > >>>>
> > >>>>
> > >>>> -------------------------------------------------------------------
> > >>>> --
> > >>>> To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> > >>>> For additional commands, e-mail: slide-user-help@jakarta.apache.org
> > >>>
> > >>> ---------------------------------------------------------------------
> > >>> To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> > >>> For additional commands, e-mail: slide-user-help@jakarta.apache.org
> > >>
> > >> ----------------------------------------------------
> > >> Alexandre Clavaud
> > >> Consultant Technique
> > >> ILEM S.A
> > >>
> > >>
> > >> Tel: +41 79 773 6888
> > >> Email : Alexandre.Clavaud@ilem.ch
> > >> ---------------------------------------------------
> > >>
> > >>
> > >>
> > >> ---------------------------------------------------------------------
> > >> To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> > >> For additional commands, e-mail: slide-user-help@jakarta.apache.org
> > >
> > > --
> > > David Delbecq
> > > Royal Meteorological Institute of Belgium
> > >
> > >
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> > > For additional commands, e-mail: slide-user-help@jakarta.apache.org
> >
> > ----------------------------------------------------
> > Alexandre Clavaud
> > Consultant Technique
> > ILEM S.A
> >
> > Tel: +41 79 773 6888
> > Email : Alexandre.Clavaud@ilem.ch
> > ---------------------------------------------------
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: slide-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org