character set issue we8 to UTF8
AMAL_AJan 29 2013 — edited Jan 29 2013Having datatype length issues due to character set differences between two databases one is in Western European char set (WE8) and another database is in UTF8. we bring in data from text fields, the values are getting truncated. If we have to increase the column lengths in FITS side to bring in the values without truncating, but we are not sure how much we should increase the column lengths to. is there a DBA rule of thumb, that says this many bytes in WEC translate to this many bytes in UTF 8 or something like that? in other words, is there a multiplication factor for converting WE8 text with special characters to UTF8 text