String default value if not set?

Parikhharshal — Sat, 16 Nov 2024 07:23:49 GMT

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.

Re: String default value if not set?

Anonymous — Mon, 29 Oct 2018 09:39:59 GMT

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

Re: String default value if not set?

Parikhharshal — Mon, 29 Oct 2018 22:27:43 GMT

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.

topic String default value if not set? in Talend Studio

String default value if not set?

Re: String default value if not set?

Re: String default value if not set?