Post reply

Cannot resolve collation thrown error

  • February 25, 2020 at 5:18 pm

    Go to Answer

    #3728667

    Hi Experts !

    The database collation was set to Latin_General_CI_AI  and change to SQL_Latin_General_CI_AI  and successfully changed in screenshot1,but issue is that while loading the data via third party application throwing me error on column there are many tables/columns in database i am not sure what to do screenshot2.

    screenshot1

    testteet

    screenshot2

    desktod

     

  • February 25, 2020 at 5:49 pm

    #3728674

    A guess, you changed the database collation but that would not affect the collation of the character columns created under the old collation.  I would start looking there.

     

  • February 25, 2020 at 6:24 pm

    #3728683

    Yes you are right  and I tired several times to change the collation but same results .

  • February 26, 2020 at 8:26 am

    This was removed by the editor as SPAM

  • March 3, 2020 at 12:41 pm

    Answer

    #3730517

    Lynn Pettis  the collation of tables was changed as i point in the post 1.

    But the Sqlsever database Views are in different Collation any advise how to set those views to one database collation ?

    • This reply was modified 4 years, 8 months ago by  smer. Reason: re-attached screenshot

    Attachments:
    You must be logged in to view attached files.

  • March 3, 2020 at 2:01 pm

    #3730562

    smer wrote:

    Lynn Pettis  the collation of tables was changed as i point in the post 1.

    But the Sqlsever database Views are in different Collation any advise how to set those views to one database collation ?

    The only thing I see in the first post is collation of the server, master database, and DBNAME database.  What are the collations of the character columns in the tables themselves?  Changing the server and database collations doesn't change the collation of the existing columns in the tables, just future columns that are defined after the changes to server or database collation.

     

Viewing 6 posts - 1 through 5 (of 5 total)

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