Subject | Re: How to enable logging in JayBird |
---|---|
Author | Roman Rokytskyy |
Post date | 2003-03-05T12:30:24Z |
Hi,
logging enabled in log4j configuration.
inserting/updating more than 255 characters, that's exactly the
message you will get.
VARCHAR(255) defines a character column that can contain strings,
length of which is not more than 255 characters, but can be less.
CHAR(255) defines a character column that contains strings, length of
which is exactly 255 characters, shorter strings are padded with
spaces to get specified length.
If you need a string that can grow, use BLOB SUB_TYPE 1, this is
equivalent to MEMO type.
Best regards,
Roman Rokytskyy
> I want to enable logging via log4jUse -DFBLog4j=true option when starting JVM. Also be sure to have the
> what parameters I must pass to jaybird driver to enable this feature
logging enabled in log4j configuration.
> Actually I am tracing a problem with borlands db componentsIf your column is defined as VARCHAR(255) and you are
> every update or insert containing table columnt varchar which length
> is more than 255 characters fail complaining about truncating
inserting/updating more than 255 characters, that's exactly the
message you will get.
VARCHAR(255) defines a character column that can contain strings,
length of which is not more than 255 characters, but can be less.
CHAR(255) defines a character column that contains strings, length of
which is exactly 255 characters, shorter strings are padded with
spaces to get specified length.
If you need a string that can grow, use BLOB SUB_TYPE 1, this is
equivalent to MEMO type.
Best regards,
Roman Rokytskyy