Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there
For one of the columns I have not set any length for type String. I was hoping it could take max ie 65536 but instead it takes 256 length.
Does it mean that in Talend I have to explicitly mention 65536 length too?
Thanks
Harshal.
Hi Nikhil
When I was creating table I had to explicitly specify length, otherwise it was taking 256 as default one.
In this job, first component creates table for me. Wherein I had to explicitly specify 65535 else it was taking 256 as a default one.
Hi Harshal,
I was able to transmit a string data of length 1000 characters (generated from a trowgenerator) through a tmap where I had not mentioned any length in schema.
[statistics] connected R8x12ybQIxgJ5aAkml1eY1qr9sr2bJJjAD4p0fOH0EaeLUIe0k9YmvrlB9qGgiSMnooRUt5yvIzHuw8afTHjhvNNMYBY9NIWqc0qkI7erwaY23LtH3g9BLlfi04dRVthPZewUeGygRpK17Q3JBvHZEoYyYVQQMdgJYdAC4nf2mz4yKVxGNFOTzmWWeTssxs9WJMPljlCkjQUTOu98OcRGw2qXcc4CyFLWve5T834XCD1InmMYGu8BlgSWQKStG0NVCeiFcooLD2b8mwV3ezNiXjUSaxitsd9gII8JKUmo8QwdnuYhIFCA8l6JRzqbQTrwj0awbpzv0awkWoRx7rJmQZ6mbudBYbwjeutMMbOsDWiMQmUsZwvJSVBsOSuf2PQp8xtnGcgRRAbsAkSzUgEaRpTFBjyrdjquUxNMwE5X4dmfP0KTpR7fNWmLWXq5rQaMrKDLBJggj2RlzaV50XhHrpAgH71ynVQ1VWVRXPXJAPcbAMZ75D2cKzWz8lqOvEpjJ1XXTJRqFYftiBhM40LEt7BODjXIpIHvS53Ep8wBWfWo4cYbLjrL1LEw0ts3aKDN3CIgBsBtLiy6zZPPXJbaasvisijpaynndU8r1MOvwnqBRqZLF32un5U37GSFX3ALw7qz3OmNuSc4tFaEqElMd3JRHUKmeTFC4B9YNl3OEpjst9LCtLLikZIzFLYTE9ytxgrzrXwOHHWnDry2JLUMgiSXXxmcRhy5cJVUf8jQXFisdPrXrCReblmK9tMKxFqTng4lVItJAlRKVqLgQ5sOt3LYuO4vUhWxJn19ObZn0CXzFHRSXQ2euav7FzZU8Gh6TPXH8DtNbGjLkfFYPd8xGRCXmnptfdLIKYYqN7mfG19bB23UFqnzeBTwPgPWhbOf4t2WXYpF1ZyHqpLdVsDy7Li3F9n5uG8lXn2oKw88xNtrpsQw753o2A1EsbA4vOqGXkwhjzMdpyFWTdycPED1bsoHdrgDgAwRCYaWO1B [statistics] disconnected
So Talend is not limiting the string length to 256 characters.
Could you please mark the topic as resolved if the answer has helped you? Kudos are also welcome 🙂
Warm Regards,
Nikhil Thampi
Hi Nikhil
When I was creating table I had to explicitly specify length, otherwise it was taking 256 as default one.
In this job, first component creates table for me. Wherein I had to explicitly specify 65535 else it was taking 256 as a default one.