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 |
|
megetron
Starting Member
2 Posts |
 Posted - 2008-12-09 : 05:42:19
|
| Hello,I am trying to edit a record inside my database. I enter hebrew charachters there , and after the data saved it displayed on database like this: "????????" which are not the characters I enter.I am using hebrew characters. Do you have a suggestion on how to configure this to match it correctly?Thank you. |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-12-09 : 08:22:46
|
| this worked for me - I got the hebrew from a site - I don't know what it means.INSERT INTO TableName ( [textString]) VALUES (N'???? ?')the string is not displaying on this webpage but it is going into SQL Server. |
 |
|
|
alfi
Starting Member
2 Posts |
Posted - 2008-12-10 : 15:59:14
|
| You will need to declare the table collation to 1255 Hebrew instead of SQL_Latin1_General_CP1_CI_AS the default if i remember correctly, and also you need to set up Hebrew as a language on your web server at regional setting. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-12-10 : 16:15:44
|
Matbe using UNICODE is another solution?
E 12°55'05.63"N 56°04'39.26" |
|
|
|
atNurit
Starting Member
1 Post |
Posted - 2010-06-17 : 06:45:16
|
quote:
Originally posted by darkdusky
this worked for me - I got the hebrew from a site - I don't know what it means.INSERT INTO TableName ( [textString]) VALUES (N'???? ?')the string is not displaying on this webpage but it is going into SQL Server.
Thank you very much, that resloved my problem,can you also tell me how to add this 'N' to the sql statment like: UpdateCommand="UPDATE [Recommend] SET [Sender] = @Sender..."thanks, |
|
|
|
|
|
|
problem enter hebrew fonts to tables