Oracle Pound Sign Puzzle
Posted on 2004-08-19
We have some string data which gets inserted into another table as VARCHAR2(24). This is RPAD'ed to 24 characters and concatonated to another field, defined as VARCHAR2(5), and an attempt is then made to insert it into a final table defined as VARCHAR2(29). All's well until multi-byte characters such as '£' enter the equation, whereby the statement fails with "ORA-01401: inserted value too large for column"
I'd quite like to leave the program alone and ask our DBA to set up the NLS (?) environment to treat £'s as single-byte characters. I've tried setting NLS_LANG on the command line in UNIX but this seems to have no affect. Try inserting a '£' into a VARCHAR2(1) field as a test.