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: 266

Filed under:
|
|
|

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

Related posts about Oracle

Related posts about php