hello guys!

i am contacting you because i have a very very big problem.
i am migrating a database from mysql to fb2, to use it in delphi 7 pro
the components that i will use to connect from delphi to fb2 are ibdac v1.10

in fact i will use embedded firebird dll

my problem is with blob. i need to have a field with "unlimited" chars.

so i created a blob field. but when i try to import data to it, i got
errors... or my manager hangs up (EMS SQL Manager 2005 for InterBase & Firebird Lite)

could you help me pls ? the following are the declarations i am using to
1) create the database, 2) to create a table and 3) to insert a row

CREATE DATABASE 'C:\JESUS.FDB'
USER 'SYSDBA'
PASSWORD 'masterkey'
PAGE_SIZE = 4096
DEFAULT CHARACTER SET WIN1251
---
CREATE TABLE TAB1 (
MY_HISTORY BLOB SUB_TYPE 1 SEGMENT SIZE 1 CHARACTER SET ASCII);

(i also tried with segment size 32000 but nothing)
---
INSERT INTO TAB1 VALUES ('
(here i copy/pasted 100k of text
')

do you have any idea on whats going on or how can i fix it urgently ?
thank you very very much,
j.-




---------------------------------
Preguntá. Respondé. Descubrí.
Todo lo que querías saber, y lo que ni imaginabas,
está en Yahoo! Respuestas (Beta).
Probalo ya!

[Non-text portions of this message have been removed]