Hi. I'm creating a simple module that uses DAL+ along with stored procedures to insert into a SQL Server table.

The table has columns defined as nvarchar(50). In the module code, I use something like this:

Dim myString As String = "test"
DataProvider.Instance().ExecuteNonQuery("OS_AddRecord", myString)

The stored procedure does a simple INSERT INTO using the supplied nvarchar parameter -- nothing special.

When I query the table or pull records back, the only the first character of the string is actually inserted into the table. I have confirmed that only the first character of the string is making it to the stored procedure.

This sounds like a Unicode/Ansi issue, but I don't know where to look. I've followed the many basic DAL+ examples online and don't see anywhere that I have to do anything special with strings.

Thanks for your help!

 did you provide proper sizes for the nvarchar variables inside your stored procedure? I assume, if the size is not given, the default is 1 :)