CODEWITHSUNDEEP
tdengine
hook capt
hook capt

Reputation: 125

Is TDengine suitable to store large text fields?

I need to migrate my database from PostgreSQL to the TDengine since most of them are time-series data. But there is a text field in the table for storing large chunks of text.

May I know if TDengine is suitable to store large chunks of text with any data type? How long the maximum length of nchar is?

Upvotes: 0

Views: 56

Answers (1)

zitsen
zitsen

Reputation: 365

You can create TDengine table with 16374-bytes binary and 16374/4=4093 nchar

create table tb1(ts timestamp, vv binary(16374), nchar(4093))

Upvotes: 0

Related Questions