How many bytes does Oracle use when storing a single character?
Posted
by Mr-sk
on Stack Overflow
See other posts from Stack Overflow
or by Mr-sk
Published on 2010-05-17T16:22:43Z
Indexed on
2010/05/17
16:30 UTC
Read the original article
Hit count: 238
I tried to look here:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/datatype.htm#i3253
And I understand that I have to provide string length for the column, I'm just not able to find out how many bytes oracle uses when storing a character. My limit is 500 characters, so if its 1 byte / character, I can create the column with 500, if its 2 byte / character then 1000, etc.
Anyone have a link to the documentation or know for certain?
In case it matters, the SQL is being called from PHP, so these are PHP strings I'm inserting into the database. Thanks.
© Stack Overflow or respective owner
