Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw
 
PerlMonks  

Re: WIN32::ODBC - text field String data, right truncation

by terra incognita (Pilgrim)
on Nov 08, 2004 at 21:38 UTC ( [id://406219]=note: print w/replies, xml ) Need Help??


in reply to WIN32::ODBC - text field String data, right truncation

Are you talking about the Text column type? That is a long character object that is stored elsewhere in the DB. The 16 is not the size of the object, but the size of the pointer to that object. As VSarkiss indicated more information woudl be really helpful.
  • Comment on Re: WIN32::ODBC - text field String data, right truncation

Replies are listed 'Best First'.
Re^2: WIN32::ODBC - text field String data, right truncation
by ikegami (Patriarch) on Nov 08, 2004 at 22:58 UTC
    Microsoft refers to VARCHAR and/or CHAR as Text, and I'd bet the OP is as well. (IIRC, Memo is what Microsoft calls TEXT fields.)
      Text is the value that is shown in the Enterprise Manager and in the . It is a column type introduced in Version 7 IIRC. Here is an excerpt from the online books.
      ntext, text, and image Fixed and variable-length data types for storing large non-Unicode and Unicode character and binary data. Unicode data uses the UNICODE UCS-2 character set. ntext Variable-length Unicode data with a maximum length of 230 - 1 (1,073,741,823) characters. Storage size, in bytes, is two times the number of characters entered. The SQL-92 synonym for ntext is national text. text Variable-length non-Unicode data in the code page of the server and with a maximum length of 231-1 (2,147,483,647) characters. When the server code page uses double-byte characters, the storage is still 2,147,483,647 bytes. Depending on the character string, the storage size may be less than 2,147,483,647 bytes. image Variable-length binary data from 0 through 231-1 (2,147,483,647) bytes.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://406219]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others chilling in the Monastery: (4)
As of 2024-04-26 06:48 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found