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 |
|
imbrod
Starting Member
10 Posts |
 Posted - 2008-10-31 : 15:34:43
|
| Hi!This is region specific issue, it's about Central European.You see, there are some specific characters in Central Europe (I'll write them here, don't know how you'll see them though: ccšdž )I have the data in MS Access database. Now, I try to copy the data into SQL Express 2005 database, using the script ("select * from..." MS Access table and "insert into..." MS SQL table)The data is copied correctly except for some of those special characters (plus their capital letters)Mind you, I have codepage=1250 in the script directive.Should I reconfigure settings in configuration manager? Or in surface area? Or install some add-on? Or something else?Please help! |
|
|
imbrod
Starting Member
10 Posts |
Posted - 2008-10-31 : 15:50:30
|
| I found out that I should change the "Collation" in SQL Express.How do I do that? |
 |
|
|
|
|
|
Central European specific characters in SQLExpress