Collation Problem any help

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Rani (Rani_at_discussions.microsoft.com)
Date: 02/22/05 

Date: Tue, 22 Feb 2005 13:35:14 -0800

Hello all :

My problem is like the following I have an online databse with a latin
collation, this database is using ntext and nvarchar values that was with our
previous admin ok the problem is in the data is stored should use another
collation (the arabic collation) ok ... now I want to use the data in a
database with a corrected collation the problem that I'can't use the data it
look like garbage any way I've tried the bcp command line utility the DTS
won't work as I'm moving data between diffrent collations the problem with
bcp that it force you to a row delimeter which is charcater 13 or crlf or
enter what ever u want to say okkkk we have a ntext field so any import way
won't work why?? because DTS will use the crlf for new record delimeter so
things are Scrambled and We have crlf in the ntext field , I know it looks
like a tough stuff but i do belive that togther we can help getting it out.

For microsoft staff can I know how bcp is getting the data so in worst case
I'll get the data in the same way (am a vb.net mcp)

thanks and best regards

Relevant Pages

  • Re: UTF-8 encoding in AJAX web application.
    ... you can do is set the collation. ... Sorry my mistake ther is a "ntext" type in MSSQL, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: String or binary data would be truncated. But not field length problem.
    ... Well, I don't know about the message, but encoding / collation could be ... have you tried ntext, nvarchar, etc? ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Change field collation
    ... constraints and statistics on the columns before you can alter ... There are quite a lot of caveats and you use this script at your own risk. ... Changing the collation of the existing tables is unfortunately not very ... You might consider using SEM to script out the objects in the database, ...
    (microsoft.public.sqlserver.programming)
  • Re: Changing collation -- URGENT
    ... You can use the following script to change the collations of your columns, ... duplicate primary key constraints create statements, ... Changing the collation of the existing tables is unfortunately not very ... You might consider using SEM to script out the objects in the database, ...
    (microsoft.public.sqlserver.server)
  • Re: Database collation error after moving to a remote sql server
    ... I think I'm going to try plan B: Install a second instance of SQL 2000 onto ... the remote server and set its default collation to the same as my SMS ... database, then move my db to the new instance. ... The char, varchar, text, nchar, nvarchar, or ntext system data types, ...
    (microsoft.public.sms.setup)