Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Lido
Starting Member
5 Posts |
 Posted - 2009-04-25 : 05:55:14
|
| Hello AllI am trying to read a text file into a table. this file contains norwegian letters like å and æ , but those letters are being substituted with strange symbols in the table.how can solve this problem. |
|
|
kfluffie
Posting Yak Master
103 Posts |
Posted - 2009-04-25 : 09:32:52
|
| Hi!What collation do you use on your table?(Right click on the database name and choose properties and look for collation)http://msdn.microsoft.com/en-us/library/ms143508(SQL.90).aspx |
 |
|
|
Lido
Starting Member
5 Posts |
Posted - 2009-04-25 : 17:13:47
|
| Hi It is Danish_Norwegian_CI_AS, but there are may others with Danish_Norwegian, which one can be the right one and how can I change itThanks |
|
|
|
Lido
Starting Member
5 Posts |
Posted - 2009-05-01 : 07:04:16
|
| HiProblem solvedI used the CODEPAGE paramerter with the bulk insertThanks. |
|
|
|
|
|
|
help on non english letter when reading a file