Post reply

Missing Character Set

  • October 4, 2002 at 10:15 am

    #58395

    We have 2 SQL servers which we are trying to make identical. Problem is that one server is setup to use Character Set ISO 8859-1 (Latin_1) and this Character set is not on the list of availbale Character set of the other server.

    Any idea how I can add this missing Character set.

    This is a big problem for us because it is preventing us from restoring databases from one server to the other.

    Thanks

  • October 4, 2002 at 3:39 pm

    #437866

    Both servers are SQL 2000?

    how did you set that character to one server?

  • October 7, 2002 at 3:00 am

    #437922

    I have no idea how this Character Set got installed , it was done before my time in the company. The problem is that our main server is the one with the ISO 8859 character set and I don't want to take the risk of changing this. The second server is not as critical for the company, That's why I am trying to change the character set on this one.

    Thanks

  • October 7, 2002 at 4:05 am

    #437928

    It is Latin1_General. I believe the value you see shows up when you upgrade a DB from SQL 7 or may be something to do with SP level, I foget. But Latin1_General is the same thing.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • October 7, 2002 at 4:17 am

    #437929

    Both servers are SQL 7.0.

    I will check the NT service pack on the second server as It might be SP4 (the main server has SP6).

  • October 7, 2002 at 7:53 am

    #437944

    Problem is sorted.

    When you run sp_helpsort to check which Sort Order, Collation Order and Character Set is used on a specific server, you get an answer like "Unicode Locale ID=33280, Sort Order = 50 bin_iso_1 etc...".

    I could not find these values when trying to setup the second server simply because they are not called the same during the setup process: for instance unicode 33280 is called Binary and Sort Order 50 is also called Binary.

    Thanks anyway

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

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