|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
December 2nd, 2003, 02:58 PM
|
|||
|
|||
|
Collation Conflict
I am getting the following error on a SQL Server with collation type of "SQL_Latin1_General_CP1_CS_AS" and all my tables are of the collation type of "Database_Default". The error is
Implicit conversion of varchar value to varchar cannot be performed because the collation of the value is unresolved due to a collation conflict. Any suggestion besides manually changing the collation setting of hundered of my tables?
|
|
#2
December 22nd, 2003, 12:48 AM
|
|||
|
|||
Collation Conflict
For implicit conversion of varchar value to varchar do the following:
Cast(Field_Name As Varchar) COLLATE <Collation Name> Ex: ISNULL(CAST (surname AS VARCHAR) COLLATE SQL_Latin1_General_CP1_CI_AS,'')
|
|
| Viewing: ASP Free Forums > Database > Microsoft SQL Server > Collation Conflict |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
