dbTalk Databases Forums  

Import and Export foreign characters (NON-DBCS only)

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


Discuss Import and Export foreign characters (NON-DBCS only) in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Imtiaz
 
Posts: n/a

Default Import and Export foreign characters (NON-DBCS only) - 02-28-2005 , 07:03 PM






Hi

I have a table which stores the customer information....There is a Customer
Address column defined as nvarchar(50)....Data for the table is imported
using DTS Bulk Insert from a Customer.dat file....

My question: -

1. What are the requirements for me to view the foreign characters (Arabic,
Turkish, German, Italian etc....) using an editor. What setup needs to be
done on the server where the files reside.

2. How do I make the .dat file as a unicode file ?

3. Can I see the foreign characters by a simple select in query analyzer?

4. What are the requirements to export the file to contain all those foreign
characters?

Ps: - Focus is not on DBCS characters (Kanji characters etc...)

Any help would be much appreciated.....

Thanks in advance....
Imtiaz

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.