COLLATION PROBLEM CAN ANY ONE HELP

hI ADAM :
let me more explain it i have the data on a SQL server with latin collation
data is in other language so when u connect to the server you will see the
data like garbae but i can retrive the data using cold fusion (

Now i have a new database structure to apply and it's in another collation
so Ican't import the data in the correct shape (

Thanx for ur response

"Adam Machanic" wrote:

 > What does "can't get the data" mean? What tool(s) are you using and what
 > errors are you getting?
 >
 > --
 > Adam Machanic
 > SQL Server MVP
<font color=purple> > <a style='text-decoration: underline;' href="http://www.sqljunkies.com/weblog/amachanic</font" target="_blank">http://www.sqljunkies.com/weblog/amachanic</font</a>>
 > --
 >
 >
 > "Rani" <Rani.DeleteThis@discussions.microsoft.com> wrote in message
 > news:C459D539-898F-4727-8FC4-641FADB8444E@microsoft.com...
  > > Hello every one :
  > > This is my case : I have a Latin collation database that contains data in
  > > another sorting order using the enterprise manager it looks like garbage
  > > mining data in ASP it looks ok my problem that i'm doing a data transform
 > to
  > > another database with another collation !!! I can't get the data please
 > help
  > > me it's urgent
  > >
  > > thanks and best regards
  > > --
  > > Mirror Mirror On The Wall Who Is The Master Of Them ALL
 >
 >
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: COLLATION PROBLEM CAN ANY ONE HELP 

"Rani" <Rani.TakeThisOut@discussions.microsoft.com> wrote in message
news:773B1733-68EE-4C15-8422-EBA3ABC424F0@microsoft.com...
 >
 > Now i have a new database structure to apply and it's in another collation
 > so Ican't import the data in the correct shape (

Are you using DTS? Some other tool? And are you getting an error, or
is the data just not coming over properly?


--
Adam Machanic
SQL Server MVP
<a style='text-decoration: underline;' href="http://www.sqljunkies.com/weblog/amachanic" target="_blank">http://www.sqljunkies.com/weblog/amachanic</a>
--<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: COLLATION PROBLEM CAN ANY ONE HELP 

Hi adam :

Yes i'm using DTS no am not gettign any error the data is not comming probaly

thank u

"Adam Machanic" wrote:

 > "Rani" <Rani DeleteThis @discussions.microsoft.com> wrote in message
 > news:773B1733-68EE-4C15-8422-EBA3ABC424F0@microsoft.com...
  > >
  > > Now i have a new database structure to apply and it's in another collation
  > > so Ican't import the data in the correct shape (
 >
 > Are you using DTS? Some other tool? And are you getting an error, or
 > is the data just not coming over properly?
 >
 >
 > --
 > Adam Machanic
 > SQL Server MVP
<font color=purple> > <a style='text-decoration: underline;' href="http://www.sqljunkies.com/weblog/amachanic</font" target="_blank">http://www.sqljunkies.com/weblog/amachanic</font</a>>
 > --
 >
 >
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: COLLATION PROBLEM CAN ANY ONE HELP