special caracters while importing data with DTS from MyODBC

Matthias HALDIMANN

When importing data into MS SQL Server 2000 from a MyODBC (v3.51) data
source using Data Transformation Services, special characters like öäüéàè
are not imported correctly. However, when the MyODBC data source is used in
any other program like Access, Excel etc. it works fine.

Does anyone have any experience with this? Any hint to solve this problem
would be very much appreciated!

Matthias Haldimann

Jul 20 '05 #1

Subscribe Post Reply

4200

Erland Sommarskog

Matthias HALDIMANN (ma****************@epfl.ch) writes:

When importing data into MS SQL Server 2000 from a MyODBC (v3.51) data
source using Data Transformation Services, special characters like
öäüéàè are not imported correctly. However, when the MyODBC data source
is used in any other program like Access, Excel etc. it works fine.

Does anyone have any experience with this? Any hint to solve this problem
would be very much appreciated!

I don't know what MyODBC is, but it sounds like someghing that comes
with MySQL. Nor do I know DTS very well...

But since I usually take a stab at charset issues....

1) What datatype are the target columns in SQL Server? char, nchar?
2) What collation do the columns have? (You see this with sp_help)
3) In what way are the characters wrecked. That is, which characters
do you get instead? If you get non-ASCII characters, it might be
a good idea to post a screen-shot on a web site and give a link.
--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Jul 20 '05 #2

Similar topics

cookie and special caracters probs

by: Psykotik | last post by:

Hello, I've two problems with php. My spec : Windows XP SP1, KFWS 2.2.0, IE 6 SP1, PHP 4.3.3. Web server is "KF web server", a server very very user friendly (HTML interface), and which...

PHP

Check string for special characters

by: Ricardo Jesus | last post by:

I'm reading an XML document and creating a CMS Posting for eacho specific node but i'm trying to save the posting using the title as Posting.Name. For this to work i have to remove all special...

.NET Framework

Timestamp problems when importing mysqldump data

by: Bruno Batarelo | last post by:

Greetings for a while I simply can not import properly timestamp data back to database. I dump all databases with mysqldump --opt --all-databases > backup.sql and backup file is correctly...

MySQL Database

Delete multiple spaces and special characters

by: Mindy Geac | last post by:

Is it possible to delete special caracters from a string and multiple spaces? When the input is : "a&*bbb cc/c d!d" I want the result : "abbb ccc dd" thnx. MJ <?php

PHP

Replacing Special Caracters

by: Fabiano | last post by:

Please, i got an XML String that contains some special caracters like linefeed, tab and others. How can i replace this chars? Can i use an ASCII value at the XXX.replace() method? Tks in...

C# / C Sharp

Problem with asp:SqlDataSource LIKE condition with acute caracters

by: alain.hogue | last post by:

I have a table "tblCards" with a field "Titre" that contain french words (Hébert, Gagné, Hélène, etc....) in an database with SQLEXPRESS 2005. I have used the asp:SqlDataSource to filter the...

ASP.NET

RegExp and special caracters

by: arno | last post by:

Hi, I want to search a substring within a string : fonction (str, substr) { if (str.search(substr) != -1) { // do something } }

Javascript

How to upload form data containing special characters correctly?

by: Wim Cossement | last post by:

Hello, I was wondering if there are a few good pages and/or examples on how to process form data correctly for putting it in a MySQL DB. Since I'm not used to using PHP a lot, I already found...

PHP

256 Caracters

by: natural | last post by:

Good Day. I am currently via Form send data to a word template.. I have about 150 bookmarks in a word document which was previously imported via a simular document. and appended into my DB. The...

Microsoft Access / VBA

Windows 11 and Access Combo Box Issue

by: DJRhino | last post by:

Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

Microsoft Access / VBA

Access Europe meeting on Wed 4 Oct - The future of Access

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...

Microsoft Access / VBA

Can faster file sharing be achieved by connecting computers simultaneously via WiFi and LAN cables

by: tracyyun | last post by:

Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...

Networking - Hardware / Configuration

Energy Model code modification to account for year dependent interest rate

by: giovanniandrean | last post by:

The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...

Python

Send Current Object to PDF

by: NeoPa | last post by:

Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...

Microsoft Access / VBA

VBA Class Basics

by: NeoPa | last post by:

Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...

Microsoft Access / VBA

Access Europe Meeting - Wed 1 Nov - Using SQL Server skills to extend Access

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...

Microsoft Access / VBA

Finding a record, and then saving a new record after the record has been amended.

by: nia12 | last post by:

Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...

Microsoft Access / VBA

Take a Database to the Next Level

by: GKJR | last post by:

Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

Microsoft Access / VBA