[unixODBC-support] Primary Keys in OpenOffice

Nick Gorham nick.gorham at easysoft.com
Thu Dec 30 20:34:57 GMT 2004


Eric Sharkey wrote:

>Replying to myself...
>
>  
>
>>   // Wenn Feldtyp Memo oder Image, kein PrimKey
>>    
>>
>
>I guess "Memo" is what they call LONG VARCHAR.  I found this in
>fillTypeInfo:
>
>    case DataType::LONGVARCHAR:
>        aName = _rsTypeNames.GetToken(TYPE_MEMO);
>        break;
>
>Is there a reason why a LONG VARCHAR field can't be a primary key?
>
>Eric
>_______________________________________________
>unixODBC-support mailing list
>unixODBC-support at easysoft.com
>http://mail.easysoft.com/mailman/listinfo/unixodbc-support
>
>
>  
>
Not in theory, but OO may be expecting to save the value for each row's 
primary key, and as a longvarchar could be a GB in size of each row, it 
seems a reasonable cop-out.

--
Nick



More information about the unixODBC-support mailing list