473,387 Members | 1,749 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

SQl Svr 2000 - DTS - Multilingual Data handling

nikpreek
Hi All,

I'm trying to upload a delimited text file containing french characters to SQL server 2000 using DTS. After upload, all the french characters are messed up. I though I dont have some international language support in my Db, but when I tried to update same data using UPDATE command, it works. It means, my SQL DB is able to hold french characters (nVarchar column).
When I tried to open the file in DTS editor and see the preview all the characters are messed up. e.g. "André" gets converted to "André".
I think it is something to do with "file type" property for my "Text File Data source connection" in DTS, but right now it is only giving me options of ANSI, OEM and Unicode, but none of these is working.

Please help..... its very urgent.

Thank you for your help in advance.

Rgds,
Nik
Jul 13 '07 #1
1 1818
Ho Yeah. Its ME :-)
My source file was being created as ASCII hence my DTS with ASCII was working, but with no unicode.
Now, I've changed it (text file) to be produced as Unicode. My DTS also changed to Unicode, just WORKS fine. :-)

Thanks you for reading.

Cheers,
Nik
Jul 13 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: PatchFactory Support | last post by:
Description: Professional and easy-to-use patch building environment that can help you to create instant patch packages for software and file updating. Generated patch packages are small size...
4
by: Asim Qazi | last post by:
Hi All i need to develop a multilingual s/w, i did it in ASP3.0 two years back, The main functionality i need is to put all the interface data in XSL Templates, make an XML packet in ASP, load XSL...
7
by: J?rg Keller | last post by:
Hi all I have to localize an Access 2002 application: The application using several form, tables etc. is currently only in English. Now the frontend has to be bilingual, so the user can choose...
0
by: JoanneC | last post by:
When developing dynamic web content for the global market place using ASP.NET, VB.NET and MS-Access, why should one install MS-Windows 2000 Server (mulitlanguage/multilingual), and is it necessary...
0
by: JoanneC | last post by:
When developing dynamic web content for the global market place using ASP.NET, VB.NET and MS-Access, why should one install MS-Windows 2000 Server (mulitlanguage/multilingual), and is it necessary...
4
by: Jim Adams | last post by:
Anyone have any insights into this? I'm planning an upgrade to an existing ASP.Net project to support multiple display languages (e.g. English, Spanish, ...). I'd like to use a solution that...
3
by: charliewest | last post by:
Building Multilingual Portal I have been assigned a new project to build a multilingual portal using ASP.NET and the expected Microsoft technologies including C#, ADO.NET and SQL Server 2000. ...
7
by: Luc The Perverse | last post by:
Hello! I am looking for a good way to make an application multilingual. Danish/English for now (but I don't want to preclude more than two languages eventually) Every dialog will have an option...
2
by: raju | last post by:
Hai all, I am working on the multilingual application, in asp.net. In that we are displaying contents in some other language (user selected language). In that page, we are having some textbox...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.