I tried to look here:
And I think that I have to provide the string length for the column, I just can not know how many bytes it uses during the collection of a character. My limit is 500 characters, so if it has 1 byte / character, then I can create columns with 500, if its 2 byte / character then 1000, etc.
Is there any link to the document or something to know?
If it matters, then SQL is being called by PHP, so these are PHP strings that I'm putting in the database. Thank you.
The number of bytes required to store a character depends on the character set. If you want to store 500 characters and do not know the character set of the target database, then you create columns (or variables) such as VARCHAR2 (500 CHAR ) or CHAR (500 CHAR) ).
Comments
Post a Comment