error with encoding while copy records from access to sql

Last post 11-07-2009 3:58 PM by ghassan_aljabiri. 0 replies.

Sort Posts:

  • error with encoding while copy records from access to sql

    11-07-2009, 3:58 PM

     hello

    source database is maaref.mdb (access) , uploaded to the server

    destination database is ms sql server database , collation is (Arabic_CS_AI)

    i use an aspx web page to copy from the source to the destination

    the page is saved in UTF-8 , Code is VB

    every thing is goes ok , but the copied data is not copied in the appropiate encoding

    so arabic fonts are corrupted , how to adjust this?

    i changed the collation of the destination database to (Arabic_CI_AS) , but it did not work

    Regards

    GHS
Page 1 of 1 (1 items)