Subject | Changing the Database Charset |
---|---|
Author | Tanz Anthrox |
Post date | 2003-11-03T14:46:31Z |
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]
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]