I have SQL server.
i get the datas(japanese character) from sql server database through centos.
In sql server column datatype have varchar(10) but through centos the varchar(10) is not enough i need varchar(20) means ok.
how to get the original data ?
sql server with centos data type issue
Re: sql server with centos data type issue
you can update the length of varchar column from 10 character to 20 without losing the content like below:
ALTER TABLE YourTable ALTER COLUMN YourColumn VARCHAR (20) NOT NULL;
or leave it unspecified as
ALTER TABLE YourTable ALTER COLUMN YourColumn VARCHAR (20);
ALTER TABLE YourTable ALTER COLUMN YourColumn VARCHAR (20) NOT NULL;
or leave it unspecified as
ALTER TABLE YourTable ALTER COLUMN YourColumn VARCHAR (20);