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 |
|
smithanataraj
Starting Member
2 Posts |
 Posted - 2007-08-30 : 02:54:11
|
| Issues faced with the handling of Locale Specific formats during Data Migration from a database with a different Locale setting.Problem: I need to import data from a Finnish database into a Danish one. The problem is with the decimals - the decimal separator in Danish is a comma(and vice versa - the thousands separator is a dot) and in Finnish it is the usual dot(and the thousands separator is a comma).I have the data in CSV files and when I import these into the Danish Database data gets lost because the danish database intereprets the comma and dot in the opposite ways.Any idea how this could be handled... Thanks in advance!! |
|
|
|
|
|
Locale Specific Formats and Data Migration