January 4, 2009 at 4:56 am
I inseted unicode language(arabic) in varchar so it didn't bedisplayed will (it appears like ????????)
to solve that I modified the type of this column to nvarchar but I still can't read the old data any idea about that pleaase
January 4, 2009 at 5:58 am
Delete the data from the table then reinsert it.
January 4, 2009 at 7:38 am
delete and reinsert 2 thousands and more record oh, are ukiding
January 4, 2009 at 8:03 am
ali.m.habib (1/4/2009)
delete and reinsert 2 thousands and more record oh, are ukiding
If you didn’t use Unicode and you also didn’t use collation that supports working with Arabic as Ascii character, then this is your only choice. Unfortunately most times when you see question marks, it means that the server didn’t what to insert, so it inserted the question marks instead (which means that you can’t modify it to show the original data that was supposed to be inserted into the table). If you see gibberish, there is a better chance to get the data without deleting it and reinserting it.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 5, 2009 at 8:54 am
It's basically the same answer as I want to restore without a backup... you're screwed my friends. Learn and move on.
Now would be a good time to learn to automate that insert (if possible at all).
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply