ISQL.EXE corrupts special characters 1

[BerndKaufmann]

I use the following script to insert the string "Test-ÄÖÜäöüß-Test" into the table Testtab.
(I am a german programmer ;-) )

DELETE FROM [dbo].[Testtab]
SET IDENTITY_INSERT [dbo].[Testtab] ON
INSERT INTO [dbo].[Testtab] ([ID], [Teststring]) VALUES (1, 'Test-ÄÖÜäöüß-Test')
SET IDENTITY_INSERT [dbo].[Testtab] OFF

If I use the SQL Query Analyzer to process the script, then the string is written correctly to the table and looks like this:
Test-ÄÖÜäöüß-Test

However if I use ISQL.EXE to process the script, then the string looks like this:
Test--Í_õ÷³¯-Test

I need to have the script runnung with ISQL.EXE.
Does anybody have a hint for me?
Many thanks in advance!

 

[yksvaan]

In the workstation's Start -> Programs -> SQL server there's Client Network Utility, in DB-Library options you can check Automatic ANSI->OEM conversion

I don't know at the moment if you can force it in connecting with ISQL.

Cheers


[blue]Backup system is as good as the latest recovery[/blue]

 

[BerndKaufmann]

BINGO - you got it !!
Thank you very much for that tip!

In fact I had to uncheck the checkbox and then it went correct.

You saved my evening!

Best wishes, Bernd Kaufmann

 

[yksvaan]

It probably has something to do also with database's collation, what's yours ?

Cheers


[blue]Backup system is as good as the latest recovery[/blue]

 

[BerndKaufmann]

The collation of my database ist "Latin1_General_CI_AS" (whatever that means ;-) )
I am not very familiar with the subject of collation.

Best wishes, Bernd