CODEWITHSUNDEEP
sqldb2
kb0
kb0

Reputation: 1153

DB2 CLOB and different encodings

Is it possible to save data in CLOB column in DB2 with different encodings in the same table, for example:

create table mytable (
    mytext CLOB
);

Upvotes: 0

Views: 720

Answers (1)

mustaccio
mustaccio

Reputation: 18945

You can, of course save data with different encoding, but DB2 will treat them as if they all were in the same database-level (or column-level, depending on your DB2 version and platform) encoding, so results will be unpredictable.

If you don't want the database to mess with encoding of your textual data you should use the BLOB data type instead.

Upvotes: 1

Related Questions