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 |
|
suzie
Starting Member
15 Posts |
 Posted - 2009-07-10 : 06:41:08
|
| Dear,we have a website that retrieve data in Arabic from SQL tables, using PHP code (Website is done in php code).arabic data in tables appears normally, but on the website it appears as questions Mark "?????????????"this happens after doing restore to my PC.please if any one can help me, any suggestions please...Best regards, |
|
|
znwpta
Starting Member
12 Posts |
Posted - 2009-07-10 : 10:28:41
|
| I had a similar problem once, try using cast into vchar 255 chars or w/e limit you have. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-10 : 11:14:04
|
| use nvarchar for field type. also make sure you're using collation settings that support arabic |
|
|
|
suzie
Starting Member
15 Posts |
Posted - 2009-07-16 : 06:37:58
|
| thanks for your reply, I'am using nvarchar and nchar..., and iam using the collation sql_latin1_General_cp1_CI_AS, and it was working, but now when i did restore to my PC...instead of arabic data questions mark.any help please, very important for methanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-16 : 12:33:09
|
quote:
Originally posted by suzie
thanks for your reply, I'am using nvarchar and nchar..., and iam using the collation sql_latin1_General_cp1_CI_AS, and it was working, but now when i did restore to my PC...instead of arabic data questions mark.any help please, very important for methanks
is there any changes in colation settings b/w your server and source server having this db? |
|
|
|
|
|
|
|
|
retrieving data from SQL