thanks

I was wondering about the following choices. I'm a little new to SQL server, and I have seen this often, the N'. What is the difference between the two? I...

Sounds good to me,

Thanks

Hi there, sorry I haven't responded to you earlier, however I have tried testing it with different collations, and it still transfered the same, ie with the Hebrew characters as...

I was wondering what the difference would be to use this method, as opposed to a T-SQL method, ie not VB/dll one.

Like this one:

http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B312839#3

As well, a more general and...

I am using SQL 2K, however, since this is for an existing website, I can't make any changes to the db structure. At least I don't want to for fear...

Access is storing this (but backwards - no big deal - I'm not sure if it shows up, but it's hebrew characters):

ה"ר דוד ב"ר יוסף אבודרהם

while SQL Server is storing...

quote:

---

Have you checked the SQL database and ensured the NVARCHAR is set?

---

Yup, it is set...