Subject Changing the Database Charset
Author Tanz Anthrox
Hi!

I changed all my table's charset to WIN1251 and Collation pxw_turk. Before they were CHARSET NONE,

CREATE DATABASE "abc.gdb" USER "YOUR_USER" PASSWORD "Your_Password"
PAGE_SIZE = 4096
DEFAULT CHARACTER SET WIN1254;


UPDATE RDB$CHARACTER_SETS
SET RDB$DEFAULT_COLLATE_NAME = 'PXW_TURK'
WHERE RDB$CHARACTER_SET_NAME = 'WIN1254';


When I try to save Turkish characters it gives an error "Cannot transliterate charsets".
After so many trials I decided to Extract metadata of my Database and I see that the DEFAULT CHARSET is NONE,

I think this causes the "Cannot transliterate charsets".- error.
So,I want to change the database's default charset to WIN1251.

I dont want to recreate the database from metadata because it has lots of blobs.
1- I do not want to loose the blob data
2 -I do not know how can I export and import the blobs. If creating the database is necessary.
3- Does ALTER DATABASE can achieve this problem? I could not find any documentation on it.

Thank you for your tips.

Regards,


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