Problem with cfcontent and charset SHIFT_JIS

[Ellis75]

I moved my site from CF 5 to CF MX 6.1 ( 6,1,0,63958) and as many I have
trouble displaying page in japanese (it was working fine on CF 5). I followed a
technote here and used :
<cfcontent type="text/html; charset=SHIFT_JIS"> as advised but know I get this
error :
sun.io.CharToByteJIS0208.getIndex1()[S

(My java vesion is 1.4.2)

Any help warmly welcome...

[PaulH]

search your cf install dir. if you find a file i18n.jar, delete it.

[Ellis75]

Thank's for your help Paul !

I removed the i18n.jar and I don't have the error anymore.

But I still can't display correctly shift_jis text like I did with CF5.

Without cfcontent (the page is automatically set to utf-8 by ColdFusion), I
get :
?|???^??

Now with a <cfcontent type="text/html; charset=SHIFT_JIS"> I get :
?|???^??
(The page encoding shows as shift_jis)

Using CF5 I get japanese characters.

So I decided to convert all my japanese info in SQL Server 2000 into utf-8,
but I didn't find yet how to automate the process...
What I was able to do is :
On the CF5 box, I can display my text in japanese. If I copy some japanese
text from my browser window, and paste it in another browser window in a form
generated by the CFMX box, and store it in MSSQL 2000 using a query like this :
update mytable set mycolumn=N'#japanesefield#' where id=#form.id#
it works (text appears in japanese when browsing the database with enterprise
manager, and I'm able to display japanese text in utf-8 pages displayed by
CFMX).

I would like to avoid copy/pasting every data on by base, how should I proceed
?

[PaulH]

the cheapest way i think is to create a page on your cf5 box that dumps out
your existing data. call that from your mx box (via cfhttp) using a page that
takes that data and re-inserts into your sql server.

[Ellis75]

Many thanks Paul, I did what you suggested and was able to convert all my data !

Everything is working fine now, thanks again !