SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Other Forums
 Other Topics
 No criss cross values of varchar & nvarchar values
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

vaishjan
Starting Member

8 Posts

Posted - 12/15/2004 :  08:51:29  Show Profile  Reply with Quote
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

USA
7423 Posts

Posted - 12/15/2004 :  09:29:49  Show Profile  Visit jsmith8858's Homepage  Reply with Quote
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 - 12/15/2004 :  09:50:47  Show Profile  Reply with Quote
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

USA
7423 Posts

Posted - 12/15/2004 :  09:58:26  Show Profile  Visit jsmith8858's Homepage  Reply with Quote
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

Sweden
3279 Posts

Posted - 12/15/2004 :  11:44:51  Show Profile  Reply with Quote
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 - 12/15/2004 :  23:51:06  Show Profile  Reply with Quote
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

USA
15678 Posts

Posted - 12/16/2004 :  06:33:01  Show Profile  Visit robvolk's Homepage  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.67 seconds. Powered By: Snitz Forums 2000