KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Tip: C_STRING type is text in 4D v11 SQL
PRODUCT: 4D Developer | VERSION: 11 | PLATFORM: Mac & Win
Published On: July 2, 2008

In 4D v11 SQL, when running in Unicode mode, variables created with C_STRING have the same type as variables created with C_TEXT.

In 4D 2004, variables created with C_TEXT have the type Is Text (2) and variables created with C_STRING have the type Is String Var (24).

In 4D v11 SQL, variables created with C_TEXT have the type Is Text (2) and variables created with C_STRING also have the type Is Text (2).

Note - 4D 2004 databases that have been converted to 4D v11 SQL and are running in compatibility mode will function the same as in 4D 2004, meaning variables created with C_STRING will still have the type Is String Var (24).