SQL only likes my first letters :-(

Data showing only first letter

[gettopreacherman]

I have been pulling my hair out on this issue.

I have a form that is collecting information and INSERTing it into a SQL table via a stored proc.

When I debug I see the values coming through okay.

When I use a manual INSERT statement in SQL it works okay and throws in the full titles...

However, when I pass the information via Stored Proc the SQL table only gets the First Letter of whatever was in my variables. So it looks like this:

Name: T
Ing: L

If you had the input of: Tom and Likes (respectively)

What is going on here? I am a bit, how you say, Confus-ed...help?

[Easy_Coder]

Have you checked the column size to make it sure it didn't accidently get set to 1?

[syber]

Sounds like your parameters for the stored procedure are defined as CHAR instead of CHAR(nn).

Art