International signs

[HrungDak]

Hi,

i have to fill a new table by filtering some other tables in my database. It all works great, but some of the records contain characters from countries like greece or russia. Those characters are not transfered properly. The table has the following definition:

CREATE TABLE [dbo].[WEB_Languages] (
[SpeechID] [int] NOT NULL ,
[Description] [nvarchar] (100) COLLATE Latin1_General_CI_AS NULL ,
[Rest] [varchar] (10) COLLATE Latin1_General_CI_AS NULL
) ON [PRIMARY]

The insert looks like the following:

INSERT INTO WEB_Sprachen (
SpeechID, Description, Rest) VALUES (
10,
N'??', -- here are the correct signs shown in my IDE
'GR'
)

In Visual Studio.Net's Debug-Window the correct characters are shown in the INSERT-command. In the table the characters are replaced by '?'.

What do i do wrong?

Alex

Alex Frankenberger
---------------------------------------
- Don't panic -