Hi,
If you can send me a piece of the content that I can use to reproduce the
problem I'm willing to investigate it further and provide a workaround of
some sort.
Best Regards,
Onno

On Mon, Nov 9, 2009 at 7:25 AM, <tashi...@nttdata.co.jp> wrote:

> Dear Onno
>
> Thank you for your comments.
>
> I tried your proposal.
> However, we can't resolve our problem.
>
> -Encoding issue
> We use MySQL5.0 in our system.
> However, MySQL5.0 dosen't seem to support "UTF-16".
>
>
> -The length of the file path is too long
> We confirmed thata as well.
> However, actually our file path isn't so long.
>
>
> Anyway, thanks a lot.
>
>
> > -----Original Message-----
> > From: epf-dev-boun...@eclipse.org [mailto:epf-dev-boun...@eclipse.org]
> > On Behalf Of epf-dev-requ...@eclipse.org
> > Sent: Saturday, November 07, 2009 2:00 AM
> > To: epf-dev@eclipse.org
> > Subject: epf-dev Digest, Vol 47, Issue 3
> >
> > Send epf-dev mailing list submissions to
> >       epf-dev@eclipse.org
> >
> > To subscribe or unsubscribe via the World Wide Web, visit
> >       https://dev.eclipse.org/mailman/listinfo/epf-dev
> > or, via email, send a message with subject or body 'help' to
> >       epf-dev-requ...@eclipse.org
> >
> > You can reach the person managing the list at
> >       epf-dev-ow...@eclipse.org
> >
> > When replying, please edit your Subject line so it is more specific
> > than "Re: Contents of epf-dev digest..."
> >
> >
> > Today's Topics:
> >
> >    1. Re: Are there any file limit for EPF wiki? (Onno van der Straaten)
> >
> >
> > ----------------------------------------------------------------------
> >
> > Message: 1
> > Date: Thu, 5 Nov 2009 21:37:21 +0100
> > From: Onno van der Straaten <onno.van.der.straa...@gmail.com>
> > Subject: Re: [epf-dev] Are there any file limit for EPF wiki?
> > To: Eclipse Process Framework Project Developers List
> >       <epf-dev@eclipse.org>
> > Message-ID:
> >       <be8e7a530911051237q3254c599j9dc04ab7b7958...@mail.gmail.com>
> > Content-Type: text/plain; charset="utf-8"
> >
> > Hi,
> > I don't think the folder size is a problem, I have used similar sizes
> before
> > without problems.
> >
> > Based on the error message I can think of two reasons for the error
> message
> >
> >    1. some character set encoding issue or
> >    2. the length of the file path is too long.
> >
> > I'm not sure about the encoding. For 2-byte Japanese char set you need
> > utf16, not utf8?
> >
> > I haven't tried this but maybe you could try set the encoding to utf16?
> > In *
> > config/database.yml* there should be a line *encoding: utf8* for your
> > environment. Is it possible to set that to *utf16* and try again to
> create
> > your database? I don't have utf16 on my machine so I can't test right now
> > if
> > this will work.
> >
> > You have to recreate your database of course, assuming your environment
> > is
> > 'production'.
> >
> > On Windows:
> > set RAILS_ENV=production
> > rake db:drop db:create db:migrate
> >
> > On Linux
> > export RAILS_ENV=production
> > rake db:drop db:create db:migrate
> >
> > I have to point out however that the rel_path column is varchar 220, for
> > utf16 this would imply a max file path length of 55 characters? Again,
> I'm
> > not sure, but it might turn out that the column max length is too short
> > if
> > you set to utf16 to hold the relative paths of your files.
> > HTH,
> > Onno
> >
> > 2009/11/5 <tashi...@nttdata.co.jp>
> >
> > > Dear all,
> > >
> > > Are there any file limit such as file size or Character Size for
> creating
> > > wiki or using the EPF wiki?
> > >
> > > Now, we have trouble in [Creating a Wiki].
> > > We select the baseline(folder) that has following features to update.
> > >  - Including the file which name is 2-byte.
> > >  - Folder size is bigger than 250MB (not zip)
> > >
> > > After we select the baseline and select [update now],
> > > we got following message.
> > >
> > > Mysql::Error: Incorrect string value: '\x83V\x83X\x83e...' for column
> > > 'rel_path' at row 1: INSERT INTO `pages` (`body_tag`, `created_on`,
> > > `rel_path`, `status`, `site_id`, `text`, `tool`, `updated_on`, `type`,
> > > `head_tag`, `presentation_name`, `uma_name`, `copyright_tag`,
> > `filename`,
> > > `user_id`, `treebrowser_tag`, `uma_type`) VALUES('
> > > ', '2009-11-04 18:06:23', '(PATH / xxxx_58AE806C.html', 'N.A.', 13,
> NULL,
> > > 'EPFC', '2009-11-04 18:06:23', 'BaselineProcessPage',
> > > '\n\n\n\n\n\n\n\n\n\n\n', 'AAAAAYYY [YY]', 'AAAAA', '',
> > > 'xxxx_58AE806C.html', NULL, '', 'WorkProductDescriptor')
> > >
> > >  [*] A, Y; 2byte character
> > >  Actually, [AAAAA', '', 'xxxx_58AE806C.html] was one string
> > > [AAAAA_58AE806C.html]
> > >
> > >
> > > We tried following cases.
> > >
> > > 1.One task process(1MB folder). File-name of all files are English. All
> > > contents in the all file are also English perfectly.
> > >  -Success
> > >
> > > 2.One task process(1MB folder). One file-name is
> > Japanese(2byte-character).
> > > All contents in the all file are also English perfectly.
> > >  -Error. [That message was generated.]
> > >
> > > 3.One task process(1MB folder). File-name of all files are English. One
> > > content(link information) is Japanese(2byte-character like  --/BB
> > B.html).
> > >  -Success
> > >
> > > 4.250MB folder. File-name of all files are English. All contents in the
> > all
> > > file are also English perfectly.
> > >  -Error(500 Internal Server Error)
> > >
> > >
> > > [Environment]
> > > Apache 1.3.41
> > > EPF wiki epfwiki_r1_5_20081021_0316.zip
> > > Ruby 1.8.6
> > > MySQL 5.0
> > >  Encoding ; "utf8 "
> > > _______________________________________________
> > > epf-dev mailing list
> > > epf-dev@eclipse.org
> > > https://dev.eclipse.org/mailman/listinfo/epf-dev
> > >
> > -------------- next part --------------
> > An HTML attachment was scrubbed...
> > URL:
> > https://dev.eclipse.org/mailman/private/epf-dev/attachments/20091105/d
> > fb52707/attachment.html
> >
> > ------------------------------
> >
> > _______________________________________________
> > epf-dev mailing list
> > epf-dev@eclipse.org
> > https://dev.eclipse.org/mailman/listinfo/epf-dev
> >
> >
> > End of epf-dev Digest, Vol 47, Issue 3
> > **************************************
>
> _______________________________________________
> epf-dev mailing list
> epf-dev@eclipse.org
> https://dev.eclipse.org/mailman/listinfo/epf-dev
>
>
_______________________________________________
epf-dev mailing list
epf-dev@eclipse.org
https://dev.eclipse.org/mailman/listinfo/epf-dev

Reply via email to