Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lauramayer
Posting Yak Master
152 Posts |
 Posted - 2005-11-29 : 14:01:45
|
| Afternoon,I have an update query using PHP, the back end is SQL. I had the field as a nvarchar 255 and was asked to make it bigger so I changed the field to text and now it seems to still think it's 255. I echo'd the query and the PHP part is showing everything I typed but when I query the database the extra words (over 255 chars) aren't showing up.Any thoughts would be greatly appreciated.ThanksLaura |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-11-29 : 14:14:35
|
| Why is it nvarchar in the first place?Yo could make it varchar(8000). But if needs to be in uni-code got with varchar(4000).I suspect that you might need to look at SET TEXTSIZE. Do you know what Books online is?In any event, I would not use the text data typeBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
 |
|
|
lauramayer
Posting Yak Master
152 Posts |
Posted - 2005-11-29 : 14:19:18
|
quote:
Do you know what Books online is?
Was that a slam?  Thanks for the help, I'll try that.Laura |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-11-29 : 15:16:47
|
| When you say you query the database and the extra characters aren't showing up, are you referring to Query Analyzer? If so, go to Tools..Options..Results tab. You'll need to change the value to something bigger.Tara Kizeraka tduggan |
|
|
|
lauramayer
Posting Yak Master
152 Posts |
Posted - 2005-11-30 : 06:38:29
|
| I chose text only because this is a text field and they can enter a lot of information. Obviously the wrong choice, I've changed it to varchar 8000. Okay now I can narrow down the code...Thanks Tara. Because the PHP front end was only showing 255 char amd so was the QA results I was pulling my hair out! Now I now where the problem lies. Half the battle right there.Thanks to all.Laura |
|
|
|
|
|
|
Update oddites