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 |
|
vaishjan
Starting Member
8 Posts |
 Posted - 2004-12-15 : 08:51:29
|
| Hi, i haven't criss corss the values of varchar values & nvarchar values. i have dealt carefully & have placed the values to the right field & retrived it back to place it in the respective texarea fields |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2004-12-15 : 09:29:49
|
| We get this question all the time, did you try searching for the answer?...(sorry, that was sarcasm, I have no idea what you are trying to say. Can you try again?)- Jeff |
 |
|
|
vaishjan
Starting Member
8 Posts |
Posted - 2004-12-15 : 09:50:47
|
| Hi,Plz do help to solve.MS SQL Server 2000 database has 2 fields, one with varchar of 1000 characters & nvarchar(1000)and 1000 characters are stored in the database. i have placed the values at the respective fields varchar values to varchar field & nvarchar values to it.when i retrieve thru' select query and place it in textarea i am not receiving the entire information rather a truncated value of 256 characters for both from varchar & nvarchar field t othe corresponding textarea places. How to rectify it and get all the 1000 chars present in the database which are from varchar & nvarchar field Thnx in Advance |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2004-12-15 : 09:58:26
|
| i think you've already asked this question.SQL Server's job is to store, manipulate, and retreive data.if the product you are using to display it isn't working properly, it's not a SQL Server issue, it's an issue with that particular product. in your case, it appears to be PHP. Without more information or more specific detail, we can't really help you here.- Jeff |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2004-12-15 : 11:44:51
|
| Or if you are using QA (Query Analyzer)Go to Tools->Options->Results and choose more than 256 for "Maximum characters per column:"rockmoose |
|
|
|
vaishjan
Starting Member
8 Posts |
Posted - 2004-12-15 : 23:51:06
|
| I have all 1000 characters present in the database. but on retrival of them i'm able to get only 256 chars even after changing in Query Analyzer - Tools - Options -Results - from 256 to 10000. i do get all (1000) chars when i use select qry in Query Analyzer. but the same thing is not happening when i select it & place it in the textarea in PHP. Only 256 chars is retrieved & placed in the textarea field |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-12-16 : 06:33:01
|
| And as I suggested in your other post(s):http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=43735http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=43736This is a PHP issue, not SQL Server, and you should consult some PHP experts for their advice. |
|
|
|
|
|
|
|
|
No criss cross values of varchar & nvarchar values