Re: URGENT: Collation headache

From: Hernán Castelo (hcastelo_at_cedi.frba.utn.edu.ar)
Date: 09/10/04 

Date: Fri, 10 Sep 2004 11:55:21 -0300

thanks

but i cant
change every stored procedure or query
to work that way

there must be another way 

-- 
atte,
Hernán Castelo
SGA - UTN - FRBA
  "Adam Machanic" <amachanic@hotmail._removetoemail_.com> escribió en el mensaje news:ONI3EQ0lEHA.1644@tk2msftngp13.phx.gbl...
  Look up the COLLATE keyword in BOL.
  The following example may help you:
  SELECT *
  FROM YourTable
  JOIN YourOtherTable ON LatinCharCol = SpanishCharCol COLLATE database_default
    "Hernán Castelo" <hcastelo@cedi.frba.utn.edu.ar> wrote in message news:el91QK0lEHA.2020@TK2MSFTNGP09.phx.gbl...
    hi
    i was exported the old DB
    to a new DB
    the old has collation -- SQL_Latin1_General_CP1_CI_AS
    and the new figures like -- Modern_Spanish_CI_AS
    seems like objects inside the new DB
    it left with the old collation . . .
    now, for example
    when i do a Join by a char(2)
    i get an error . . .
    please, it is URGENT!
    how can i modify all objects in the new DB,
    to point to the collation of the new DB
    (Modern_Spanish_CI_AS)
    thanks
    -- 
    atte,
    Hernán Castelo
    SGA - UTN - FRBA

Relevant Pages
Loading