Failed to execute query. Error: String or binary data would be truncated in table xdbo.user_info’, column ‘uid’

I have problem inserting values in my SQL server database on Azure, I am getting the following error:

Failed to execute query. Error: String or binary data would be truncated in table 'dummy_app.dbo.user_info', column 'uid'. Truncated value: 'u'.
The statement has been terminated.

​x
 
Failed to execute query. Error: String or binary data would be truncated in table 'dummy_app.dbo.user_info', column 'uid'. Truncated value: 'u'.The statement has been terminated.  ​

I don’t understand where I am wrong, I just created the server, and I am trying to experiment but cant fix this.

if not exists (select * from sysobjects where name='user_info' and xtype='U')

    create table user_info (

        uid varchar unique,
        name varchar,
        email varchar

    )

go;
INSERT INTO dbo.user_info(uid, name, email) VALUES('uids', 'name', 'email') go;

 
if not exists (select * from sysobjects where name='user_info' and xtype='U')​    create table user_info (​        uid varchar unique,        name varchar,        email varchar​    )​go;INSERT INTO dbo.user_info(uid, name, email) VALUES('uids', 'name', 'email') go;​

Creating the table works fine, the only thing that doesn’t work is the second command INSERT

Answer

I suspect that the reason is that you haven’t defined a lenght for varchar and it defaults to 1 as length. Therefore your value gets truncated.

Set a varchar length to something like varchar(200) and you should be good to go.

Advertisement

Answer