jana Posted November 29, 2006 Share Posted November 29, 2006 Hi to all,i hav a prob. when i fetch the data from the table to the row. it shows upto to only 255 characters. and my db is mssql server 2000. but in my db field it has more than 255 chars. can anyone help me regarding this issue? Quote Link to comment https://forums.phpfreaks.com/topic/28883-reg-type-casting/ Share on other sites More sharing options...
Orio Posted November 29, 2006 Share Posted November 29, 2006 It seems like it's a the limition with the database columns- are you sure you didnt set your table's column to 256 (or something that sets it to 256) charaters? Check what type of column it is (text, varchar, int etc') Quote Link to comment https://forums.phpfreaks.com/topic/28883-reg-type-casting/#findComment-132272 Share on other sites More sharing options...
jana Posted November 30, 2006 Author Share Posted November 30, 2006 My datatype for the field is nvarchar(1000). Quote Link to comment https://forums.phpfreaks.com/topic/28883-reg-type-casting/#findComment-132596 Share on other sites More sharing options...
jana Posted November 30, 2006 Author Share Posted November 30, 2006 i will explain my prob detailed. a string is fetched from the table from the database. the string will look like as follows.IN:- 9:01AM <BR> IN:- 9:10AM <BR> OUT:9:45PM <BR> IN:-10:02 AM Like this and so on.........i want the string splited and stored into two arrays as In[] and Out[];every In's with the time should be stored in array variable In[] and Out's in Out[].and my db is mssql server 2000i am fetching the row into a row variable as $row=msssql_fetch_row($result);and the lenghty detailed field is $row[8];$temp=$row[8];$temp=explode('<BR>' $temp);and thus $temp is an array having all in's and out's accordingly. and from here my trouble starts.i don't know how to split in's and out's seperately.can anybody help me. Quote Link to comment https://forums.phpfreaks.com/topic/28883-reg-type-casting/#findComment-132738 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.