468,291 Members | 1,604 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,291 developers. It's quick & easy.

special caracters while importing data with DTS from MyODBC

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
1 3974
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

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Psykotik | last post: by
4 posts views Thread by Ricardo Jesus | last post: by
reply views Thread by Bruno Batarelo | last post: by
7 posts views Thread by Mindy Geac | last post: by
1 post views Thread by Fabiano | last post: by
7 posts views Thread by arno | last post: by
1 post views Thread by natural | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.