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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-04-27 : 09:02:22
|
| Akila writes "I have the below text in try.txt file:-------------------------------------------Use Database1insert into Table1 (ID, Bookcode, Title, IsMasterCopy, IsCDAccomp) values (12, 'BK123', 'aäöpåÿÖÜ', 'N', 'N')I execute the following command to process the sql statement:---------------------------------------------------------------osql.exe /U user /P pwd /S ServerName /i "C:\try.txt" /o "C:\result.txt"When viewing the updated row, the title looks something like this:ƒ+=_ƒ+=_ƒ+=_ƒ+=_ƒ+=_ (this should be 'aäöpåÿÖÜ')Have tried using a Finnish-Swedish collation at column level and SQL_SwedishStd_Pref_CP1_CI_AS at the database level.Any suggestions?" |
|
|
|
|
|
Inserting non-english characters using osql utility