MSSQL and varchars

Author: rcooper@gisburn.com (robathome)

Hi,

Is it safe or advisable to use varchar for all string fields when using MSSQL and uniface?

 

The SQL generated by Uniface has always created CHAR string types, can these be created as VARCHAR without any issues?

 

We would want to do this for uniface 7.206, 8.4, 9.2 and 9.3?

1 Comment

  1. Hi,

    "The SQL generated by Uniface has always created CHAR string types,..."
    I'm not sure that I understand what you mean by this, but there shouldn't be any problem to use Uniface interface fex. "VC10" instead of "C10". In this case you should get varchar fields instead of char-fields.

    Actually I have recently seen some other development environments that doesn't at all "like" CHAR-fields as keys. This can be solved by using VARCHAR instead, or using surrogate (integer, binary) keys for tables.

    Although there will be some small performance decrease I don't see any problems by using VARCHAR.

    Regards RogerW.

     


    Author: rogerw (roger.wallin@abilita.fi)