|
|
Posted by Kimmo Laine on 12/07/05 12:40
"Steve" <googlespam@nastysoft.com> wrote in message
news:1133947419.069827.74850@z14g2000cwz.googlegroups.com...
>
>> What's the essential difference between the two field types varchar and
>> text.
>
> I guess this refers to this <mssql_field_length> and the user notes by
> "marc at NOSPAM dot durdin dot net" here: <http://uk.php.net/mssql>.
> The workaround mentioned is:
>
> -- for example, with MyVarCharField VARCHAR(1000)
> SELECT CAST(MyVarCharField AS TEXT) FROM MyTable
Yep, as I said, it gets ugly. I'd like to keep my queries as close to
"SELECT * FROM table" as I can. If I have to write each long varchar field
separately using CAST, then I'm just gonna use the text datatype.
> There will definitely be a performance hit when using TEXT instead of
> CHAR or VARCHAR. You'll have to make some tests to see if you could
> live with that.
That's what I was afraid of. I guess I just have to do like you said and do
some performance tests and see how it affects.
Thanks for replying, both you and NC
--
"En ole paha ihminen, mutta omenat ovat elinkeinoni." -Perttu Sirviφ
antaatulla.sikanautaa@gmail.com.NOSPAM.invalid
[Back to original message]
|