sql language problem - Visual Basic .NET

Ivan V via DotNetMonster.com

Dear All:

I am not sure this is the right place to ask this question, but I hope
someone can help me out of that. I have a set of data which is in dbf format
and need to import into my SQL2000 server. The langage in the dbf files is
Protuguese, and after I finish my import into SQL server, the characters
changed into some monster characters, but not the Portuguese. Anyonme knows
what I need to do throughout the import process?? Thanks for all your
attention!

Best rgds,
Ivan Vong
--
Message posted via http://www.dotnetmonster.com

Nov 21 '05 #1

Subscribe Post Reply

1068

Bernie Yaeger

Hi Ivan,

How did you do the import? You may have used bulk copy, but I'd recommend
you build your own routine, connecting to the table using the odbc driver
and then adding rows sequentially. It won't take long but you'll be able to
control things more precisely.

HTH,

Bernie Yaeger

"Ivan V via DotNetMonster.com" <fo***@DotNetMonster.com> wrote in message
news:53***********@DotNetMonster.com...

Dear All:

I am not sure this is the right place to ask this question, but I hope
someone can help me out of that. I have a set of data which is in dbf
format
and need to import into my SQL2000 server. The langage in the dbf files is
Protuguese, and after I finish my import into SQL server, the characters
changed into some monster characters, but not the Portuguese. Anyonme
knows
what I need to do throughout the import process?? Thanks for all your
attention!

Best rgds,
Ivan Vong
--
Message posted via http://www.dotnetmonster.com

Nov 21 '05 #2

Cor Ligthert [MVP]

Ivan,

A strange problem, Portugese is a language that is using the 1252 character
code page, the same as AFAIK every Latin or Germanic language. There should
be not any problem.

Can you describe what is maybe special.

Cor

"Ivan V via DotNetMonster.com" <fo***@DotNetMonster.com> schreef in bericht
news:53***********@DotNetMonster.com...

Dear All:

I am not sure this is the right place to ask this question, but I hope
someone can help me out of that. I have a set of data which is in dbf
format
and need to import into my SQL2000 server. The langage in the dbf files is
Protuguese, and after I finish my import into SQL server, the characters
changed into some monster characters, but not the Portuguese. Anyonme
knows
what I need to do throughout the import process?? Thanks for all your
attention!

Best rgds,
Ivan Vong
--
Message posted via http://www.dotnetmonster.com

Nov 21 '05 #3

Similar topics

Andreas' practical language comparison

by: Andreas Koch | last post by:

Hi all, i started a little "practical language comparison" - practical in the sense that i compare how actual distributions and versions and their libraries (not abstract language...

Python

134

Why C Is Not My Favourite Programming Language

by: evolnet.regular | last post by:

I've been utilising C for lots of small and a few medium-sized personal projects over the course of the past decade, and I've realised lately just how little progress it's made since then. I've...

C / C++

language spec newsgroup

by: Kamen Yotov | last post by:

i have raised this question before, but i can't help it doing it again! why there is no separate newsgroup discussing the c#language, not the .net framework, visual c# etc. i am not that...

C# / C Sharp

Verifiable methods and C# language rule about local variable

by: Edward Yang | last post by:

A few days ago I started a thread "I think C# is forcing us to write more (redundant) code" and got many replies (more than what I had expected). But after reading all the replies I think my...

C# / C Sharp

how to "see" click event from a usercontrol

by: JohnR | last post by:

In it's simplest form, assume that I have created a usercontrol, WSToolBarButton that contains a button. I would like to eventually create copies of WSToolBarButton dynamically at run time based...

Visual Basic .NET

"The World's Most Maintainable Programming Language"

by: John Salerno | last post by:

There is an article on oreilly.net's OnLamp site called "The World's Most Maintainable Programming Language" (http://www.oreillynet.com/onlamp/blog/2006/03/the_worlds_most_maintainable_p.html). ...

Python

669

What is Expressiveness in a Computer Language

by: Xah Lee | last post by:

in March, i posted a essay â€œWhat is Expressiveness in a Computer Languageâ€, archived at: http://xahlee.org/perl-python/what_is_expresiveness.html I was informed then that there is a academic...

Python

Language standard: the least common denominator vs. utility

by: David Mathog | last post by:

One thing that keeps coming up in this forum is that standard C lacks many functions which are required in a workstation or server but not possible in an embedded controller. This results in a...

C / C++

Language of a web site in ASP.NET

by: ThunderMusic | last post by:

Hi, Ok, I find myself having a lot of troubles with URL Rewriting and I've seen on the net that in some situations, indexers have difficulty indexing sites because of some flaws in the url...

ASP.NET

definition of a highlevel language?

by: notnorwegian | last post by:

(might not be the right forum for this but...) what is the definition of a highlevel-language? well there isnt one specifically and wikipedia and the like gives just a very general description...

Python

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

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...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General