...

View Full Version : MS SQL Server, varchar only returns 255 chars



bcarl314
11-07-2003, 01:54 PM
I'm running a SQL Server with PHP (this host doesn't have mySQL) and I'm running into a problem with the varchar field.

I've got a table with varchar(5000) (because SQL Server lets you do that ) because I want to be able to select DISTINCT resutls.

SQL Server does not allow distinct to be used on a TEXT field, thus the varchar(5000).

Now, when I query the results using mssql_fetch_assoc(), I only get the first 255 chars of that field.

MY QUESTION:
Is there any way to get the entire result back or is there a way in SQL server to select unique records from a TEXT field?

Thanks

firepages
11-07-2003, 04:32 PM
selecting distinct on a fieldset of that size would effectively kill your DB anyway ... better off when you add the data to the DB do a checksum ,eg

<?php $check = MD5($text);?>

and stick that in a seperate field for selecting distinct, your DB will love you for it I promise ;)



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum