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.

 All Forums
 Other Forums
 Other Topics
 No criss cross values of varchar & nvarchar values

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
Go to Top of Page

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
Go to Top of Page

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
Go to Top of Page

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
Go to Top of Page

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
Go to Top of Page

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=43735
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=43736

This is a PHP issue, not SQL Server, and you should consult some PHP experts for their advice.
Go to Top of Page
   

- Advertisement -