Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Char(bin) datatype in MS SQL

Status
Not open for further replies.
nengie

nengie

Programmer
Jan 7, 2002
14
0
0
TH
What datatype in MS SQL equivalent to char(bin) in VFP ? I want to maintain character data without change across code pages. TIA.
 
Sort by date Sort by votes
Binary Strings
binary
Fixed-length binary data with a maximum length of 8,000 bytes.

varbinary
Variable-length binary data with a maximum length of 8,000 bytes
Attitude is Everything
 
Upvote 0 Downvote
Unfortunately there is no &quot;persistant&quot; field type that's equivalent to char(bin) - character is all we have. However you can use the SET NOCPTRANS Command after you open a table to suppress code page changes. It's just you have to explicitly name the fields each time you open the file! <s>

Rick
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

CBellucci
  • Question
Retrieving Images (varbinary(max)) from MS SQL Server 1
Replies
3
Views
353
Chris Miller
Chris Miller
Steve Yu
  • Locked
  • Question
Data encryption at rest, VFP vs MS SQL 2
Replies
8
Views
166
Chris Miller
Chris Miller
Dan Olsson
  • Locked
  • Question
Help with SQL-Syntax (in VFP)
Replies
5
Views
153
Dan Olsson
Dan Olsson
AlastairP
  • Locked
  • Question
CHAR vs VARCHAR - no real difference size on disk 1
Replies
4
Views
100
AlastairP
AlastairP
bharons
  • Locked
  • Question
update data table sql server using form vfp 2
Replies
13
Views
214
bharons
bharons

Part and Inventory Search

Sponsor

Back
Top