Subject | Re: [firebird-support] Installation, versions and aliases.conf |
---|---|
Author | Gustavo |
Post date | 2009-05-31T16:41:30Z |
I suppose my databases only use ASCII, but may be I don?t understand exactly the problem. I read the file metadata_charset.txt, made a copy of one database, open a DOS window, and did the following:
First:
- 1. isql database.fdb
- 2. SQL> input 'metadata_charset_create.sql';
- 3. SQL> exit;
Then:
- 1. isql database.fdb
- 2. SQL> select * from rdb$check_metadata;
- 3. SQL> exit;
I saw a lot of lines on the screen mentioning objects of the database and ending with "<null>" but I didn?t see any exception.
I did the same with copies of other databases with the same result.
That means there is no need to do anything with the original databases?
First:
- 1. isql database.fdb
- 2. SQL> input 'metadata_charset_create.sql';
- 3. SQL> exit;
Then:
- 1. isql database.fdb
- 2. SQL> select * from rdb$check_metadata;
- 3. SQL> exit;
I saw a lot of lines on the screen mentioning objects of the database and ending with "<null>" but I didn?t see any exception.
I did the same with copies of other databases with the same result.
That means there is no need to do anything with the original databases?
----- Original Message -----
From: "Dimitry Sibiryakov" <sd@...>
To: <firebird-support@yahoogroups.com>
Sent: Saturday, May 30, 2009 5:23 PM
Subject: Re: [firebird-support] Installation, versions and aliases.conf
>> If you refer to the Installation Guide, when it says "If your databases contain text BLOBs storing non-ASCII data ...", then in my case I think this is not necessary because in my databases every BLOB field stores only text. Is this right what I am saying?
>
> Not quite. Don't forget, that system tables also have BLOB fields.
> And "text" != "ascii".
>
> SY, SD.
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>
[Non-text portions of this message have been removed]