Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2003
    Posts
    4

    Arrow Unanswered: need text datatype to store unicode data

    I have a requirement where in I need to store text data that has embedded unicode data (special currency symbols) in to the database table.

    UNICHAR and UNIVARCHAR data have length limitations (max 255).
    The text data I get is more than 255 characters.

    What datatype I need to use to store this unicode text ?

    Is there a UNITEXT datatype available in sybase 12.5 ASE ?

    The sybase version I am using is ASE 12.5 on solaris 8. Default charset is utf8. Sort Order is utf_nocase.

  2. #2
    Join Date
    Dec 2002
    Posts
    104

    Re: need text datatype to store unicode data

    Originally posted by vbm
    I have a requirement where in I need to store text data that has embedded unicode data (special currency symbols) in to the database table.

    UNICHAR and UNIVARCHAR data have length limitations (max 255).
    The text data I get is more than 255 characters.

    What datatype I need to use to store this unicode text ?

    Is there a UNITEXT datatype available in sybase 12.5 ASE ?

    The sybase version I am using is ASE 12.5 on solaris 8. Default charset is utf8. Sort Order is utf_nocase.
    what is the logical page size of ur server as in sybase12.5 ASE column length (unichar and univarchar length depends on column length) can be more than 255 char depending on ur logical page size of server.So, Please check for the logical page size.Increasing page size has its own bottlenecks regarding to locking .So, check them first if everything is fine then page size can be increased.

    Hope this will help u,
    Pooja

  3. #3
    Join Date
    Jul 2003
    Posts
    4

    Re: need text datatype to store unicode data

    The logical pagesize of the server is 2 Kb.

  4. #4
    Join Date
    Dec 2002
    Posts
    104

    Re: need text datatype to store unicode data

    Originally posted by vbm
    The logical pagesize of the server is 2 Kb.
    hello,

    there is no unitext type of datatype.
    have u tried using text datatype..i am not sure as never worked with unichar and univarchar

    secondly, if text is used as datatype it will always reserve a memory of 1 page atleast (if there is a value).so either 2 columns can be made and data can be split into 2 columns if data is going to be more than 255 but less than 2KB.

    just a try to a problem.
    Pooja.

  5. #5
    Join Date
    Jul 2003
    Posts
    4

    Re: need text datatype to store unicode data

    Thanks for the reply.

    I have tried declaring a column of univarchar type with length more than 255. Insert goes thru' fine, but, while retrieving, data gets truncated to 255.

    In columns of text type, unicode data will not get stored.

    So, I had thought of this alternative of splitting data into multiple columns. I was trying to find out if there any other alternative approaches.

    Looks like this is the only approach now.

    Or is there any other approach ?

  6. #6
    Join Date
    Dec 2002
    Posts
    104

    Re: need text datatype to store unicode data

    Originally posted by vbm
    Thanks for the reply.

    I have tried declaring a column of univarchar type with length more than 255. Insert goes thru' fine, but, while retrieving, data gets truncated to 255.

    In columns of text type, unicode data will not get stored.

    So, I had thought of this alternative of splitting data into multiple columns. I was trying to find out if there any other alternative approaches.

    Looks like this is the only approach now.

    Or is there any other approach ?
    yes data gets truncated after 255 while storing so one cant retrieve more than that.

    this is the only approach i know.

Posting Permissions

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