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 |
|
cappyoak
Starting Member
1 Post |
 Posted - 2005-08-15 : 11:42:29
|
I'm using DotNetNuke (DNN3) as a web development tool, and it doesn't install properly in Latin1_BIN collation.My Production servers which will be passed information from a remote SQL server on a Web Host (The DNN3 Machine) is in Binary Sort order. Will there be problems when information is passed between the 2?Server 1 Web Host SQL Sever 2000 SP 4 Collation - Latin1_General_CP1_CI_ASSever2Production SQLSQL Sever 2000 SP 4Colation - Latin1_BINContact information will be entered into a registration page on Server one. This will be passed programatically to Server 2 via xml and trigger workflow on that machine.Has anyone had any experience with transfering information between 2 unmatched collated SQL Servers? Is it possible? Are there Issues I should be aware of?Thanks in advance |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-08-15 : 16:36:28
|
| It's possible but can cause a lot of problems.columns that are unique on one server might not be on the other.columns that are equal on one server might not be on the other.Also cross collation queries can cause problems - I have one where the ascii value for a tab wouldn't set to the tab stop if the first character in the query - fine everytwhere else or if the databases joined were the same collation or if I used a tab rather than the ascii code.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Unmatch Collation