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 |
|
youruseridistoxic
Yak Posting Veteran
65 Posts |
 Posted - 2009-03-12 : 11:34:56
|
| I have an instance of SQLServer 2K5 with a collation of Latin1_General_CI_AS.This server hosts 2 application databases, both of which contain data expressed in French characters such as é,ê, or è.The first db has a collation of Latin1_General_CI_AS, and has no problems displaying these characters.The second db originally had a collation of SQL_Latin1_General_CP1_CS_AS, and could NOT display these characters. They appeared like this --> TI have since updated the collation on DB #2 to Latin1_General_CI_AS (simply because I assumed DB #1 didn't have this issue, why not try that?), yet the issue remains.Can it be possible that 2 unique db's with the same DB collation, hosted on the same server - cannot display the same characters in kind?The vendors of DB #2 tell I've got to re-install SQLServer, but this is obviously a much larger and riskier job than I'd like to pursue.Has anyone dealt with a similar issue, and perhaps have some knowledge or advice to share?Thanks! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
youruseridistoxic
Yak Posting Veteran
65 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-13 : 13:07:59
|
| sorry didnt get that. do you mean to find out collations used by columns in db? |
 |
|
|
|
|
|
|
|
Server/Database/Column Collation Settings