Data Encoding Problem.. Need help from you guys!

  • voodzzz

    Grasshopper

    Points: 19

    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.

  • This was removed by the editor as SPAM

  • DSP-120308

    Hall of Fame

    Points: 3849

    You could try the bulk copy and set the codepage there.

  • Perry-300990

    Ten Centuries

    Points: 1371

    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.

  • suresh kumar V.c

    SSC Rookie

    Points: 32

    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:

  • nourann

    SSC Rookie

    Points: 25

    try to add the switch -c850 or -craw it worked for me

    Good luck

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply