Post reply

select Query Error

  • September 6, 2010 at 1:45 am

    #74338

    Hi All,

    I have one table branch. in that table 3 column are SQL_Latin_General_CP1_cI_AS collation

    and the other columns are Latin_General_CP1_cI_AS collations. when i create a temp table and

    import branches table rows into temp table. Its getting the following error.

    Implicit conversion from one varchar to other varchar column cannot be performed..

    because the collation of the value is unresolved.. due to collation conflict..

    ColumnName Collation

    ID SQL_Latin_General_CP1_cI_AS

    Name SQL_Latin_General_CP1_cI_AS

    Type SQL_Latin_General_CP1_cI_AS

    Version Latin_General_CP1_cI_AS

    Email Latin_General_CP1_cI_AS

    I would appreciate.. if anybody helps me

    Thanks & Regards

    Balaji.G

  • September 6, 2010 at 2:36 am

    #1216802

    You should specifically state the collation you want to use.

    Example:

    SELECT col2 COLLATE Latin_General_CP1_cI_AS AS col1_collation FROM myTable WHERE col1=1


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply