Scheduled_Recordings - Filename field limited to 50 characters?

[JavaWiz]

I've been having some intermittent issues with some of my scripts related to renaming. I've been looking in the DB, and I noticed that the filename field in SCHEDULED_RECORDINGS is only 50 bytes... That ends up truncating many of my recording filenames. Is that expected?
[ATTACHMENT NOT FOUND]

Code:

CREATE TABLE [SCHEDULED_RECORDING] (
    [oid] integer PRIMARY KEY AUTOINCREMENT NOT NULL,
    [name] varchar(50) NOT NULL,
    [filename] varchar(50) NOT NULL,
    [status] integer NOT NULL,
    [start_time] datetime NOT NULL,
    [end_time] datetime NOT NULL,
    [capture_source_oid] integer NOT NULL,
    [channel_oid] integer NOT NULL,
    [recurrence_oid] integer NOT NULL,
    [channel_name] varchar(50) NOT NULL,
    [event_details] varchar(50) NOT NULL,
    [failure_reason] varchar(50) NOT NULL,
    [pre_padding] integer NOT NULL,
    [post_padding] integer NOT NULL,
    [quality] integer NOT NULL
, red CHAR(1), green CHAR(1), yellow CHAR(1), blue CHAR(1));

[sub]

SQLite ignores those sizes. You can store whatever length string you want to in their varchar fields.

[sub]

From the FAQ:

(9) What is the maximum size of a VARCHAR in SQLite?


SQLite does not enforce the length of a VARCHAR. You can declare a VARCHAR(10) and SQLite will be happy to store a 500-million character string there. And it will keep all 500-million characters intact. Your content is never truncated. SQLite understands the column type of "VARCHAR(N)" to be the same as "TEXT", regardless of the value of N.

[mvallevand]

The sqlite GUI utility I use defaults to the defined values for viewing unless I change a format setting to map all varchars to 8191

Marin

[JavaWiz]

Right you are... My client (SqlLiteAdministrator) however does respect the field definitions and appears to truncate visually when displaying . Thanks.

What SQLite client do you typically use?

[mvallevand]

I use sqliteexplorer. Some people like browser adds but I vnc to my backup so I don't want the overhead of opening a browser (and keeping them update to date).

Martin

[JavaWiz]

Thanks, I'll check that out.