I attached the C# code of the test application including the SQL command to create a test table

It works if I use an nchar column, but I know it is possible to store the data in a varchar column without loss of data, because this is done somehow from a C++ application using ODBC.

So I want to know how to do it while using a varchar column.

Thanks,

Martin