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
-~----------~----~----~----~------~----~------~--~---
