Use varchar2(4000). If it does not work, sue me. ;-) Mike On Thu, Jun 18, 2009 at 5:20 AM, ddf <orat...@msn.com> wrote:
> > > > On Jun 18, 2:42 am, manish sahu <manish.com...@gmail.com> wrote: > > HI I want to store approx 500 words in table which data type should i > > use > > > > table is having two filds > > 1) message id > > 2) Message > > message id is simple number and > > message is character approx 500 words > > And how long, on average, are these words? Normally I would think a > varchar2(2000 char) should be sufficient, but, who knows? You may > have a language where 80-character words are common, and in that > context you'd need a varchar2(4000 char) definition. Also, you may be > using a language which needs a multi-byte character set, which is all > the more reason to declare your column in terms of characters, as a > varchar2(2000) definition (which, by default, is a byte length, not > character length) may only support 1000 characters if those characters > require two bytes to represent. > > You need to provide far more information than you have if you want a > usable response. > > > David Fitzjarrell > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
