OK

Solved.

I used lc_ctype=WIN1254 parameter for Database Connection.

----- Original Message -----
From: ""Tanz Anthrox"" <tanz_anthrox@...>
Newsgroups: egroups.ib-support
To: <firebird-support@yahoogroups.com>
Sent: Monday, November 03, 2003 4:35 PM
Subject: [firebird-support] Changing the Database Charset


> 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]
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>