Reg: Type casting

[jana]

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?

[Orio]

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')

[jana]

My datatype for the field is nvarchar(1000).

[jana]

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 2000

i 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.