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.

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 ????

Author  Topic 

ghassan_aljabiri
Starting Member

2 Posts

Posted - 2007-12-20 : 10:16:17
hi

i use aspx pages to store data in a tabel (sql server 2005 express)

but the text data is stored as a series of question marks ("???....")

every character is replaced with a "?"

what is the problem ? how could i solve that?

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2007-12-20 : 10:18:44
Do you think you have given us enough information to help you troubleshoot this?

- Jeff
http://weblogs.sqlteam.com/JeffS
Go to Top of Page

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-12-20 : 10:19:37
Probably you are storing unicode data in non-unicode columns.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-20 : 15:30:19
Even with unicode column, have to insert unicode value with N like N'xxx...'.
Go to Top of Page
   

- Advertisement -