discountasp.net doesnt support hebrew or am I just being stupide?

as i said erlier , I'm using varchar
btw , i need somehow to set it to utf8 if i am not wrong
anyway , where should i enter the commend?
i tried so much around the

Alter Database [database_name] Collate utf8
or
Alter Database [database_name] Collate hebrew
but just nothing worked
or it said it locked for some reason or i dunno why

i tried to enter this action thought Visual studio query when u click on the db connection..

god , how come this is so hard -__-;;

 

Well , was just wondering..
I had programmed this site , I use varchar for the database
the problem occurs when i type in hebrew ..
when i type in hebrew and insert a data into database in discountasp.net , the data get saved as ?????? instade hebrew

while i am working at home and uploading data into a database at my local/sqlexpress it works just fine..
so i had been just wondering .. anyone can give me help for this issue? becouse the site is pretty much all in hebrew
kinda important :>
thanks all :>

 

Have you tried changing the collation of your database. Use this link which is a thread within our community forum for some guidelines in updating the collation on your database.

http://community.discountasp.net/default.aspx?f=16&m=23111


By the way, what do you have for the data type?

rcp
DiscountASP.NET
www.DiscountASP.NET

 

In order to support Unicode in a field/column (a requisite for Hebrew), you have to use nVarchar. Switch your column type to Nvarchar and that should firx your problem.