Character length problem in VERTICA database-CodePudding

ORACLE to VERTICA database migration data, ORACLE varchar2 (10) to the VERTICA varchar (10) why will show error character length is not enough, for advice!

CodePudding user response:

The character set has changed? Oracle is GBK, UTF8 is under the vertica?

CodePudding user response:

reference 1st floor minsic78 response:

character set changed? Oracle is GBK, UTF8 is under the vertica?

If so, be on the safe side, Chinese string field, field length should be 1.5 times under the GBK,

CodePudding user response:

Oracle is character set GBK, VERTICA didn't search query, for character set,

CodePudding user response:

reference qq_44982711 reply: 3/f

oracle character set GBK, VERTICA didn't search query for character set, and

Vertica its only, are not ripe, but the general database character set is a high probability of UTF8, try to adjust the GBK Chinese field length is 1.5 times the length of the can,

CodePudding user response:

refer to the second floor minsic78 response:

Quote: refer to 1st floor minsic78 response:

The character set has changed? Oracle is GBK, UTF8 is under the vertica?

If so, be on the safe side, Chinese string field, field length should be 1.5 times under the GBK,

The VERTICA character set default is utf8 excuse me

CodePudding user response:

reference 4 floor minsic78 response:

Quote: reference qq_44982711 reply: 3/f

Oracle is character set GBK, VERTICA didn't search query for character set, and

Vertica its only, are not ripe, but generally the database character set is a high probability of UTF8, try to adjust the GBK Chinese field length is 1.5 times the length of the can,

Ok, thank you! ~ ~ ~ ~