Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Parikhharshal
Creator III
Creator III

String default value if not set?

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.

Labels (3)
1 Solution

Accepted Solutions
Parikhharshal
Creator III
Creator III
Author

Hi Nikhil

 

When I was creating table I had to explicitly specify length, otherwise it was taking 256 as default one.

 

0683p000009M0bG.png

 

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.

 

0683p000009M0kW.png

View solution in original post

2 Replies
Anonymous
Not applicable

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.

0683p000009M0ip.png

 0683p000009M0iu.png

 

[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

Parikhharshal
Creator III
Creator III
Author

Hi Nikhil

 

When I was creating table I had to explicitly specify length, otherwise it was taking 256 as default one.

 

0683p000009M0bG.png

 

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.

 

0683p000009M0kW.png