My ask is: derby implements the use of VARCHAR2 andThen why don't you check its manual/website :/ Google: java derby. First hit, 2 seconds of effort. How long did you take to write this post? How long did you have to wait for my less than forthcoming response?
rp0428 wrote:Hm, I never really took the time to learn but I had both the please and displeasure of working with "Oracle developers" (IE people who write piles and piles of stored procedures and write whole satellite control programs inside the DBMS) for a couple of years and they specifically used varchar2 types to work around some sort of problem I never cared to ask what it was. Perhaps some day I'll be curious enough to go look it up :)
varchar2 as far as I know is something Oracle that has something to do with character encoding.
No - it has nothing to do with character encoding. The max for SQL is 4000 bytes. The actual maximum number of characters that can be stored DOES depend on the character encoding and the actual characters. Multi-byte characters can take 4 bytes per character so that would limit the column to 1000 characters.
For Oracle both VARCHAR and VARCHAR2 are currently synonymous.