dbptk-developer icon indicating copy to clipboard operation
dbptk-developer copied to clipboard

CHARACTER VARYING(2147483647)

Open BorisDomajnko opened this issue 4 years ago • 0 comments

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

BorisDomajnko avatar Dec 15 '19 17:12 BorisDomajnko