UNICODE->S-JIS(Japanese Charactor Set)

#1

Hi All.
I need a help.
I have a SQL2000 SP3 on Windows2003 (English) and I am trying to export an
Unicode base table into a S-JIS base csv file.
Using dts, I can choose only UNICODE , ANSI or OEM..
Is there anyway to convert it to S-JIS (Japanese Standard) ??
Thanks.
Aki

#2

On Tue, 13 Jul 2004 10:43:55 -0700, "Aki Nomura" wrote:

Quote:

I have a SQL2000 SP3 on Windows2003 (English) and I am trying to export an
Unicode base table into a S-JIS base csv file.
Using dts, I can choose only UNICODE , ANSI or OEM..
Is there anyway to convert it to S-JIS (Japanese Standard) ??

I think you'd be better served looking at bcp for this, as you can
specify the exact codepage.

cheers,
Ross.
--
"There is more to life than simply increasing its speed." - Mahatma Gandhi

#3

"Aki Nomura" wrote:

Quote:

Hi All.
I need a help.
I have a SQL2000 SP3 on Windows2003 (English) and I am trying to export an
Unicode base table into a S-JIS base csv file.
Using dts, I can choose only UNICODE , ANSI or OEM..
Is there anyway to convert it to S-JIS (Japanese Standard) ??

Aki,
If you change the Default Code Page (in Control Panel/Regional Options)
to Japanese, then the ANSI code page becomes S-JIS.
Regards,
Jonathan

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

UNICODE->S-JIS(Japanese Charactor Set)

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

UNICODE->S-JIS(Japanese Charactor Set) - 07-13-2004 , 12:43 PM

Re: UNICODE->S-JIS(Japanese Charactor Set) - 08-09-2004 , 05:42 AM

RE: UNICODE->S-JIS(Japanese Charactor Set) - 09-21-2004 , 12:11 AM