'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?
Solution 1:[1]
You can create TDengine table with 16374-bytes binary and 16374/4=4093 nchar
create table tb1(ts timestamp, vv binary(16374), nchar(4093))
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | zitsen |