IDS Forum

Re: Informix 12 Unicode

Posted By: Fernando Nunes
Date: Wednesday, 22 October 2014, at 5:30 a.m.

In Response To: Re: Informix 12 Unicode (MATTI JAATINEN)

Yes... My 3rd question was not clear.
But I think we manage to establish a couple of things:

1- Informix does nto report the real number of chars you can store in a
column, because that's undefined. It does not guarante the "char
allocation". Only "byte" allocation
2- This makes programer's life harder

I would say this could be translated in a clear requirement:

"Informix should allow and guarantee character allocation for variable
length character set codes"

To be honest I think this would be very hard to implement and would require
radical changes in the code. But that's not up to me to decide.... You
could create an RFE for that and see what happens. And for VARCHARs I think
we would easily hit the maximum limit (255).
Regards.

On Wed, Oct 22, 2014 at 6:50 AM, MATTI JAATINEN <matti.jaatinen@norelco.fi>
wrote:

> Hi,
>
> "But It's not clear to me
> what are the real requirements and complains..."
>
> It is just that i am bit frustrated pecause i
> did research and tested informix and did not find way to make informix
> report
> logical character length and
> now i know it's impossible. So im bit of relieved but.... no good.
>
> 1)
> Yes, i tested bit further SQL_LOGICAL_CHAR and it did not resolve the
> problem.
> Example SQL_LOGICAL_CHAR is 3 make query "select 'test' AS test,* from
> eka;"
> We have no clue what is the length of column test.
> SQL_LOGICAL_CHAR is useless in my case.
>
> 2)
> We have kind of RAD(Rapid Application Development)-tool which we use to
> develop GUIs;
> the tool gets field length from prepared SQL-statements. This information
> can
> be
> used to prevent user from flooding the data. The tool uses logical
> character
> length, not the
> character byte size.
>
> 3)
> Not understood the question.
>
> 4)
> If the informix could report the logical character length, the program
> could
> notify the user that there is no enough space for what he's putting into
> program.
>
> 5)
> Our idea was that we could put the cyrillic texts in our database, every
> single character
> is at leat 2-bytes, then the chinese 3-bytes. This means that programmer
> have to manually control how many characters he allows to put into field.
> Again
> this is more work for him.
>
> So Informix canno't produce the information about logical character length.
> This is the information which i came here to ask, pecause i did myself try
> to
> find way to make informix report
> actual logical character length but now i know iformix canno't do it.
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--
Fernando Nunes
Portugal

http://informix-technology.blogspot.com
My email works... but I don't check it frequently...

--001a113f7d5ea24d9c0505ff9985

Messages In This Thread

• Informix 12 Unicode
  MATTI JAATINEN -- Tuesday, 21 October 2014, at 5:34 a.m.
  • Re: Informix 12 Unicode
    MATTI JAATINEN -- Tuesday, 21 October 2014, at 9:16 a.m.
    • Re: Informix 12 Unicode
      MATTI JAATINEN -- Tuesday, 21 October 2014, at 9:46 a.m.
      • Re: Informix 12 Unicode
        Fernando Nunes -- Tuesday, 21 October 2014, at 11:15 a.m.
        • Re: Informix 12 Unicode
          Fernando Nunes -- Tuesday, 21 October 2014, at 11:58 a.m.
          • Re: Informix 12 Unicode
            MATTI JAATINEN -- Wednesday, 22 October 2014, at 1:50 a.m.
            • Re: Informix 12 Unicode
              Martin Fuerderer -- Wednesday, 22 October 2014, at 3:56 a.m.
              • Re: Informix 12 Unicode
                MATTI JAATINEN -- Wednesday, 22 October 2014, at 4:14 a.m.
                • Re: Informix 12 Unicode
                  Martin Fuerderer -- Wednesday, 22 October 2014, at 6:41 a.m.
                  • Re: Informix 12 Unicode
                    Fernando Nunes -- Wednesday, 22 October 2014, at 7:50 a.m.
                    • Re: Informix 12 Unicode
                      Fernando Nunes -- Wednesday, 22 October 2014, at 9:33 a.m.
                  • Re: Informix 12 Unicode
                    Fernando Nunes -- Wednesday, 22 October 2014, at 9:24 a.m.
                    • Re: Informix 12 Unicode
                      MATTI JAATINEN -- Thursday, 23 October 2014, at 1:11 a.m.
            • Re: Informix 12 Unicode
              Fernando Nunes -- Wednesday, 22 October 2014, at 5:30 a.m.
  • Re: Informix 12 Unicode
    Fernando Nunes -- Tuesday, 21 October 2014, at 9:58 a.m.
    • Re: Informix 12 Unicode
      MATTI JAATINEN -- Tuesday, 21 October 2014, at 10:13 a.m.
      • Re: Informix 12 Unicode
        Fernando Nunes -- Tuesday, 21 October 2014, at 11:07 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.