CODEWITHSUNDEEP
asp.netsqltextboxhebrew
Oshrib
Oshrib

Reputation: 1900

INSERT from textbox to sql get question marks

I have site in asp.net 4 and in hebrew language.

When the site was in my computer - everything works great...

After i've been uploaded the site to WINHOST servers, when i enter value in hebrew on the text-box - the sql fields get question marks... like: ????

it's important to say that it's not my first website on WINHOST and they works great, this it's the first time that i see that problem.

what i can to do?

I've tried to add globalization to the web config with hebrew encoding.. but it's changed nothing.

Upvotes: 0

Views: 848

Answers (2)

Oshrib
Oshrib

Reputation: 1900

The solution was N' prefix before '" + bla_string + "'

like: N'" + bla_string + "'

Upvotes: 0

Icarus
Icarus

Reputation: 63966

The issue is most likely on your database. You should use nchar, nvarchar and ntext for all character data.

Upvotes: 1

Related Questions