Discussion Board

Results 1 to 2 of 2
  1. #1
    Regular Contributor
    Join Date
    Apr 2006

    Max Text col length in DB

    Hi All!

    I wann know the maximum text col length in DB
    I have seen D32DBMS.H Its explains about KDbDefaultTextColLength

    I wann know the maximum limit for this.

    There is KDbMaxStrLen which is 256.

    So is 256 is also a limit for max text column length in db..?

    Even though my text column is created with lenght of 1024.. while writing to db.. app crashes with E32USER-CBase 65 if text length crosses 256 limit.

    Its irrelevant..at least at client side

    In IPC The maximum length for a generic DBMS string is 256, which might be transferred from DBMS server to the DBMS client using IPC.

    Just need confirmation from experts about max text column length

    Shilpa Kulkarni

  2. #2
    Super Contributor
    Join Date
    Jul 2006
    Oulu, Finland.

    Re: Max Text col length in DB

    The text and binary columns can only store 255 bytes, if you want to store more than 255, you can look for Long column types like LongText8 ( EDbColLongText8 ), LongText16 (EDbColLongText16) and LongBinary (EDbColLongBinary) etc..

Similar Threads

  1. Max text length limit for a pop-up.
    By ravinder007 in forum Symbian
    Replies: 1
    Last Post: 2007-09-18, 12:26
  2. Get length of a text file's content
    By kaiten-sushi in forum Symbian
    Replies: 2
    Last Post: 2006-12-17, 14:59
  3. How to change the max length of TPtr
    By rensijie in forum Symbian
    Replies: 2
    Last Post: 2006-08-13, 04:31
  4. 6681 - s60 MIDP 2.0 - item text length
    By melas21 in forum Mobile Java Media (Graphics & Sounds)
    Replies: 0
    Last Post: 2005-08-20, 23:02
  5. Replies: 0
    Last Post: 2004-11-24, 18:49

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts