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 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 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy