dbptk-developer
dbptk-developer copied to clipboard
CHARACTER VARYING(2147483647)
Hi, in postgresql, the table column is defined as character varying
In SIARD package it will become
<name>Employee Name</name>
<type>CHARACTER VARYING(2147483647)</type>
<typeOriginal>varchar</typeOriginal>
<nullable>true</nullable>
This was discussed in #155. Now I found it again as I tried to deploy a SIARD file with SIARD Suite and it reports an error. DBPTK successfully creates varchar again.
Steps to reproduce: create a SIARD file with DBPTK 2.6.3. In this case, the table is empty. https://github.com/dbdipview/dbdipview/blob/master/testing/TestAndDemo4/package/TestAndDemo4.siard