VARCHAR2 only supports 7-bit characters?
545987Nov 16 2006 — edited Nov 16 2006I'm trying to migrate an existing database into Oracle. I am using standard single byte characters. I am having trouble bringing over strings that contain ASCII characters that use all 8 bits of the byte. For example, the Microsoft Word SmartQuote characters are in the 128-255 range. The Oracle VARCHAR2 seems to think my strings are longer than they really are, and won't let me insert them. Does VARCHAR2 not allow using all 8 bits of the byte? If I have a column with VARCHAR2(128) and try to fill it with 128 characters of ASCII value 255, it should work fine but does not.