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 Reply

1070

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

2024

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

7866

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

1364

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

3119

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

4236

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

2495

"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

25360

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

2448

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

1879

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

1841

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

7027

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

6899

Changing the language in Windows 10

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

Windows Server

7019

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

7067

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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

Online Marketing

4463

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

2970

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1288

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

555

php

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

166

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General