No, the filestore works correctly.

>From what I can see the filestore converts from UTF-8 to local before it
stores data. This I why UTF-8 works fine for me when I upload files with
Danish letters in the filename, and also why if fails when it stores files
with characters not supported by the codepage.

Windows XP use Unicode, but in "dos mode" it will use the old codepage
types. The only thing that I can imagine is that java will use this codepage
when it is doing IO operations towards the filesystem. This problem might be
a problem that only appears on windows systems.

I do not think that the problem is in the fill data into the database that
has a problem. Some place in slide it will convert that data (in this case
the uri) to UTF-8 before it is send to the client. The data stored in the
database is UTF-8, and I believe that java is using Unicode. So the solution
might be to convert data fetched from the database back to Unicode as soon
as it arrives to the store class.

The correct solution might be to convert from UTF-8 to Unicode before
storing the data and then change the database scheme to Unicode char in all
fields containing strings.

I am guessing here since I do not have any idea of how the stores are
structured in slide. I you want I would be happy to do some debugging, but I
will need a short introduction to how the datastores are designed in slide.

/Jacob

-----Original Message-----
From: Oliver Zeigermann [mailto:[EMAIL PROTECTED] 
Sent: 28. januar 2004 16:40
To: Slide Users Mailing List
Subject: Re: TXFileStore and local filesystem

Jacob Lund wrote:

> Sorry about that - yes I am talking about the URI!
> 
> If I look in a record in the database, each Danish character is stored as
> two "funny looking" characters corresponding to the unescaped UTF-8
encoded
> version - so this looks correct! However when I do a propfind on the
> collection I which I place this file, then I get something like this
> /files/%C3%83%C2%B8 - and this should have been representing one Danish
> character. If I take the above and convert from UTF8 to my local, then I
get
> what is store in the database - If I then convert from UTF8 to local again
> the I get the correct Danish letter.

I could not find anything that might have converted the URI strings. 
They are just plainly filled into the SQL like in

>                         "select 1 from OBJECT o, URI u where
o.URI_ID=u.URI_ID and u.URI_STRING=?");
>                 statement.setString(1, uri.toString());

So, maybe this is a more general problem...

> I seem that slide converts the URI's from the db to UTF8, but they are
> already stored in unescaped UTF-8!

Does this happen with the file store as well?

Oliver


---------------------------------------------------------------------
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]

Reply via email to