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 |