November 15, 2005 at 8:53 am
Hi guys! I created a application before using classic ASP (www.adabpixel.com). This simple application saves arabic data, but the main problem I didnt notice is that it is saving the data in windows-1252 encoding. As a result, my data are all in unreadable format (ÇáÈßÓá ááÝäæä ÇáÑÞãíÉ). Im trying to reconstruct the whole application in .NET but the problem is I cant show the correct data. I already made my globalization settings to windows-1256 & windows-1252 (Vice Versa).
Is there a way I can change the encoding through T-SQL? I even tried copying it to another database with arabic as its standard format.
Hoping for your immediate reply on this matter.
November 18, 2005 at 8:00 am
This was removed by the editor as SPAM
November 21, 2005 at 12:18 pm
You could try the bulk copy and set the codepage there.
February 9, 2006 at 1:24 pm
If you write the raw data into a text file, you can use iconv to do a simple conversion.
Check that your iconv supports the proprietary Microsoft Arabic codepage, if you want that one, like so:
$ iconv -l | grep 1256
CP1256 MS-ARAB WINDOWS-1256
Aha, my iconv supports the proprietary Microsoft page.
So, cat YourData.txt | iconv -f CP1256 -t UTF-8 > YourData_fixed_UTF8.txt
and you should get a nice UTF-8 version (UTF-8 is the version of Unicode used mostly on the Internet).
Or, if your source was actually encoded in the proprietary Microsoft DOS Arabic codepage, 720, use -- well, my iconv doesn't support 720, so I'm not sure.
Microsoft has a beta for Arabic codepage conversion
http://www.microsoft.com/middleeast/arabicdev/beta/converter/
but it's beta, probably neither Free nor Open Source, the download does not seem to include any documentation (there is a readme which says to run the setup, which I didn't do), and my guess is it does no more (and much less) than iconv.
May 14, 2008 at 10:09 am
Years pass by months pass by ,,no one gives any straight forward answer for this Collation problem while running BCP for the error ::Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Code page 720 is not supported by SQL Server:w00t:
October 27, 2008 at 7:52 am
try to add the switch -c850 or -craw it worked for me
Good luck
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply