All character from column not getting! Any setting should i change?
-
Hello friends, I got some problem... I have table like CREATE TABLE publishers ( Name char(4) NOT NULL, ID varchar(40) NULL, City varchar(20) NULL, State char(2) NULL, Comments varchar(3000) NOT NULL ) I have some store procedure which put xml files and put that into this sql table, now problem i am facing here is that all the character from comments column i am not getting , I already increase the width of that column from varchar(1000 ) to varchar(3000) Two days before i am getting well results i.e. all the character from this perticular field(comments) and seeing that result, character in that field was just 800 to 850 approx.But now why I am getting like that??? One thing is sure the character which is coming from XML file is not more than 850.Then is there any setting should i change or by mistake changed?? Please Help me out! T.I.A Shashank
-
Hello friends, I got some problem... I have table like CREATE TABLE publishers ( Name char(4) NOT NULL, ID varchar(40) NULL, City varchar(20) NULL, State char(2) NULL, Comments varchar(3000) NOT NULL ) I have some store procedure which put xml files and put that into this sql table, now problem i am facing here is that all the character from comments column i am not getting , I already increase the width of that column from varchar(1000 ) to varchar(3000) Two days before i am getting well results i.e. all the character from this perticular field(comments) and seeing that result, character in that field was just 800 to 850 approx.But now why I am getting like that??? One thing is sure the character which is coming from XML file is not more than 850.Then is there any setting should i change or by mistake changed?? Please Help me out! T.I.A Shashank
Try nvarchar instead of varchar. Christian Graus - Microsoft MVP - C++
-
Hello friends, I got some problem... I have table like CREATE TABLE publishers ( Name char(4) NOT NULL, ID varchar(40) NULL, City varchar(20) NULL, State char(2) NULL, Comments varchar(3000) NOT NULL ) I have some store procedure which put xml files and put that into this sql table, now problem i am facing here is that all the character from comments column i am not getting , I already increase the width of that column from varchar(1000 ) to varchar(3000) Two days before i am getting well results i.e. all the character from this perticular field(comments) and seeing that result, character in that field was just 800 to 850 approx.But now why I am getting like that??? One thing is sure the character which is coming from XML file is not more than 850.Then is there any setting should i change or by mistake changed?? Please Help me out! T.I.A Shashank
check the prameters for the procedure.. they has to be the same as for the table... /M