Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
neelank
Starting Member
2 Posts |
 Posted - 2010-04-30 : 07:43:46
|
| Hi All,I am trying to migrate data from one SQL Server 2005 database another SQL Server 2005 database using Standalone Java code (Eclipse IDE). The collation on both the database is 'SQL_Latin1_General_CP1256_CI_AS'.When the code runs the english data is migrated successfully but arabic data gets stored as junk '????????'.Please let me know where i went wrong as i am stuck for many days now.Thanks |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-04-30 : 08:29:54
|
| What is the datatype of the column?PBUH |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-05-01 : 04:19:24
|
| are you using unicode types like nvarchar?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
malpashaa
Constraint Violating Yak Guru
264 Posts |
Posted - 2010-05-02 : 04:09:20
|
| If your data is arabic and english only and your column datatype is VARCHAR then you should change the collation of your column to one the arabic collations (start with Arabic_ like Arabic_CI_AI). But if your data is not arabic and english only and your column datatype is VARCHAR then you should change it to NVARCHAR. |
|
|
|
|
|
|
Junk Arabic Data Retrieved